Rubber Beaked Woodpecker
Board Regular
- Joined
- Aug 30, 2015
- Messages
- 203
- Office Version
- 2021
In A1:A10 I have the product types.
In B1:B10 I have the number of products sold.
These cells are auto populated using an array formula. However these cells can be out of order and I would like to have the highest number of sold products in A1:B1. I know I can use the sort function but is there a way to do this using a lookup table as I would rather not use the manual sort function. I use excel 2016.
Thank you
In B1:B10 I have the number of products sold.
These cells are auto populated using an array formula. However these cells can be out of order and I would like to have the highest number of sold products in A1:B1. I know I can use the sort function but is there a way to do this using a lookup table as I would rather not use the manual sort function. I use excel 2016.
Thank you