Excel Question help needed

[Legacy 465601]

I have this spreadsheet and I need to build a formula to catch dates needed from a worksheet that has multiple dates and I need only the current and the one prior to the current Date.

I am using SSN # as my unique ID to vlookup the old and the new dates but some SSN’s have multiple dates and I don’t know how to catch only the current and the date prior to the current. Any suggestions will be appreciated!

 

[alansidman]

I have asked that you show us a mocked up solution to your problem. Still awaiting as I don't really understand what you are looking for.

 

[Legacy 465601]

I have asked that you show us a mocked up solution to your problem. Still awaiting as I don't really understand what you are looking for.

It’s been loaded in the thread

 

[Fluff]

Cross posted Excel Formula/function help needed

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[Legacy 465601]

Cross posted Excel Formula/function help needed

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

Thanks, I’m new to this so still learning

 

[alansidman]

I clearly don't understand what you have posted as a solution. Please explain the results (which table of the two are the mocked up solution and how you would determine that.)

 

[Legacy 465601]

I clearly don't understand what you have posted as a solution. Please explain the results (which table of the two are the mocked up solution and how you would determine that.)

Hi there, I’ve already received help and solution. You can disregard. Thanks for your time

 

[mikerickson]

=MAXIFS(K:K, A:A, 111111111) will return the most recent date from column K for the SSAN 111111111

 

[Legacy 465601]

=MAXIFS(K:K, A:A, 111111111) will return the most recent date from column K for the SSAN 111111111

awesome thank you for the suggestion!! I appreciate it so much