sorting data deleting common values

Hey Guys,

Having a little trouble creating a macro.

Im trying to filter out rows with simular data in them

I have four columns of data A,B,C,D
I need a macro to run from 1 down to bottom of the spreadsheet

Here is a snipet of the csv I bring in.
1, 83.879, 8.224, -6.710,
1, 83.879, 8.224, -6.710,
1, 83.885, 8.223, -6.713,
1, 83.845, 8.223, -6.713,
1, 83.913, 8.235, -6.711,
1, 83.933, 8.244, -6.711,
1, 83.933, 8.244, -6.711,

I need my macro to pick a row (starting at 1) then run through the rest of the rows searching for another row with data matching column "B" and "C" within matching values of +/- 0.050 (if it only matches b it shouldnt do anything it needs to match b and c), then deleting the row with the higher value in "D". The value in "D" could also be the same if thats true it should delete the one it finds and continue searching through the spreadsheet.
Once its compared row 1 with the rest of the spreadsheet it can go onto row 2.

Im not sure whats the fastest way to get the macro to run, if its picking one row and comparing to the rest of rows then moving to the next row or if you guys have any better ideas as unfortunatly I have approx 56,000 rows of data to sort thru.

You've written this much clearer than I,

Just one change
___c. if row 30 'D' smaller than row 1'D' --- delete row 1 and proceed to row 2


But that would be perfect~

Hey wenqq3,

that looks great, its totally different to what I was working on this morning. Im running it now over the full 50,000 rows, and I can already see this will be another long macro.
Its basically manually sorting thru all the data comparing the info, I just cant think of how I could speed this up ? or how to rewrite it ?

Ill let you know how it goes

wabtesties.xlsxHey Wenqq3


I've attached a bigger sample, I cant seem to upload a bigger one than this.

I got a error in the code And I noticed it left a lot of repeats

=AND(B3>$B$2-0.05,B3<$B$2+0.05)

You needed the $ in the fixed column

Hey.
I cant upload the file its just too big ? do you have an email I can send it to ?