Hi Hazel

Just a though, base a Pivot table on the column and count the part numbers
with this. If the row headings are the same then these can be excluded from
the data in the field options.
--
Tony Green


"Hazel" wrote:

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