Description | BILL | BEN | JOHN | DAVE | FRED | CHEAPEST | |
PRODUCT A | £0.20 | £0.33 | £0.14 | £0.18 | £0.16 | £0.14 |
<tbody>
</tbody>
Hi All,
I am looking for help with a formula, which I am pretty sure is quite simple for someone out there.
I have a table of data and then using the =MIN(A2,A3,A4…. Etc)it picks up the cheapest price product. As per the example above.
What I need to do is to put the name of the cheapest product(ie Bill, Ben, John…) adjacent the cheapest price. I can then filter this out to provide the reports I need.
I have been going through and looking along the line item byitem but its taking too long to sort out.
If anyone can help I’d appreciate it.
Thanks,