S

#### SteveC

Col Ac

Apples Ship 3 Apples 1

Apples Train

Apples Train 1 2

Apples Tree

Apples Tree 2 3

Apples Ship

Pears Ball 2 4

Apples Pen

Pears Rock 1

Oranges Toy 1

Apples Pen 4

Orange Mack 2

Pears Sack 3

Had data is in the first 3 columns.

By inputting text into cell Z1, I would like to return the rank, category

and name in the Columns AA, AB and AC in order of rank. What formulas do I

use in AA, AB, and AC? Thanks a lot. I know "Max" has something to do with

it.

Stevec