| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ignore duplicates
The following formula is in K and will return the value in A when the
conditions are met. =INDEX(INDIRECT("$A$2:$A$5000"),MATCH(SMALL($H$2:$ H$5000,ROWS($IV$1:IV3)),$H$2:$H$5000,0)) Because A contains duplicate values these are returned to K I want K to only return the same value once What is the best way to achieve this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Condensing a list with duplicates to a list with non-duplicates | Excel Worksheet Functions | |||
| Duplicates in excel that aren't 100% DUPLICATES ... | Excel Discussion (Misc queries) | |||
| Find missing numbers in list, ignore duplicates | Excel Discussion (Misc queries) | |||
| ignore #N/A in a sum? | Excel Worksheet Functions | |||
| LOOKUP multiple results but ignore duplicates. | Excel Worksheet Functions | |||
Threaded Mode
