Vista - how do i get excel to recognise unique values eg badge #

12-13-2007

how do i get execel to recognize unique values e.g receipt book # and pull
the relevant
information (text and number value) eg A cheque #15 , $120 was paid to
cover traveling expense. how can i put #15 in A1 and automatically get
Traveling Expenses in B2 and $120 in C3

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://windowshelp.microsoft.com/com...unts_passwords

12-14-2007

Techwiz

Please post your message to an Excel newsgroup. Here is a link for those
groups.

http://www.microsoft.com/communities...excel.newusers

--

Ronnie Vernon
Microsoft MVP
Windows Shell/User

"techwiz101" <techwiz101@xxxxxx> wrote in message
news:0A67C358-2410-49A4-82AA-E8AA4A888DB9@xxxxxx

Quote:

> how do i get execel to recognize unique values e.g receipt book # and pull
> the relevant
> information (text and number value) eg A cheque #15 , $120 was paid to
> cover traveling expense. how can i put #15 in A1 and automatically get
> Traveling Expenses in B2 and $120 in C3
>
>
>
> ----------------
> This post is a suggestion for Microsoft, and Microsoft responds to the
> suggestions with the most votes. To vote for this suggestion, click the "I
> Agree" button in the message pane. If you do not see the button, follow
> this
> link to open the suggestion in the Microsoft Web-based Newsreader and then
> click "I Agree" in the message pane.
>
> http://windowshelp.microsoft.com/com...unts_passwords

12-13-2007	#1 (permalink)
techwiz101 n/a posts	how do i get excel to recognise unique values eg badge # how do i get execel to recognize unique values e.g receipt book # and pull the relevant information (text and number value) eg A cheque #15 , $120 was paid to cover traveling expense. how can i put #15 in A1 and automatically get Traveling Expenses in B2 and $120 in C3 ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://windowshelp.microsoft.com/com...unts_passwords
My System Specs

12-14-2007	#2 (permalink)
Ronnie Vernon MVP n/a posts	Re: how do i get excel to recognise unique values eg badge # Techwiz Please post your message to an Excel newsgroup. Here is a link for those groups. http://www.microsoft.com/communities...excel.newusers -- Ronnie Vernon Microsoft MVP Windows Shell/User "techwiz101" <techwiz101@xxxxxx> wrote in message news:0A67C358-2410-49A4-82AA-E8AA4A888DB9@xxxxxx Quote: > how do i get execel to recognize unique values e.g receipt book # and pull > the relevant > information (text and number value) eg A cheque #15 , $120 was paid to > cover traveling expense. how can i put #15 in A1 and automatically get > Traveling Expenses in B2 and $120 in C3 > > > > ---------------- > This post is a suggestion for Microsoft, and Microsoft responds to the > suggestions with the most votes. To vote for this suggestion, click the "I > Agree" button in the message pane. If you do not see the button, follow > this > link to open the suggestion in the Microsoft Web-based Newsreader and then > click "I Agree" in the message pane. > > http://windowshelp.microsoft.com/com...unts_passwords
My System Specs

Similar Threads
Thread	Forum
How to get in a vbs script the sum of values of a Excel cells in a certain range?	VB Script
Red Security Badge Icon?	Vista security
How to view Excel document without Microsoft Office Excel installe	Vista General
how do i get execel to recognize unique values e.g receipt book #	Vista General
Get-unique	PowerShell