Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need a formula for excel 2007
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error with sum formula in excel 2007 | Excel Worksheet Functions | |||
Excel 2007: get formula from charttitle | Charts and Charting in Excel | |||
Excel 2007 formula help | Excel Worksheet Functions | |||
excel 2007 formula | Excel Worksheet Functions | |||
Excel Formula, who will be age 55 by 12/31/2007 and 6/30/2009? | Excel Worksheet Functions |