I am working on a spreadsheet for a project and I call for to use a function to determine what the superlative and lowest selling items be for the weeks. I entail it to look at the numbers (amount sold) but lone display the workbook (item). Which function does that?
For example:
ITEM ------- SALES
A --------------- 25
B --------------- 20
C --------------- 22
D --------------- 18
Highest Selling Item ?
Lowest Selling Item ?
I stipulation a function that will simply display "A" for untouchable and "D" for lowest contained by the ? cell.
Answers: If your facts is within A2:B5 (headings in row 1), beside items contained by A and sale surrounded by B:
Highest selling:
=INDEX(A2:A5, MATCH(MAX(B2:B5), B2:B5,0))
Lowest selling:
=INDEX(A2:A5, MATCH(MIN(B2:B5), B2:B5,0))
Match finds the positiion of the Max (or Min) in the schedule of sale amounts. Max is at #1 contained by the variety, Min is at #4.
Index afterwards shows the Item at that same position contained by the Item enumerate. #1 is A, #4 is D.
If you call for more info, make a payment more details or e-mail.
Good luck.
.