Match Multi Cells

gdavey · #1 08-19-2015, 06:42 AM

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 · #2 09-06-2015, 11:09 AM

Hi,

Can you provide a copy of you data?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Linking cells: can sub-cells move with their master-cell when sorting?	kw01	Excel	1	06-30-2015 05:02 PM
Multi Level Subtotals w 2 Grand Totals That Don't Match	DavidW	Excel	3	10-09-2014 07:08 AM
Excel Formula: return a range of cells that match	tinfanide	Excel	4	08-30-2014 07:03 AM
Copying text range of cells to different cells adds an extra line	jpb103	Word VBA	2	07-23-2014 12:22 PM
Paragraphs vanishing in multi line cells	teknetia	Word Tables	0	08-02-2009 10:50 PM