| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying how many results in a vlookup
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filter the results of a list based on a previous vlookup against the same list | Excel Worksheet Functions | |||
| how to return multiple results in vlookup? | Excel Worksheet Functions | |||
| functions are not displaying the results | Excel Worksheet Functions | |||
| Sorting and displaying different results | New Users to Excel | |||
| Stopping Charts Displaying Zero Results | Charts and Charting in Excel | |||
Linear Mode
