Hard to tell you want is wrong when you do not show us what formulas you are
using.
Please tell us the 'rules' to place each row in a group
So far we know
Group 1: A<=179 B=500 C<A1




best wishes
-- Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Chuck" wrote in message
...
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