delete rows but count data

**Leith Ross** · 01-14-2009, 05:05 PM

Hello Tortus,

Row 26 goes and row 27 stays. So, delete duplicates if there is no OK in column "D". Do you want just the value in cell "B" deleted or other columns in that same row deleted as well?

Sincerely,
Leith Ross

**Tortus** · 01-14-2009, 05:59 PM

Keep the OK rows and delete everything else.

headers should be something like this

TIME SOURCE CONDITION SOURCECOUNT STATUS LEVEL DESCRIPTION VALUE UNITS you can delete the operator also

Sourcecount should be added and should show the sum of the duplicates.

What I've done with this is record a macro that imports a text file into excel. I'm going to use the code that filters the data in this way to finnish the macro... it will be cool! I'm going to attach a file that will show what I think it should look like when done... I'm only going to use a few rows for example