Locate data from 3 columns in all of excel sheet

		Microsoft Office Forums > Microsoft Excel > Excel
Locate data from 3 columns in all of excel sheet

FAQ

Thread Tools

Display Modes

04-18-2016, 08:41 AM

habib90

Windows 10 Locate data from 3 columns in all of excel sheet

Office 2010 32bit

Novice

Join Date: Apr 2016

Posts: 2

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!

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:02 PM.