AS posted at ExcelForum

=IF(A3=A2,C2,"")

--
__________________________________
HTH

Bob

"colwyn" wrote in message
...
I have Excel 2007.

There is one sheet with 2 columns of data.

Column one has a series of numbers (e.g, 111,22,3333,etc).
Column 2 has a series of terms (e.g, work,gym,home,etc).

My problem is: whereas there is a series of numbers in column 1, the
terms in column 2 only appear on the first row of each of these column
1 series.

1 work
1
1

2 gym
2

3 shop
3
3
3

I want the terms to appear every time alongside each column 1 number.

1 work
1 work
1 work

2 gym
2 gym

3 shop
3 shop
3 shop
3 shop


Can anyone supply a formula which I can put in column 3 which I can
fill down to provide the desired effect??
Big thanks.
Colwyn.