Hi, thanks for your response. I ended up using Pete's formula but yours will
definitely come in handy. Thank you.



"NDBC" wrote:

You have to put 150 manually in the first cell. Then in a2 put
IF(B3=B2,"",MAX($A$1:A1)+1) and copy it down.
The only diffeence is this puts the number for multiple items in the last
position not first but I'm sure you could modify the idea if this is
critical. This is what you will get

A B
150 Apples
Oranges
151 Oranges
Pears
Pears
152 Pears
153 Lemons
154 Limes



"FJ" wrote:

Hi, I am trying to number rows in column A using a formula. The numbering
should start with 150, not 1. The problem is that I only want the rows
numbered if the values in column B are unique. When I say €œunique€�, any
duplicate entries would be right on top of each other as shown below. The
list is already sorted. Here is an example of what I would like the
numbering to look like:

A B
150 Apples
151 Oranges
Oranges
152 Pears
Pears
Pears
153 Lemons
154 Limes

Ive played around with formulas using IF and COUNTIF, but so far I havent
had much success. I know this is probably simple, but so far I havent been
able to figure it out.

Thanks in advance for any help.