You don't need a macro

=SUMPRODUCT((A1:A1000<"")/COUNTIF(A1:A1000,A1:A1:A1000&""))

--

HTH

RP
(remove nothere from the email address if mailing direct)


wrote in message
oups.com...
How do i write a macro that will tell me how many different items in
one column?

lets say i have all the information in column"A". this information will
be such as these marks "J1","J2","J3" and so on. but J1 or J2 and so on
could repeate in the cells of that column.

how do you write a macro that will help determine how many different
marks in that column?. Thanks alot!