debapratim1
New Member
- Joined
- Nov 2, 2017
- Messages
- 5
Hi All,
I am facing a problem while sorting a group of Objects according to their values. When multiple values entered are same, then Only the First Object is being returned thrice. While I want all the objects to be returned with same values. Please help.
Demo:
<colgroup><col><col></colgroup><tbody>
</tbody>
Here Object 1 and Object 7 are having the same value but Object 1 is returned twice.
I have used the formula: =INDEX($C$5:$C$99,MATCH($H5,$D$5:$D$15,0))
I am facing a problem while sorting a group of Objects according to their values. When multiple values entered are same, then Only the First Object is being returned thrice. While I want all the objects to be returned with same values. Please help.
Demo:
Objects | Avg Value |
OBJ 1 | 121 |
OBJ 1 | 121 |
OBJ 8 | 125 |
OBJ 11 | 126 |
OBJ 2 | 133 |
OBJ 9 | 135 |
OBJ 10 | 136 |
OBJ 3 | 154 |
OBJ 6 | 172 |
OBJ 4 | 177 |
OBJ 5 | 181 |
<colgroup><col><col></colgroup><tbody>
</tbody>
Here Object 1 and Object 7 are having the same value but Object 1 is returned twice.
I have used the formula: =INDEX($C$5:$C$99,MATCH($H5,$D$5:$D$15,0))