I am trying to add to a location id any missing items from a division id.
Spreadsheet has example of spreadsheet and results
I am trying to add to a location id any missing items from a division id.
Spreadsheet has example of spreadsheet and results
Thank you for uploading a file. However, I am not a mind reader. Please explain what you have and what you want to happen. It is not obvious to me.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
in the example excel file location 12 and location 15 are in division 239.
Location 12 and 15 currently have sales listed.
I want to add the sales from the division that are not already listed in location 12 and 15.
in the example location 12 is missing 3 items listed in the division, location 12 is missing 7 items.
The results I am looking for creates the new list which includes the current sales listed in the location plus the sales listed in the division.
Let me know if that makes sense, thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks