Locate data from 3 columns in all of excel sheet

xor · #1 04-14-2016, 11:23 PM

Maybe like the attached.

habib90 · #2 04-18-2016, 08:41 AM

Quote:

Originally Posted by xor

Maybe like the attached.

Thanks, xor. I may be wrong, but it looks like the formula you used only identifies if the cells in A2:C2 are found in order in E2:G:11. Is there a way this formula can be expanded so that data in 3 horizontal, sequential cells found in A2:C11 that is duplicated in E2:G11 can be identified? Thanks for your help!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Create a New Sheet from Existing Sheet with Specific Columns	malam	Excel Programming	1	10-17-2014 10:01 PM
From an XL sheet ,how to keep the group of columns which match with other XL sheet	Zubairkhan	Excel	2	03-04-2014 10:57 PM
Copying data from sheet with deleted columns creates blanks	ZGreyArea	Excel	1	11-20-2013 10:12 AM
data linked from excel sheet	megatronixs	Word VBA	1	08-19-2012 11:09 PM
Compare data in different columns in an Excel sheet	kgfendi	Excel	5	05-16-2009 05:42 PM