Hi all
I have list of 60k+ books, each with a publisher name. I want to find
the highest price book within each publisher, there may be any number
of books within each publisher.
I guess I need to find the rows that contain a unique publisher name
and then use MAX on the price cells, but I don't know how to identify
those cells in VBA.
I can tag the first record and last record in the list easily enough,
but I don't know how to record the rows between!
Hope you can help.
Colin
--
Colin Vicary
------------------------------------------------------------------------
Colin Vicary's Profile:
http://www.excelforum.com/member.php...o&userid=10472
View this thread:
http://www.excelforum.com/showthread...hreadid=527094