Hello
I'm using this formula =COUNTIF(Formula!R10:R54,'Quality Scan 1'!S2)=0
The criteria is in a column called Test Regulations. Here is the criteria.
Test Regulations
ANCAP
China NCAP
CMVSS 208/GME
CMVSS 215
Door Pad/Arm Rest
Drop Silo Component Development
Drop Silo Decklid Development
Drop Silo Hood Development
Drop Silo Rail Development
ECE R12
ECE R17
ECE R21
ECE R25
ECE R42
ECE R631/2009
ECE R78 Euro-NCAP (Adult Headform)
ECE R78 Euro-NCAP (Child Headform)
ECE R78 Euro-NCAP (Foam Cert)
ECE R78 Euro-NCAP (Upper Legform)
ECE R78/2009
EEC 77/389
Ejection Mitigation
EuroNCAP
FMVSS 201 (IP)
FMVSS 201 (Seatback)
FMVSS 201U
FMVSS 201L
FMVSS 202A
FMVSS 203
GSO41
GTR
JNCAP
KMVSS 20
KMVSS 88
KMVSS 89
KMVSS 93/1
KMVSS 98
Korean NCAP
None
OPEC-GMNA
OPEC-GMNA GMN 9410
Site Development
TRIAS 63 (Article 18)
TWG
US (Part 581)
When I run the advanced filter it catches almost everything. It misses some the words call GTR. It will filter out some called GTR but not all of them. I cannot seem to figure out why. It filter some but not others. This is part of a sheet that contains 3500 rows and 33 columns. I do import this data from another program and it lets me save it only as a csv file. I then convert it to an xlsm file. Any help would be great.
Bookmarks