MrExcel Publishing
Your One Stop for Excel Tips & Solutions

calculating the lowest value in a row of pricing


Posted by mark fryer on February 01, 2002 7:50 AM

i have a row of pricing.

A2, B2, and C2. (and column headings)

I want to put in a formula to take the lowest value and put it into D2. I would also like to take the column heading from the relevant column and put it into E2.

The difficulty is I am working through a spreadsheet with over 5000 lines in it.

Please can you help.

Thanks

Mark Fryer


Posted by JohnG on February 01, 2002 8:19 AM

Formula for D2
=Min(A2:A5000)
Formula for E2
=B2 'or which ever column letter