# Locate latest cell entry in column

1. ## Locate latest cell entry in column

My brain is fried from sifting thru the vast forum trying to find a similar solution, but can't nail down a specific post to apply. Many are "close, but no cigar."

Cells B75 and C75 need to show the latest entries from the array B2:C73, respectively.
Cell D76 needs to show the latest entry from the D2:D73 array.
The correct formula result will be the data in row 66.
As game results are added in rows 67 and so forth, the results in B75, C75, and D76 will adjust to the latest entries.
I removed the formulas in columns A:D, which refer to game results from another worksheet...I'm just looking to reference the latest win-loss steak and last 10 games.

2. ## Re: Locate latest cell entry in column

If you delete the contents from rows 67 downwards (or get your formulae to return ""), then you can use these formulae in the cells stated:

B76: =LOOKUP("zzz",B2:B73)

C76: =LOOKUP(1000,C2:C73)

D76: =LOOKUP("zzz",D2:D73)

"zzz" is just a big text value (i.e. "larger" than those expected in your data), and 1000 is a bigger number than those in your data.

Hope this helps.

Pete

3. ## Re: Locate latest cell entry in column

Hi, pskwaak!

You could try:
[D75] : =LOOKUP(2,1/(D2:D73<>""),D2:D73)

What is the desired result in B76 and C76? Write by hand this values, because i don't understand exactly. Blessings!

4. ## Re: Locate latest cell entry in column

The one for C76 worked, but B76 and D76 did not ... results in a blank. Is it something to do with looking up text rather than numbers?
Thanks!

5. ## Re: Locate latest cell entry in column

The D75 formula works! The correct answer to the formulas for B76 and C76 should reference row 66 ("L" and "3"). Using the same formula you provided for D75 also works in B76 and C76! Thanks so much for the help!

6. ## Re: Locate latest cell entry in column

OK, Pete, I see the problem. It worked with my sample workbook submitted, but the original one I'm working with has formulas that produce the 0. Can you modify your formula to look at results of the data formula and not just a blank cell?

Editing this reply: Forgot to mention that the data in column D are results of concatenate formulas and not manual entries.

I'm self-taught in Excel basics and use this forum and other sources to learn. So your post is an alternative to what I was looking for...and helps me "see" other ways to use data. Thanks!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1