I have a large spreadsheet (20,000 records) of patient records. I need to
search the records for specific patient IDs and then analyse certain fields
of data in the patient recordset but I'm not quite sure how to go about it.

I'd like to have some code/macro that opens a dialog box requesting my input
for a PatientID field. The code should then locate the relevant records if
that patient exists and if it does look at all the records matching that
PatientID and give me the lowest value of another field (Temp) in that group
of records for that patient.

At present I just use FIND from the menu bar then eyeball the data looking
for my lowest value, but it would be nice to have it automated.

I look forward to any suggestions,

TIA,

Ian.