filter out the most recent exam

[hwminich]

I am exporting patient’s exam data from a SQL database via ODBC. I want to be able to find out the patient’s most recent exam date from the data I have gathered. The patient may have had 4 exams over the last 4 yrs, or they may have had only one. I need to filter out the most recent exam so that I may then calculate the elapsed time since their last exam. I am currently using a pivot table. Any tips would be appreciated...

[JohnTopley]

Attach a sample workbook (not image).

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[hwminich]

here is an example

[kvsrinivasamurthy]

Try this
ARRAY formula in G2, then drag down.

Please Login or Register  to view this content.

ARRAY formula in H2, then drag across.

Please Login or Register  to view this content.

ARRAY formula is used

To enter ARRAY formula
Paste the formula
Press F2
Press Ctrl+Shift+Enter keys together.
formula will be covered with{} brackets by excel.