Find Last Populated Cell

[Tucker2008]

Is there a way that I can write a formula that find that last populated cell in a series.

Basically, I want to create a formula that looks at an array on another tab and returns the last populate cell.

TAB 1 (Array):
Cell A1: TOM
Cell A2: <Blank>
Cell A3: <Blank>
Cell A4: Roger
Cell A5: <Blank>

Tab 2 (Formula Result):
Cell A1: TOM
Cell A2: TOM
Cell A3: TOM
Cell A4: Roger
Cell A5: Roger

Any/All help would be appreciated.

 

[Momentman]

What should the answer be for the last populated cell??, maybe if you could explain in a little more detail

 

[Stridhan]

look like you want to fill the empty with the value from above? (as when you copy from a pivot )

 

[Tucker2008]

Disregard Post....can i delete the thread?