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?

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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