Thread: Comparing data across multiple columns and rows
View Single Post
 
Old 11-13-2021, 10:04 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
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
File Type: xlsx msofficeforums47925SampleData_v2.xlsx (17.3 KB, 5 views)
Reply With Quote