Forum Discussion
Re: Finding For Specific Orders
As you can see here there are duplicate entries with different codes 20p, unknown and LOP and so on. I want to find the entries on the left that only has LOP and nothing else. if the entry has something other than an LOP I don't want it filtered. if an entry have an LOP and 20P and Unknown i do not want it filtered.. if the entry has only LOP i want to find that entry.. Does that help?
6 Replies
=UNIQUE(FILTER(A2:A19,COUNTIFS(A2:A19,A2:A19,$B$2:$B$19,"<>"&"LOP")=0))You can apply this formula.
when i plugged the formula into the cell it returned Zero, this is the formula i used
=UNIQUE(FILTER('2022 Jan-Oct Data'!A:A,COUNTIFS('2022 Jan-Oct Data'!A:A,'2022 Jan-Oct Data'!A:A,'2022 Jan-Oct Data'!$AA:$AA,"<>"&"LOF")=0))Am i doing something wrong i have over 50,000 rows?
Alternatively
=UNIQUE( TOCOL( IF( '2022 Jan-Oct Data'!$AA:$AA <> "LOP", NA(), '2022 Jan-Oct Data'!A:A ), 3 ) )It shall be relatively fast.
