it only works for the first highest number. I need to be able to use the same
formula for the second highest, third highest... and so on. And each time, I
need to recall the column number for each highest.
thanks,
cory
"Rick Rothstein (MVP -
VB)" wrote:
Can you explain why you can't use it? It (as well as the formula I posted)
both seem to work fine for me.
Rick
"Cory from Eugene" wrote in
message ...
I really cant use that. I tried. Any other suggestions?
"Ron Coderre" wrote:
Try something like this:
=MATCH(LARGE(A1:Z1,1),A1:Z1,0)
Is that something you can work with?
--------------------------
Regards,
Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
"Cory from Eugene" wrote in
message ...
I want to be able to search a row of number, find the largest value
(LARGE
function), and then return the Column Number of the cell. I cant quite
figure
it out.
Can anyone help?
Thanks,
Cory