Formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bryannc - 05 Feb 2008 01:10 GMT

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 to this Message

FSt1 - 05 Feb 2008 03:00 GMT

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

> 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.
[quoted text clipped - 8 lines]
>
> Thanks!

Reply to this Message