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