Hi guys, hope everyone is having a good day!
I am putting a simple spreadsheet together for the tanning company I work at (not getting paid for it, just doing it in my spare time). I need this spreadsheet to find the 5 highest selling lotions for a month. Instead of just returning the 5 highest values though, I would like for a formula to return the name of the top 5 highest selling lotions. One of my concerns is that the range of data is separated into 3 different columns. (because we sell 3 different types of lotion)
This is what I have so far:
The data for units sold is in columns C, G, and K. I need the 5 highest values from all 3 columns combined (not 5 from each column). I would like a formula to calculate and display the names of the lotion, which are in columns B, F, and J, instead of just returning the 5 values in column C, G, and K.
Thanks!
I am putting a simple spreadsheet together for the tanning company I work at (not getting paid for it, just doing it in my spare time). I need this spreadsheet to find the 5 highest selling lotions for a month. Instead of just returning the 5 highest values though, I would like for a formula to return the name of the top 5 highest selling lotions. One of my concerns is that the range of data is separated into 3 different columns. (because we sell 3 different types of lotion)
This is what I have so far:
The data for units sold is in columns C, G, and K. I need the 5 highest values from all 3 columns combined (not 5 from each column). I would like a formula to calculate and display the names of the lotion, which are in columns B, F, and J, instead of just returning the 5 values in column C, G, and K.
Thanks!