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.