"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