ctorohuamanchumo
New Member
- Joined
- Apr 13, 2021
- Messages
- 3
- Office Version
- 2016
- Platform
- Windows
Greetings,
I am having several problems with creating a formula.
I am performing a pairwise comparison (eg. Criteria 1 vs Criteria 2, 3, 4... / Criteria 2 vs Criteria 3, 4, 5... / Criteria 3 vs Criteria 4, 5, 6, etc).
Explanation:
- Columns A and F have the weights of each criterion (naturally, there are duplicates values)
- The column "H" has the division of scores C/D
I need to create these two formulas:
1) I need to select the value in column "H" that meet two criteria: Correspond to the row of the Criteria in column "B" with the highest weight in "A" PLUS Correspond to the row of the Criteria in column "E" with the SECOND highest weight in "F".
For example, if Criterion 4 has the highest weight in column A and Criterion 8 has the SECOND highest weight in Column F, I need a formula to automatically get that 1/2 in column "H"
It is important to mention that, I want the 2nd highest value in F in the group that has the first highest value in A, not just the 2nd highest value
2. I need to select the value in column "H" that meet two criteria: Correspond to the row of the Criteria in column "B" with the SECOND highest weight in "A" PLUS Correspond to the row of the Criteria in column "E" with the THIRD highest weight in "F".
It is important to mention that, I want the 3rd highest value in F in the group that has the second highest value in A.
This task is very urgent and I would really appreciate your help!
This is very important for me, because I need to get 10 values:
1st highest (reference Column A) and 2nd highest (reference Column F)
1st highest (reference Column A) and 3rd highest (reference Column F)
1st highest (reference Column A) and 4th highest (reference Column F)
1st highest (reference Column A) and 5th highest (reference Column F)
2nd highest (reference Column A) and 3rd highest (reference Column F)
2nd highest (reference Column A) and 4th highest (reference Column F)
2nd highest (reference Column A) and 5th highest (reference Column F)
3rd highest (reference Column A) and 4th highest (reference Column F)
3rd highest (reference Column A) and 5th highest (reference Column F)
4th highest (reference Column A) and 5th highest (reference Column F)
I am having several problems with creating a formula.
I am performing a pairwise comparison (eg. Criteria 1 vs Criteria 2, 3, 4... / Criteria 2 vs Criteria 3, 4, 5... / Criteria 3 vs Criteria 4, 5, 6, etc).
Explanation:
- Columns A and F have the weights of each criterion (naturally, there are duplicates values)
- The column "H" has the division of scores C/D
I need to create these two formulas:
1) I need to select the value in column "H" that meet two criteria: Correspond to the row of the Criteria in column "B" with the highest weight in "A" PLUS Correspond to the row of the Criteria in column "E" with the SECOND highest weight in "F".
For example, if Criterion 4 has the highest weight in column A and Criterion 8 has the SECOND highest weight in Column F, I need a formula to automatically get that 1/2 in column "H"
It is important to mention that, I want the 2nd highest value in F in the group that has the first highest value in A, not just the 2nd highest value
2. I need to select the value in column "H" that meet two criteria: Correspond to the row of the Criteria in column "B" with the SECOND highest weight in "A" PLUS Correspond to the row of the Criteria in column "E" with the THIRD highest weight in "F".
It is important to mention that, I want the 3rd highest value in F in the group that has the second highest value in A.
This task is very urgent and I would really appreciate your help!
This is very important for me, because I need to get 10 values:
1st highest (reference Column A) and 2nd highest (reference Column F)
1st highest (reference Column A) and 3rd highest (reference Column F)
1st highest (reference Column A) and 4th highest (reference Column F)
1st highest (reference Column A) and 5th highest (reference Column F)
2nd highest (reference Column A) and 3rd highest (reference Column F)
2nd highest (reference Column A) and 4th highest (reference Column F)
2nd highest (reference Column A) and 5th highest (reference Column F)
3rd highest (reference Column A) and 4th highest (reference Column F)
3rd highest (reference Column A) and 5th highest (reference Column F)
4th highest (reference Column A) and 5th highest (reference Column F)