Sorting some information help

[Chuck]

HI,

I have a sheet with 25 columns and up to 10000 rows. The number of rows
will always be the same for each worksheet. and contain text information
only. What I would like is a macro to show in 2 rows below the last row
for each column, how many times the text that appears in row 1 occurs in
row 2 thru (the last row) above it.

Thanks in advance

Chuck C

 

[Debra Dalgleish]

Enter the following formula in cell A10002, and copy across to column Y:

=COUNTIF(A2:A10000,A1)

 

[Chuck]

Thanks,

that worked great

Chuck C

Enter the following formula in cell A10002, and copy across to column Y:

=COUNTIF(A2:A10000,A1)