Formula Query

[Sniz4W]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Description
[/TD]
[TD]BILL
[/TD]
[TD]BEN
[/TD]
[TD]JOHN
[/TD]
[TD]DAVE
[/TD]
[TD]FRED
[/TD]
[TD][/TD]
[TD]CHEAPEST
[/TD]
[/TR]
[TR]
[TD]PRODUCT A
[/TD]
[TD]£0.20
[/TD]
[TD]£0.33
[/TD]
[TD]£0.14
[/TD]
[TD]£0.18
[/TD]
[TD]£0.16
[/TD]
[TD][/TD]
[TD]£0.14
[/TD]
[/TR]
</tbody>[/TABLE]

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,

 

[Aladin Akyurek]

In I2 control+shift+enter, not just enter, and copy across:

=IFERROR(INDEX($B$1:$F$1,SMALL(IF(B2:F2=H2,COLUMN($B$1:$F$1)-COLUMN($B$1)+1),COLUMNS($I2:I2))),"")