Filter data from 2 columns

Suggest you supply criteria for keeping or removing. The term NUMBER is not sufficient.

Your sample makes no sense. Give more details about what you want.

Your workbook does not contain any manually mocked up results ...

No, sorry - makes no sense to me at all. Someone else may understand your logic.

The attachment is useless - it does not show what you are aiming for. You need a BEFORE and AFTER.

Try this: =IF(AND(COUNTIF($B$3:$B$861,B3)=1,C3<>""),"Filter out", "Keep")
This is what makes sense to me based on your explanation

First, for anyone looking at the attachments to post #8, they are csv files not xls files.

Please paste the following formula into cell J3 then copy down:

Formula:

Please Login or Register  to view this content.

This matches your expected results from post #8

You say in post #9 that PaulM100's attempt gave you an error. It may be that in your region function arguments are separated with semicolons rather than commas. If that is the case then replace all the "," in the above formula with ";"

Let us know if this works for you.

Your formula is working after changing from , to ;
But it is not working like I wanted. Just look at this

Attachment 748147
2998456500_1631914678.png

This should be all keep. But formula set two to filter out and rest to keep. Something is wrong.

When I apply my formula to your before1 file in post #8 then all 6 lines that you show in post #11 evaluate to "keep". See the attached workbook.

Let us know whether or not you still have a problem. If you do then please attach a workbook showing the problem - a workbook is much more useful than a picture.

I'm not sure what you are doing with your attachments. 14.xls is not an Excel file it's actually a CSV file that somehow has had its extension renamed

Regardless, I applied the formula that I provided to you in post #10 to your post #14 attachment and observed no problem. You note in your post #11 that the problem was that lines 75 and 76 say "filter out" but should say "keep". I don't see that. Lines 75 to 80 ALL say "keep" as you are expecting.

I do note that your post #14 file has data down to row 939 whereas the formula that I provided only goes down to row 900. I changed the formula to look down as far as row 1000 but that made no difference to rows 75-80 - they all correctly say "keep".

Attached is an XLSX file with your post #14 data and my formula applied. If the problem that you are now seeing is with some rows OTHER than 75 and 76 then please tell us explicitly what the problem is and with which lines.

No, I don't think the same products need to be next to each other. It should work fine if they are not. But if you see a specific problem, let us know.