Max figure help
 

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

Max figure help
 

Could you not use a pivot table, but rather than using the sum function
in the data part of the pivot table for the book value use Max instead


--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084
View this thread: http://www.excelforum.com/showthread...hreadid=527094