how do I look up a value and return more than one result?

A

amiller

I have a range of codes that are allocated to more than one person. eg

A B C D E
Joe Blogs 1234 5678 3456 7890
Sam Brown 1234 9012 3456
Mary Poppins 1234 5678 9001
Anita Smith 5678 9001
Steven Hawkins 7890

How do create a look up or pivot table that reflects the all the people
allocate to one code.

Thanks

Al
 
D

Dylan @ UAFC

Use the subtotal on the data tab.

Evertime there is a change in column:
Count the rows, it will total the code and
then considate it and it needed hide the data not
needed to be viewsed
 
T

T. Valko

One way would be to use a formula in another column that "marks" those rows
that contain the code and then filter on that formula column. For example...

A1 = code to look for

Data in the range A3:E3. A2:E2 = column headers.

Add a descriptive column header in F2 and then enter this formula in F3 and
copy down as needed:

=IF(COUNTIF(B3:E3,A$1),"X","")

Then apply AutoFilter to your data and filter on column F = X
 

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 to find and move a value based on multiple criteria 2
Help - how could I query a memo field and get one or more 4-character data ? Tough as hell for us to 3
How do I lookup multilple criteria and return a single value 1
HOW do I make selections and carry only those selections thru proc 5
How do I filter data by more than one column in excel 0
Return more than one value with HLOOKUP 3
HOW do I make selections and carry only those selections thru proc 1
How to look up a value in a list and return multiple corresponding 2

Top