Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup and count
I have done this before a long time ago and now can't remember how to do it.
Problem with old age and not staying in practice. I want to look up items in column A and count items that match from column B. A B 1 test1 new 2 test1 new 3 test2 old 4 test1 new 5 test2 old The result I am looking for is 3 new and 2 old. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup count | Excel Discussion (Misc queries) | |||
lookup and count | Excel Discussion (Misc queries) | |||
count and lookup | Excel Worksheet Functions | |||
count in a lookup ? | Excel Discussion (Misc queries) | |||
Count and Lookup | Excel Worksheet Functions |