The How-To Geek Forums Have Migrated to Discourse

How-To Geek Forums / Microsoft Office

Excel Formula Needed

(2 posts)
  • Started 3 years ago by emma313823
  • Latest reply from moreeg
  • Topic Viewed 616 times


Recommended: Clean Your Mac the Easy Way with CleanMyMac 3

If you want to clean up your Mac the easy way, CleanMyMac is a great tool to get the job done easily, and it will even keep your computer clean automatically.

Unlike the competition, it also includes great tools like a Clean Uninstaller, to get rid of applications and clean up the junk that they leave behind. All with the click of a button.

Download CleanMyMac 3 for Free Today

Posted yesterday 
Posts: 1

I am trying to find out what formula I could you for this situation โ€“ any idea?

I have an ongoing worksheet with data points and dates โ€“ so



I have another worksheet which is a high level snapshot of various detail about those data points โ€“ ie grand total, averages, and some charts but I want to have a cell on that summary sheet which would show me the last weight entry from column B.

So as an example if I enter the weight for today, I want the cell on the summary sheet to automatically show today's weight value. Is there a formula I can use that would accomplish this?

Posted 3 years ago
Posts: 842

Hi Emma

If we can assume that the last date entered is the most recent date then we can use a vlookup to get what you need e.g.


The MAX statement looks for the most recent date in column A which, to Excel, is also the highest number.

Give this a try and see if it works for you.

Posted 3 years ago

Topic Closed

This topic has been closed to new replies.