Microsoft Exel

  • Cactus0
  • Born
  • Born
  • Cactus0
  • Posts: 3

Post 3+ Months Ago

I am having a problem with an element of Microsoft Excel.
Namely: How to be able to get the "latest" "date" in a column of dates and to appear in an isolated cell on the same worksheet.
  • Anonymous
  • Bot
  • No Avatar
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post 3+ Months Ago

  • jflynn
  • Mastermind
  • Mastermind
  • User avatar
  • Posts: 2305
  • Loc: Baker City, Oregon

Post 3+ Months Ago

select the cell you want the date to be in.

at the top of the window click insert > function

on the drop down list select what you want

the end!
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Posts: 23456
  • Loc: Woodbridge VA

Post 3+ Months Ago

You'll probably want to use vlookup ( http://office.microsoft.com/en-us/excel ... 51033.aspx ) but I'm not sure how you'd incorporate finding the most recent date. That part's a little tricky. If you haven't figured it out by tomorrow I'll ask my accountant and see if she knows. She's pretty good with excel formulas.
  • Cactus0
  • Born
  • Born
  • Cactus0
  • Posts: 3

Post 3+ Months Ago

Thank you ATNO/TW. You seem to have got the point, and no, I still have no idea of how to go about it.

Regards
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Posts: 23456
  • Loc: Woodbridge VA

Post 3+ Months Ago

ok I'll ask her in the morning then. If she doesn't know somebody else will have to help you with the date part.
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Posts: 23456
  • Loc: Woodbridge VA

Post 3+ Months Ago

I actually figured this out myself this morning without her. (*pats self on back*). It's much simpler than I thought.

you use the =MAX() function. It was beneficial for me to learn this too because I also have a column of dates where I wanted to have the most recent date in an isolated field.

In my case my dates are in column J so my formula looks like this and it works like a champ
=MAX(J3:J29)
*note* - the cell in which you place your formula also needs to be formatted in the same date format your date column is.

More on the =MAX function here:
http://office.microsoft.com/en-us/excel ... 01033.aspx

For reference here's an entire list of all the Excel 2003 formulas. Very handy reference.
http://office.microsoft.com/en-us/excel ... 11033.aspx
  • jflynn
  • Mastermind
  • Mastermind
  • User avatar
  • Posts: 2305
  • Loc: Baker City, Oregon

Post 3+ Months Ago

ok, so I think I read the question wrong then. lol
I just thought you wanted the current date to show up....... oops!
  • Cactus0
  • Born
  • Born
  • Cactus0
  • Posts: 3

Post 3+ Months Ago

Thanks again, ATNO/TW:

I have copied your suggestion and will try it in the morning.

Sincere regards

And you too jflynn, for your input.

Best of luck to all of you.

Post Information

  • Total Posts in this topic: 8 posts
  • Users browsing this forum: No registered users and 118 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.