delete rows but count data

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