'How do I find the left of the smallest number in a column
So the cell will say bamboo because the lowest amount in the column is 662
https://i.stack.imgur.com/ELbpE.jpg
I know how to find the lowest amount with =SMALL(B2:B17, 2) and how to find the left of the cell with =INDIRECT("RC[-1]",FALSE) But I can't use them together
Solution 1:[1]
try:
=FILTER(A:A; B:B=MIN(B:B))
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | player0 |