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

The files you have in test1.zip attached to your message here: https://www.msofficeforums.com/175882-post1.html
which have names like 01-02-23-BB.xlsx
are not raw data - there are formulae in them, and the results of these formulae seem to be used in the SUMIF formulae of your

I would like to see some untouched raw data files; there must be some somewhere (perhaps they're .csv or .txt files or something else?). This is so that we can let the query/queries do the necessary transformations instead of going through 2, 3 or more intermediary files, all of which, as you've seen, can introduce errors, and what's more, these make a lot of work for you to maintain all of them.
Reply With Quote