I am trying to organize over 5000 rows containing 3 cells (sets) of values.
The data needs to be separated into 12 catagories (groups) and ranked within
each group based on one, or more, of the values of the set.

I have tried various combinations and presently am using 12 rows, each
testing for one of the 12 catagories (groups) and then concatenating those
results to display a unique text display for each. I will then sort on them
to arrange the groups.

For the ranking I plan on using another series of rows testing for the
specific value, assigning an associated value and then sorting them.

They say a picture is worth a 1000 words and in my instance, probably 5 or 6
thousand. So:

A B C D
1 798 623 111 +IF(AND(A1<=179,B1=500,C1<A1),"Group1","")

2 121 697 001 Copy of D1

3 065 000 982 Copy of D1

4 721 348 216 Copy of D1

Cells E, F, -- contain the additional conditional tests and concatenations
to comlete the task.

I have NOT managed to complete this task, hence the purpose of this post.

IS there an easier way to do this???

I have briefly looked at VLOOKUP, Pivotal Tables, and even VBA. Rather than
trying to learn all of them, I was hoping for a suggestion from this fourm
that will point me in the right direction.

Thank you for any consideration you give this request,

Best regards,

Chuck