formula to fill in blanks

[watchthisspace]

Hello

Im after a formula which poulate a cell with a number and copy it down until it comes across a different number.

For example in the attached spreadsheet the numbers are in column A and id like to get the results which shown in column C but done by a formula. So in cell C2 it would pick up the number in A2 until and copy until there was a different number in column A.

Hopefully that is clear and any help will be greatly appreciated.

[Richard Buttrey]

Hi,

The workbook wasn't attached. The paperclip 'attach item' isn;t working. Use the 'Go Advanced' option on the bar at the bottom of the post and look underneath the post for the 'Manage Attachments' option.

[chullan88]

Hello

Im after a formula which poulate a cell with a number and copy it down until it comes across a different number.

For example in the attached spreadsheet the numbers are in column A and id like to get the results which shown in column C but done by a formula. So in cell C2 it would pick up the number in A2 until and copy until there was a different number in column A.

Hopefully that is clear and any help will be greatly appreciated.

Try in C2

Please Login or Register  to view this content.

[watchthisspace]

Thanks for the heads up. Ive now attached it.

[watchthisspace]

Thanks for this. It doesnt do exactly what im after. For example its not putting anything in cell C3 except 0 where I would like it to show the number until a new one is in column A.

[chullan88]

In C2

Please Login or Register  to view this content.

[watchthisspace]

In C2

Please Login or Register  to view this content.

Hello

Thanks that seems to work fine. But what if it was letters and not numbers?

Thanks again

[chullan88]

You could replace 9E+99 with "zzz"


If that solves your problem,please take time to mark the thread as solved and Add Rep for all members who have helped reach your solution.

[Phuocam]

A2 is number:

=LOOKUP(10^20,$A$2:A2)

A2 is text:

=LOOKUP("zzzzz",$A$2:A2)

A2 is number or text:

=LOOKUP(2,1/($A$2:A2<>""),$A$2:A2)