Hi,
Im looking to compare the price of items in a spreadsheet.
In the example below, Im looking for a function for the Higher or Lower column that compares Item ID "1" with itself and identifies which is the higher and lower price of the two.
<tbody>
</tbody>
Im looking to compare the price of items in a spreadsheet.
In the example below, Im looking for a function for the Higher or Lower column that compares Item ID "1" with itself and identifies which is the higher and lower price of the two.
Item ID | Price | Higher or Lower |
1 | 10.00 | Lower |
4 | 54.00 | |
3 | 23.00 | |
2 | 14.00 | |
4 | 78.00 | |
1 | 41.00 | Higher |
2 | 74.00 | |
3 | 33.00 |
<tbody>
</tbody>