Thread: Excel 2002: How to Select Greater Value of Numerous Cells?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Excel 2002: How to Select Greater Value of Numerous Cells?
Hi,

=max(A1:J1)


Mike

"Walt" wrote:

I have created a saving comparison spreadsheet. I have 5 vendors bidding to
provide replacement OEM parts at a reduced price. Now I need to select the
vendor (cell) which has the greatest savings (value).

So, I want to look at 10 cells in a row and select the cell which has the
greatest value number.

Thank-you in advance!

Walt
Reply With QuoteReply With Quote