count like numbers

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

I would like to count the like numbers in a given set of numbers. If
row 10 is different than row 9, it returns 1. If row 12 is the same as
row 11, it returns 2, and if row 13 is the same as 11 and 12 it will
return 3. (the count would never go beyond 5). For example, the left
column is given;

100 1
110 1
125 1
125 2
125 3
130 1

These will be sorted in asending order before starting. Thanks in
advance.

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***
 
Hi
enter the following formula in B1
=COUNTIF($A$1:$A1,A1)
and copy down (A stores your values)
 
Back
Top