ExcelBanter - Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formula (https://www.excelbanter.com/excel-worksheet-functions/175561-formula.html)

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!

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!