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