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

Hi Hazel,

what do you mean with "the same unique numbers"?

Have a look at this page http://www.j-walk.com/ss/excel/tips/tip15.htm
to see a clever technique to identify unique items.

Regards,
Ivan

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

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

Hi Tony

Thanks for the info Pivot tables pretty cute eh!! spent a couple of hours
fiddling about on my own and got to the answers the big chiefs wanted now
having a crack at getting a macro to do it for me.

Thanks again

--
Many thanks

hazel


"ADG" wrote:

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

Hi Hazel

If you are still liooking to write your macro, have a look at the Question I
entered "Create a New Object". Using a collection to gather the data in
memory is one option. The Example by Harold Staff is an excellent
introduction to a couple of new topics. I used an example similar to yours to
for a test and it worked well.

--
Tony Green


"Hazel" wrote:

Hi Tony

Thanks for the info Pivot tables pretty cute eh!! spent a couple of hours
fiddling about on my own and got to the answers the big chiefs wanted now
having a crack at getting a macro to do it for me.

Thanks again

--
Many thanks

hazel


"ADG" wrote:

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

Hi Tony

Thanks for the info had a look but it appears to me that my novice
capabilities couldn't cope with class modules etc -- what I usually try and
do is use the macro recorder and hope to get somewhere near what I it to do
-- will also fiddle with the code that the recorder has produced and cross my
fingers that it works -- at the moment not having much success with this --
can't even get it to sort the pivot table
--
Many thanks

hazel


"ADG" wrote:

Hi Hazel

If you are still liooking to write your macro, have a look at the Question I
entered "Create a New Object". Using a collection to gather the data in
memory is one option. The Example by Harold Staff is an excellent
introduction to a couple of new topics. I used an example similar to yours to
for a test and it worked well.

--
Tony Green


"Hazel" wrote:

Hi Tony

Thanks for the info Pivot tables pretty cute eh!! spent a couple of hours
fiddling about on my own and got to the answers the big chiefs wanted now
having a crack at getting a macro to do it for me.

Thanks again

--
Many thanks

hazel


"ADG" wrote:

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