Complex logic formula to delete values

**randell.graybill** · 11-14-2009, 02:14 AM

The concept is fairly simple but the logic is not. Basically I have some values that repeat themselves and need to be deleted when they repeat. Please see the attached file for further details (you need the additional details to answer this question).

upon further consideration I thought that it would be best to probably do everything in two passes or maybe not see below macro to get an idea of how the end process should function

Please Login or Register  to view this content.

**DonkeyOte** · 11-14-2009, 04:15 AM

Does this work for you ?

Test on a backup sheet first of course!

Please Login or Register  to view this content.

I think in reality given the almost recursive nature of the calcs you need to iterate from top to bottom ... given latter rows may appear as though they are duplicates until such time as earlier rows are removed (eg row 23)
ie you can only really determine unique nature of a given row as and when it is reached and all preceding rows have been dealt with accordingly (eg rows 21 & 22)

I suspect the above can be improved but this is more a test to see if the logic matches requirements.

**randell.graybill** · 11-14-2009, 10:23 PM

I believe I understand what you are trying to do, and yes the logic is correct, at this point the macro doesn't do anything however...the it seems it should work is when the values in column IV equal 1 in row subsequent rows then both rows should be deleted. The logic is perfect the macro doesn't delete the data...and I don't know why the macro looks sound.

**randell.graybill** · 11-14-2009, 11:35 PM

Donkey using the code you gave me I got it to work not so pretty (my code not yours) but it does the job. Thanks for the help!

Please Login or Register  to view this content.

**randell.graybill** · 11-14-2009, 11:37 PM

upon further examination it appears that it didn't delete everything in one pass...

[edit]

while the above is true it is no fault of the logic...it is due to there being a 3rd pallet with the same number...and since this happened to only 4 it is not important to fix it. thanks again Donkey.