Max figure help

[Colin Vicary]

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

 

[Gary Brown]

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