Evening all,

Fairly basic knowledge of Excel, but need help with a formula that is very much out of my comfort zone!!! I have a rather large spreadsheet of data that I want to present in a certain way, the spreadsheet looks like so:

location product model dixons currys comet
NW Hoover 1234 £129 £139 £ 149
NW Hoover 3456 £119 £159 £ 129
NW Hoover 5678 £189 £199 £ 139

I would like to display that info on a seperate page that will show me the lowest price by company and model that corresponds to that cheapest price.

Ideally I would like a seperate table for each location and product, so in this case i would have 1 table showing lead-in hoovers from the NW from each company, 1 table for Hoovers in the SW wth lead-ins etc etc.

Could anyone point me in the right direction please?

Many thanks

Richard