Thread
:
Displaying how many results in a vlookup
View Single Post
#
2
Posted to microsoft.public.excel.misc
Ardus Petus
external usenet poster
Posts: 718
Displaying how many results in a vlookup
VLOOKUP will always return one item.
To get the number of matching items:
=COUNTIF(C:C,A1)
Cheers,
--
AP
"Danhalawi" a écrit dans le message de
news:
...
Hiya,
How would I display how many results vlookup gets based on a number of
items.
So I want to look up A in table C but A is in table c 20 times so I want
the
vlookup to count and display how many times A is found
Reply With Quote
Ardus Petus
View Public Profile
Find all posts by Ardus Petus