| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Live" Advanced Filter (for unique records)
While using the below vb I get nothing but #N/A
What am I doing wrong? =IF(SUMPRODUCT(($A$2:$A$20<"")*1/COUNTIF($A$2:$A$20,$A$2:$A$20&""))<=COUNTA($B$1:$B 1)-1,"",INDEX($A$2:$A$20,MATCH(TRUE,ISERROR(MATCH($A$ 2:$A$20,$B$1:$B1,0)),0),1)) CSR UniqueNames Test-5 #N/A Test-5 #N/A Test-10 #N/A Test-10 Test-11 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| unique records by advanced filter | Excel Discussion (Misc queries) | |||
| Advanced Filter - extracting unique records | Excel Worksheet Functions | |||
| "Live" Advanced Filter (for unique records) | Excel Discussion (Misc queries) | |||
| Error using Advanced Filter Unique Records | Excel Discussion (Misc queries) | |||
| Inconsistent Results: Advanced Filter Unique Records Only | Excel Discussion (Misc queries) | |||
Linear Mode
