ColA ColB Columnc Col Z Col AA Col Ab
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