I made a chart to track out of stocks by store. I need a formula that will give me the stores with the highest outs. Sometimes there are 2 stores with the same number. How can I get excel to give me the first store with the same number in one cell and the second store with the same number in a different cell? This is the last function I need to make my project complete.
I have the LARGE function in one cell and an IF in the cell before it for the stores.
Am I making sense? I feel like the village idiot......
This is the spreadsheet that contains my data. I'm looking for the the functions to go in the top 2 stores and bottom 2 stores.
sorry forgot the attachment...
Bookmarks