Which function/s should be used on a multi conditional formula?

[Chuck]

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

 

[Bernard Liengme]

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

 

[Shane Devenshire]

Hi,

What exactly are the conditions for the 12 groups?

There are probably many better ways but we need to see the conditions and
the desired final result.

Cheers,
Shane Devenshire

 

[Chuck]

Thanks for your rapid responce. It will take a bit of time to get the
conditions into an answer. I will post them as soon as I correlate them.

Thanks again.

Chuck

 

[Chuck]

Thanks for your rapid responce. The rules I posted were simplified
considerabaly. It will take a bit of time to get the conditions into an
answer. I will post them as soon as I correlate them.

Thanks again.

Chuck