P
Parlatoc
I'm working in Excel 2003, and have run into an issue I'm not sure ther
is a solution. If there is I don't know.
I have a several responces for 15k+ IDs:
These responces were supplied by a survey, they range from 0.001 t
100.0
NEEDS Value
a1 Reward Value
b1 Control Value
c1 Rate Value
d1 Advice Value
I've taken the value / # of IDs and found the % of the value based o
the average responces for that Need. I''ve assgned them a decil
value 1-10.
NEEDS Decile
e1 Reward Decile
f1 Control Decile
g1 Rate Decile
h1 Advice Decile
Next I've found the Max Value for both Value and Decile.
Now I'm trying to put for each user their highest need based on decil
and there second highest need. example. ID 1 Highest Decile was
-Control and second was 7 - Advice.
Not sure how to do that in the first place. Expecially for 15k
Records.
Now another problem. If there is a tie for Decile, Example ID 1
both control and active are both 10. Then to compare the value fo
Control and Active and the primary would be the highest and the secon
Highest would be Secondary.
I haven't a clue if this is posible or evern the best way of doing it
If you can't tell me the how do solve this, then if there is a way t
find Primary and then Secondy on a generic level, that would be good a
well
Attachment filename: sample.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=63590
is a solution. If there is I don't know.
I have a several responces for 15k+ IDs:
These responces were supplied by a survey, they range from 0.001 t
100.0
NEEDS Value
a1 Reward Value
b1 Control Value
c1 Rate Value
d1 Advice Value
I've taken the value / # of IDs and found the % of the value based o
the average responces for that Need. I''ve assgned them a decil
value 1-10.
NEEDS Decile
e1 Reward Decile
f1 Control Decile
g1 Rate Decile
h1 Advice Decile
Next I've found the Max Value for both Value and Decile.
Now I'm trying to put for each user their highest need based on decil
and there second highest need. example. ID 1 Highest Decile was
-Control and second was 7 - Advice.
Not sure how to do that in the first place. Expecially for 15k
Records.
Now another problem. If there is a tie for Decile, Example ID 1
both control and active are both 10. Then to compare the value fo
Control and Active and the primary would be the highest and the secon
Highest would be Secondary.
I haven't a clue if this is posible or evern the best way of doing it
If you can't tell me the how do solve this, then if there is a way t
find Primary and then Secondy on a generic level, that would be good a
well
Attachment filename: sample.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=63590