NewToVBA
asked on
Excel VBA - Find Address of a Cell with Largest Value in a Category
Hi Experts! How do I find address of a cell with largest value per category of cells in a range, using VBA? I have a large file and doing it through a formula takes too much RAM, and takes too much time. "=MAX(IF($A$2:$A$33=D2,$B$ 2:$B$33))" , so I want to do it with an efficient macro.
Cheers, N2V
Address-of-Cell-with-Largest-Val.xls
Cheers, N2V
Address-of-Cell-with-Largest-Val.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Glad to help. Thanks for the grade.
Thomas
Thomas
ASKER
Many thanks, Thomas, well done!
Cheers, V