How can I Filter a sheet to exclude some datas of another sheet ?

  • Thread starter Thread starter Bruno Baguette
  • Start date Start date
B

Bruno Baguette

Hello,

I have a sheet A with several datas and I want to remove all the lines where
the C column contains some data which is present in a sheet B, column A.

In other words, if 'Marcel' (in the C column of the A sheet) is present
somewhere in the column A of the B sheet, then I want to remove it from the
A sheet.

How can I do that ?

Thanks in advance !
 
Hi

Use a helper column alongside your existing columns on sheet A. If your data
starts in row 2, in D2 type

=COUNTIF('SheetB'!A:A,C2)
and fill this down the column
This will give you a count, for each row, of how many times it appears in
the other column. You can then use Data / Filter / Autofilter to filter your
list to only show quantities over 0, and delete those rows.

Andy.
 
Back
Top