#17
|
||||
|
||||
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. |
#18
|
|||
|
|||
that data is kind of "raw data" for me. i dont make those. Each month those delivered to me that way, all 56-62 of them. so changing to database type is another hurdle. this is what im working with. if improvement not possible, i'll make do with what i got.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Vlookup help | mance006 | Excel | 3 | 08-05-2021 03:19 AM |
Tell me which place the vlookup was successful (within a nested vlookup) | Izzii0x | Excel | 2 | 07-18-2019 10:29 PM |
How can I return Vlookup only if Specific Criteria is met in 1 column of the Vlookup Array | EcommDOC | Excel | 7 | 01-22-2018 11:00 AM |
something like VLOOKUP | hanvyj | Excel | 4 | 03-13-2012 09:03 AM |
Vlookup | Karen615 | Excel | 4 | 09-12-2011 02:30 PM |