| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
unique records formula
=IF(ROWS($A$3:A3)<=$A$1,LARGE(IF(SUBTOTAL(2, OFFSET($C$11:$C$16,ROW($C$11:$C$16)-ROW($C$11),,1)), $C$11:$C$16),ROWS($A$3:A3)),"") I need to alter the above formula to remove the duplicates and list the top (five) highest unique records only. The table is already in auto filter mode. Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unique records in pivot table - formula? | Excel Discussion (Misc queries) | |||
| unique filter results in some non-unique records. | Excel Discussion (Misc queries) | |||
| Extracting unique records by formula | Excel Discussion (Misc queries) | |||
| Unique Records | Excel Discussion (Misc queries) | |||
| unique records | Excel Worksheet Functions | |||
Threaded Mode
