On Apr 29, 12:34*am, Rex wrote:
I have a spreadsheet with 26 columns of info that’s approx. 1000 rows long. *
I need to sort by column L and then Column I. *When done sorting I will have
multiple names (different every report) in column L and multiple medical
conditions (different every time) in column I. *The goal is to keep one row
of each name matched with one entry of each medical condition (sorted for
that name) and hide all the other rows. *

Daffy Duck may have 15 entries with a broken elbow and 13 entries with the
flu. *I only want one row of each condition associated with Daffy Duck to
appear (it doesn't matter which row) and the rest of the rows would be
hidden. *This would continue thru all the names and conditions. *Anyone have
any macro suggestions? *I use Excel 2003.

--
Rex Munn

Best is to use pivottable.which will sort and return the unique.