Which Is Most Accurate ? Delete Dupe Rows Top to Bottom - or - Bottom to Top ?

.
As the title asks ... would it result in more accurate results to delete duplicate rows from the Top Down or from the Bottom Up ?

New rows of data are periodically added to the database to the first available empty row from the top down.

A duplicate row of data could be entered sometime after as an effort to correct faulty data in the previous entry, resulting in two rows with
identical data in Col A.

So ..... focusing on Col A data only ... the intent of the macro is to delete the oldest of the two rows ... which at this point would be above
the last entry. Example: entry one ... row 5 / entry two ... row 23

I have two macros: #1 searches from the bottom up and deletes the newest entry. #2 search from the top down and deletes the oldest entry (this is the goal).


Will it be 100% accurate to use the macro that search from the top down ... or might there be errors at some point ?


Thanks for looking.

.
Thank you bakerman

I was told when performing a search (? or was that a sort, it's late and my mind is fuzzy) it is always better to start at the bottom and work up. If you start at the top and work down, Excel has a
tendency to miss a row or two.

My question was based on that same thought process.

I've never seen any comment re: deleting ... if it made a difference.


There are several websites that recommend only going from bottom to top and if necessary sort the rows first. That is an option but it adds
one more thing to "go wrong". If possible I'd like to not sort first.

.
Here is the macro currently used :

Please Login or Register  to view this content.

Comments / suggestions ?

.
Here is a representation of the data. You will notice there is a yellow highlighted cell A (first entry) and immediately below is the same row of data not highlighted (identical entry
added after the original).

I need to be able to delete the yellow highlighted row, leaving the newest entry in place.

	A	B	C	D	E	F	G	H	TY
5	Contract #	Agency	Contract Vehicle	Project Name	Subcontractor (Tier 2)	Subcontractor (Tier 3)	Job task / ECM	LOCATION	Date (MM/DD/YYY)
6	W#####-01-A-#### TO-0010	GHI-12345	UMCS	Project 04	Subcontractor 04	Subcontractor 07	6.01	Mars	2/3/2019
7	W#####-01-A-#### TO-0009	JKL-12345	UESC	Project 07	Subcontractor 09	Subcontractor 11	4.03	Mars	2/23/2019
8	W#####-01-A-#### TO-0009	JKL-12345	UESC	Project 07	Subcontractor 09	Subcontractor 11	4.03	Mars	2/23/2019
9	W#####-01-A-#### TO-0011	JKL-12345	UESC	Project 07	Subcontractor 09	Subcontractor 11	4.03	Saturn	2/27/2019
10	W#####-01-A-#### TO-0012	ABC-12344	ESPC	Project 01	Subcontractor 01	Subcontractor 02	3.02	Neptune	2/29/2019

The yellow color is provided for clarification purposes and does not appear in the original.

.
shg

I was wondering about sorting the data first but had not implemented it.

Thank you for the solution. Works great !

Thanks to everyone for contributing.

Cheers.