Match Multi Cells

[gdavey]

Hi

I was wondering is it possible to match content in 5 rows.



I am running SQL quires weekly however some of the data will always keep appearing and needs removed. Currently this is a very manual task, I manually go through and take out what I know is a repeat from the previous week.

Is it possible to keep a list of what I want to remove and match this data.

V lookup wont work as I need to match more than one column

hope this makes sense.

Thanks

[charlesdh]

Hi,

Can you provide a copy of you data?