Macro to Find the Max ?

P

Peter T

=INDEX(B1:B100,MATCH(MAX(A1:A100),A1:A100,0),1)

where the range you want to search Max is A1:A100 and you want to return the
cell in B1:B100.

Regards,
Peter T
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

find largest column width and ... 4
question about excel formulae 1
VB excel help needed 1
copy and past numeric values only 3
Can I use a macro to create a macro in a new workbook? 3
HOW TO FIND THE MEREGED CELL 3
consolidate historical stock returns from multiple workbooks into oneworkbook 1
How to match debit and credit line item 1

Top