Assume row 1 either a header row or blank row and your data start in A2:A28

In B2: =IF(COUNTIF($A$2:$A$28,A2)1,MAX($B$1:B1)+(A1<A2) ,"")

copy down


"lehigh46" wrote:

On Fri, 8 Jun 2007 19:29:30 +0200, "Ron de Bruin"
wrote:

DataRefiner can insert the formulas for you if you want
http://www.rondebruin.nl/datarefiner.htm

Ron,
Thanks for the formula. It's not exactly what I was looking for but I
can use this in other applications. It works well with one of my other
spread sheets.

The end result of what I want would look like the example below.
I could then auto filter column B and just see the occurences of item
number 4, or 5, or 10, etc.

A B
1
2
3
4 1
4 1
4 1
5 2
5 2
6
7
8
9
10 3
10 3
10 3
10 3
10 3
10 3
10 3
10 3
24
25 4
25 4
26
27 5
27 5
27 5