Sorting some information help

  • Thread starter Thread starter Chuck
  • Start date Start date
C

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
 
Enter the following formula in cell A10002, and copy across to column Y:

=COUNTIF(A2:A10000,A1)
 
Back
Top