function

[MarcelG]

Say this column is H1 the first number is 55 the next is (H2)66 then a blank then number (H4)77 I would like the last number in column H to appear in say H44. If i enter a number in H32 that number will appear in H44. What ever the last number is in column H will be in H44

[Tony Valko]

Try this...

=LOOKUP(1E100,H1:H43)

EDIT:

On a side note, I suggest you change the thread title to something more specific. A moderator is sure to come along and "yell" at you for not following the forum rules.

A good thread title would be: Return the last numeric value in a column

[MarcelG]

not sure how to reply when someone answers to my post. but one answer was =LOOKUP(1E100,H2:H43) it tells me i have a circular formula. in a columns say H1 is 25 in H2 is 36 H3 is 65 I would like the last number in this column to appear in say H 20

[Tony Valko]

You have to put the formula outside of the range the formula is referring to.

For example, if you want the formula to return the last (bottom-most) numeric value from the range H1:H20, then you can not enter the formula within the range H1:H20. You have to enter the formula in some cell outside the range H1:H20, like H21.

[MarcelG]

You have put the formula outside of the range the formula is referring to.

For example, if you want the formula to return the last (bottom-most) numeric value from the range H1:H20, then you can not enter the formula within the range H1:H20. You have to enter the formula in some cell outside the range H1:H20, like H21.

I copied the formula in cell H55 but it didn't work because in the formula the range was from H2 so I changed it to H1 and it worked. Thank You. I am self taught in excel and I am trying to create budgeting software. Thanks again.

[MarcelG]

Now if I would like the last column in a page to be copied to other pages. This is a balance of a calculation that needs to be carried over to other months.

[Tony Valko]

When you say "page", do you mean worksheet?

So, you have an opening balance cell in each worksheet. You want the next worksheet to return the ending balance from the previous worksheet.

Is that what you're wanting to do?

[Pepe Le Mokko]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[MarcelG]

I am a recent user of excel and not familiar with all the terms. I guess ill learn as i go along.