Hey guys, I read the available threads on row selection but still can't compile a formula to accomplish what I need (sorry - I am VERY inexperienced still..). I have a table that looks like this: Person Compound Dose Units Smith Aspirin 200 mg Smith Aspirin 150 mg Jones Gabapentin 20 ug Jones Gabapentin 30 ug Jones NyQuil 60 mL Edison Motrin 600 mg Edison Motrin 600 mg For each person, I need to look at column Compound and for each Compound, then look at doses and choose the row with higher dose. If one person had used two compounds I need to do dose evaluation for only a comp with multiple doses. So working my way through this table, I should get a new table as below: Person Compound Dose Units Smith Aspirin 200 mg Jones Gabapentin 30 ug Jones NyQuil 60 mL Edison Motrin 600 mg Can someone please help? Will be very much appreciated!!!!!
... View more