Thread
:
Find the most recent date
View Single Post
#
3
Posted to microsoft.public.excel.misc
Access Joe
external usenet poster
Posts: 54
Find the most recent date
Hi Sandy,
Thanks for the response. I'm not familiar with array formulas so I have two
questions:
a - where would this formula be entered (i.e. column C next to each date)
b - what's the purpose of the CTRl / Shift / enter thing? Never seen that
before and don't know what it means.
Thanks,
"Sandy Mann" wrote:
With ID in Column A and Date in Column B try:
=MAX((A2:A8=2)*(B2:B8))
This is an array formula which must be entered with Ctrl + Shift + Enter
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Access Joe" wrote in message
...
Hey all,
Is there a way to find / fitler by the most RECENT date entry. I.E. I
have
the following data set:
ID DATE
1 12/2/2006
1 12/7/2006 (this is the date I want displayed for THAT patient ID)
2 4/6/2007 (this is the date I want displayed for THAT patient ID)
2 7/7/2006
3 9/9/2007
3 8/7/2007
3 9/10/2007 (this is the date I want displayed for THAT patient ID)
You see, each patient comes in on different dates. What I need to see and
analyze are JUST those dates for each patient that were the most recent.
Is
there a way to perform a filter that does this?
Thanks!
Reply With Quote
Access Joe
View Public Profile
Find all posts by Access Joe