LinkBack URL
About LinkBacks
Is there a way to take this file and delete duplicates found in column B but count all of the duplicates with OK in column D? Would be ok to add a column to the sheet that shows count.
Is there a way to take this file and delete duplicates found in column B but count all of the duplicates with OK in column D? Would be ok to add a column to the sheet that shows count.
Hello Tortus,
After looking at the file, I am not sure what criteria you are using for a duplicate. There are other columns that, seem to me, could influence the decision, like the date/time. Is the entire row to be deleted if a duplicate is found?
Sincerely,
Leith Ross
column B would be the duplicates. column B shows the points that alarm and they need to be counted but they don't need to be duplicated in the sheet.
example would be row 26 should be deleted and row 27 stay and in a new column beside column B should show a 2
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
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
Last edited by Tortus; 01-14-2009 at 06:08 PM.
I used the first 2 Source tags to show the example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks