Hi

I got that one wrong eh!! The number is a part number so it could be
repeated on several rows through out Column D. For example the number could
be BG09Z56743 all the part numbers have 10 digits and I suppose they are
unique as each number refers to a specific part of the build project. My
bosses at this end want to know the number of times in a specific period that
it is ordered.
--
Many thanks

hazel


"Hazel" wrote:

Hi All

I have an Excel Sheet named "Stats"and Column D contains a list of
alphanumeric numbers down to row 2000 after every 20 rows there are 2 rows of
headings is it possible to have a routine that will find the same unique
numbers all the way down to row 2000 and copying them across to Column E on
finding the same number no matter how many times it appears -- and without
the 2 rows of headings affecting the search capability.
--
Many thanks

hazel