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

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

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

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

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

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" 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

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

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

"Shane Devenshire" wrote:

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" 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

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

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

"Bernard Liengme" wrote:

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