count like numbers

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 ***
 
F

Frank Kabel

Hi
enter the following formula in B1
=COUNTIF($A$1:$A1,A1)
and copy down (A stores your values)
 
Top