Comparing data across multiple columns and rows

		Microsoft Office Forums > Microsoft Excel > Excel
Comparing data across multiple columns and rows

FAQ

Thread Tools

Display Modes

11-13-2021, 10:04 AM

p45cal

Windows 10 Comparing data across multiple columns and rows

Office 2019

Expert

Join Date: Apr 2014

Posts: 947

In the attached formula in column H.
You can see the steps used to building the formula in hidden columns E:G, but these columns aren't needed at all.
There's a comment in cell H47.

Attached Files

msofficeforums47925SampleData_v2.xlsx (17.3 KB, 7 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Merging all data between two sheets into a third one without duplicates or rows or columns	Ricko_uk	Excel	4	08-27-2020 01:16 AM
Transpose multiple data form rows in columns matched with a key	Alex1s85	Excel	6	06-24-2020 07:08 AM
How to Loop through rows and Columns to Offset Data	Josh1012	Excel Programming	4	09-06-2018 03:20 AM
Hide rows in multiple columns based on zero values	Deane	Excel Programming	19	06-23-2015 11:24 PM
macro for comparing data from 3 columns and pasting into another worksheet	ashukla	Excel	1	06-24-2009 05:01 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:53 AM.