Thread: Match values on different columns based on criteria
View Single Post
 
Old 02-21-2021, 06:03 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 871
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
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
File Type: xlsx msofficeforums46519Excel question.xlsx (19.7 KB, 13 views)
Reply With Quote