Grouped data

[iggator2003]

If I have a spreadsheet with data such as:

Column A, Column B
123, 111
null, 112
null, 113
124, 111
null, 112
null, 113
etc.....

Is there a formula I can use to get the null cells to look at the value in the cell and have them copy down until the next value? So the data would be:

Column A, Column B
123, 111
123, 112
123, 113
124, 111
124, 112
124, 113
etc....

??

 

[Andrew Poulsom]

Select the cells in column A and choose Edit|Go To|Special, check Blanks and click OK. In the formula bar type =, point at the cell above and press Ctrl+Enter.

 

[iggator2003]

Thanks! Would you happen to know how to get to Edit|Go To|Special from Excel 2010?

 

[Andrew Poulsom]

It's under Find & Select at the right of the Home tab, or press Ctrl+G.

 

[iggator2003]

Perfect...thanks again!