show if more than one line of data
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 |
All times are GMT +1. The time now is 09:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com