View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default Big Trouble with what I thought would be a simple Excel Formula

Makign sure I udnerstadn..

You are in, say, cell A4. You want to have a forula enter the largest value
from row 4 in other columns.

If that's it, do:

=MAX(B4:Z4)

"Flip@work" wrote:

I want a cell from one column to display the value of the top of another set
columns from the highest valued cell of the corresponding row. Is that
possible?