Jenn_Mullen
New Member
- Joined
- Jul 28, 2009
- Messages
- 8
Good morning everyone, Technical logic: I need a formula that can compare 20 values in cells horizontally and return the value that is the lowest.
Business Logic: I have a list of 250+ items listed vertically, one item per row. In the row horizontally, I have a column for each price quoted by different suppliers. I need a formula to look at the 20 prices and select the lowest value and return it.
Business Logic: I have a list of 250+ items listed vertically, one item per row. In the row horizontally, I have a column for each price quoted by different suppliers. I need a formula to look at the 20 prices and select the lowest value and return it.
