View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
colwyn colwyn is offline
external usenet poster
 
Posts: 29
Default I need a formula for excel 2007

On Oct 20, 11:22*am, colwyn wrote:
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.




Sorry, I explained this slightly wrong. Please read following for
better explanation of what I'm after.


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

1
1
1
1

2 gym
2

2
2
2
2


3 shop
3
3
3

3
3


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

1 work
1 work
1 work

1 work
1 work
1 work
1 work

2 gym
2 gym

2 gym
2 gym
2 gym
2 gym

3 shop
3 shop
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.