Hey guys, new to the forums.
I have comparisons that I need to do, that I've been going through manually for thousands of lines of data - I need to speed this process up.
My format is this:
STORE / SKU / QTY
Each store will have multiple entries for all of their stock, with MULTIPLE entries of SKUs and QTY's, example (ALL stores are on the same sheet):
STORE A / 123 / 5
STORE A / 123 / -3
STORE A / 125 / 3
STORE A /125 / -3
etc...
There are roughly 60 stores that might have a positive and negative (of the same sku) QTY based off different days of inventory counts - the day of the count does not matter to me as stores find and miss counts of stock all the time.
BUT, I need a way of seeing a MATCH of QTY, SKU, and STORE easily AND/OR a NON match of QTY, SKU, and STORE.
In my head I was thinking a conditional formatting option to at least highlight the match of SKU per STORE and then I can manually look to see if the values are the same or different, but if I can add a third option onto that to see if the values match or are different then that would be the cat's meow.
Thanks in advance for any assistance!
I have comparisons that I need to do, that I've been going through manually for thousands of lines of data - I need to speed this process up.
My format is this:
STORE / SKU / QTY
Each store will have multiple entries for all of their stock, with MULTIPLE entries of SKUs and QTY's, example (ALL stores are on the same sheet):
STORE A / 123 / 5
STORE A / 123 / -3
STORE A / 125 / 3
STORE A /125 / -3
etc...
There are roughly 60 stores that might have a positive and negative (of the same sku) QTY based off different days of inventory counts - the day of the count does not matter to me as stores find and miss counts of stock all the time.
BUT, I need a way of seeing a MATCH of QTY, SKU, and STORE easily AND/OR a NON match of QTY, SKU, and STORE.
In my head I was thinking a conditional formatting option to at least highlight the match of SKU per STORE and then I can manually look to see if the values are the same or different, but if I can add a third option onto that to see if the values match or are different then that would be the cat's meow.
Thanks in advance for any assistance!