Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula
i am working in a spreadsheet that has usage by week. what i want is for it
to look at the cells and give me the highest usage week. Example A1 = 50 B1 = 100 C1 = 200 i want D1 to pull up. Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula
hi
if you just want to know the highest usage then use this formula =max(A1:C1) if you want to know the address of the highest useage use this formula =ADDRESS(MAX((A1:C1)*ROW(A1:C1)/MAX(A1:C1)),MAX((A1:C1)*COLUMN(A1:C1)/MAX(A1:C1)),4,1) the above is an array formula and must be enter with Ctrl+shift+enter not just enter. using xp2003 here Regards FSt1 "bryannc" wrote: i am working in a spreadsheet that has usage by week. what i want is for it to look at the cells and give me the highest usage week. Example A1 = 50 B1 = 100 C1 = 200 i want D1 to pull up. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|