Looking up the date

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:44 PM GMT

Question

What I am trying to do is look up the date (from column "B")for each instance a patient has called (using the patient number, 10201,10202 etc.)also looking under another column (same row)for the name of the visit IE; Month 1, Month 2, etc.

I want it to populate a sheet I made to track these dates per patient.


Answer

If you want to get all dates for all patients, then a pivot table may be the way to go - you didnt specify version ofso it's difficult to give specific advice, but effectively this would (presumably) show patients down the left side, description of visit along the top and the date (as a max value) in the middle. Happy to help further if required!

Advertisement

©2021 eLuminary LLC. All rights reserved.