ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   "Live" Advanced Filter (for unique records) (https://www.excelbanter.com/excel-programming/394682-live-advanced-filter-unique-records.html)

David A.

"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



All times are GMT +1. The time now is 08:29 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com