"wwj" wrote:

Thanks, SteveS.

I got it!

One more question. If the data is not listed in column "A", "B", "C"
and "D". However they are listed in the same column, but in defferent
sections, as A1:A4, A5:A8, A9:A12 and A13:A16 instead. If I want you
get the maximum of (A1, A5, A9, A13) in E1, and get the address of the
maximum number in F1. How can I do that? Seems that the following
function will not work.

=ADDRESS(ROW(),MATCH(E1,{"A1","A5","A9","A13"},Â*0 ),1)

WWJ


It looks like I gave you your homework answer the last time. Since I have
already beenthere and done that, this time I will give you a push in the
right direction.

You know about the Max() function.

Next, study the Match() function and its arguments.

And you already know about the Address() function. Read it again. See what
arguments it needs.

If you use all three of the functions, you can generate the cell address of
the max value of a column of numbers.

Good luck!!
---
SteveS
--------------------------------
"Veni, Vidi, Velcro"
(I came; I saw; I stuck around.)