I have a list of patients and their services. Patients(A) and their
number(B) are listed in Red. If the patient had services then the service
data appears below their name in black (name=name, column A) and the service
code (C)...
so if A1=A2 then delete that section (rows). Can have 1 to 50 lines of
services... or none. Its the none that only appear with the 1 red line and
their number that I want to pull out a little quicker.

I already ran a macro that adds a blank line every time the name changes....
so there is a blank line between patients.....

I'd remove all the blank rows in the table, so the list is easier to
work with.

Then, add another column (e.g. Service) to the table, in which you
calculate the number of rows for each patient.

For example, with names in column A, enter the following formula in the
Service column:

=COUNTIF(A:A,A2)1

Copy the formula down to all rows of data

Select a cell in the table, and choose DataFilterAutoFilter
From the dropdown in the Service column heading, choose FALSE


jenn wrote:
I have a list of patients and their services. Patients(A) and their
number(B) are listed in Red. If the patient had services then the service
data appears below their name in black (name=name, column A) and the service
code (C)...
so if A1=A2 then delete that section (rows). Can have 1 to 50 lines of
services... or none. Its the none that only appear with the 1 red line and
their number that I want to pull out a little quicker.

I already ran a macro that adds a blank line every time the name changes....
so there is a blank line between patients.....


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html