I really should stop thinking that mine is a unique question and has
not been answered before.

I found the answer in the search function

the answer that works for me is

=LOOKUP(2,1/(1-ISBLANK(r1:r1000)),r1:r1000)

From now on search first ask question later....

pano wrote:
Hi all, the problem ...in a column I may have a user enter a receipt
number which is incremental so day 1 seperate sheet may have no
receipts and day two (seperate sheet) may have 3 receipts. I want to be
able to pull out the last receipt number from the column for auditing.

Day 1
column a column b column c

day 1 nothing
so use the last receipt number on other worksheet
Day 2
5555



5556

receipt 5556 will be placed as last receipt number day 2 on other
worksheet.

Hope you can help