Thread: [Solved] VLOOKUP with max value
View Single Post
 
Old 06-24-2023, 09:40 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2021
Expert
 
Join Date: Apr 2014
Posts: 948
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

See attached.
Also added column AA outside the pivot. Not sure yet how to add grand total to rows without also 'adding' the machine IDs
Attached Files
File Type: xlsx MSOfficeForums50983v02.xlsx (177.0 KB, 3 views)
Reply With Quote