hello,

I'm trying to return a value based on revision of a duplicate number.
For example I have the following lists on two separate sheets.

Sheet 1 Database
Column A Column B column C
NAME REVISION date
Wheel 1 xx
Tire 1 xx
Tire 2 zz
Window 1 xx
Tire 3 aa
Hood 1 xx


Sheet 2 - results
Column A Column B column C
Name revision date
Wheel 1 xx
Tire 3 aa
Window 1 xx
Hood 1 xx


I would like to return in sheet two the greatest values found from
sheet one based on revision.

So I assume I would have to return the cell array of duplicates then
compare the revision number and based on that revision return a cell.
Though I'm not sure how to go about it?