asyamonique
Well-known Member
- Joined
- Jan 29, 2008
- Messages
- 1,280
- Office Version
- 2013
- Platform
- Windows
Hello is there any way to fix below formula?
I placed the formulas by the columns J & K all the way down.
If column C datas are the same numbers my formula doesn't find two differnt names...
Many thanks.
<colgroup><col><col></colgroup><tbody>
</tbody>
<colgroup><col><col></colgroup><tbody>
</tbody>
J3=
K3=
I placed the formulas by the columns J & K all the way down.
If column C datas are the same numbers my formula doesn't find two differnt names...
Many thanks.
COLUMN B | COLUMN C |
Name 1 | 12,000 |
Name 2 | 12,000 |
<colgroup><col><col></colgroup><tbody>
</tbody>
COLUMN J | COLUMN K |
Name 1 | 12,000 |
Name 1 | 12,000 |
<colgroup><col><col></colgroup><tbody>
</tbody>
J3=
Code:
=IFERROR(INDEX($B$3:$B$8,MATCH(K3,$C$3:$C$8,0)),"")
Code:
=IFERROR(LARGE($C$3:$C$8,ROWS($1:1)),"")