Match values on different columns based on criteria

		Microsoft Office Forums > Microsoft Excel > Excel
Match values on different columns based on criteria

FAQ

Thread Tools

Display Modes

02-21-2021, 06:03 AM

p45cal

Windows 10 Match values on different columns based on criteria

Office 2019

Expert

Join Date: Apr 2014

Posts: 956

Not especially easy.
In the attached:
1. In Sheet1 a solution which may not work in Excel 2016 involving FILTER and UNIQUE.
2. In Sheet2 a Power Query in cell H1. Right-click and choose Refresh to update.

Attached Files

msofficeforums46519Excel question.xlsx (19.7 KB, 15 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Create a unique list of values that match a criteria, sorted in order of another criteria	BradRichardson	Excel	2	01-03-2017 12:25 AM
Count unique values that match 2 or more criteria	caeiro01	Excel	1	10-25-2015 02:34 AM
Hide rows in multiple columns based on zero values	Deane	Excel Programming	19	06-23-2015 11:24 PM
transpose values based on mulitple criteria	mlttkw	Excel	1	12-06-2013 02:00 AM
Change values in cells based on criteria	SaneMan	Excel Programming	2	02-02-2012 07:58 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:36 AM.