how do i get execel to recognize unique values e.g receipt book #

T

techwiz101

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
 
A

Andre Da Costa[ActiveWin]

Start by asking this question in the appropriate newsgroup:
microsoft.public.excel.worksheet.functions
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i get execel to recognize unique values e.g receipt book # 1
how do i get excel to recognise unique values eg badge # 1
How can I do amalgamate 3 select queries and then get unique entries from the result 2
How do I get Outlook to recognize commas in between address lists. 1
How do I get unique values from 2 columns? 2
How to Sort by Count the Max nos of Unique text values in Pivot Ta 1
How do I get Access to recognize duplicate values immediately? 13
Find data in table with to set of constant values 4

Top