Looking for max value from an array containing multiple instances. Example below. Thanks!
Sample:
Desired output:
Sample:
Book2 | ||||
---|---|---|---|---|
A | B | |||
1 | Item | Price | ||
2 | Apple | 1 | ||
3 | Banana | 2 | ||
4 | Apple | 3 | ||
5 | Pear | 4 | ||
6 | Orange | 5 | ||
7 | Apple | 6 | ||
8 | Banana | 7 | ||
9 | Orange | 8 | ||
Sheet1 |
Desired output:
Book2 | ||||
---|---|---|---|---|
A | B | |||
1 | Item | Price | ||
2 | Apple | 6 | ||
3 | Banana | 7 | ||
4 | Pear | 4 | ||
5 | Orange | 5 | ||
Sheet2 |