• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot table to show patients last 5 lab values

S

sbexcel

New Member
Hello all,

I am stumped by this request. I have a table with about 300 patients and their medical lab history for a particular test. I want to show each patients' last 5 lab values in date order. The lab history is for two years and patients may have had their tests on any date in the two year range.

I was thinking this would be easy with a pivot table, but the date has me stumped. Is there some way to RANK the tests by patient and by date?

Thanks
Sasha
 
Sasha

Firstly, Welcome to the Chandoo.org Forums

Right Click on the Date field
Select Sort
Then Right click on the Date Field
Select Top 5
 
Perfect, Hui. Thanks for the reply! Now, any idea how I could show the trend?

For example, Patient ID10836 has four lab values on record and is trending UP. I show the AVG lab value (which is just the lab value as there is only one per date) and then the Rank. Ideally, I'd like to just show ID10836 and the Trend (Rising). Perhaps a pivot table isn't the way to do this?

ID10836 6.575
5/1/2014 6.8 4
9/4/2013 6.7 3
3/14/2013 6.4 2
9/13/2012 6.2 1

Thanks,
Sasha
 
You must log in or register to reply here.
Back
Top