A B C D E G H I J K
1 | 2 | 3 | 4 | 5 | 1 | 2 | 3 | 4 | 5 | |
0 | 3 | 4 | 0 | 0 | #N/A | #N/A | 3 | 4 | #N/A | |
1 | 0 | 3 | 5 | 0 | 1 | #N/A | 3 | #N/A | 5 | |
0 | 1 | 0 | 3 | 4 | 1 | #N/A | 3 | 4 | #N/A | |
1 | 4 | 0 | 5 | 0 | 1 | #N/A | #N/A | 4 | 5 |
<tbody>
</tbody>
TOTAL: 3 0 3 3 2
G2: =(INDEX($A2:$E2,MATCH(G$1,$A2:$E2,0)))
H2 :=(INDEX($A2:$E2,MATCH(H$1,$A2:$E2,0)))
may I ask how to remove #N/A, instead just leave it blank?
thanks for help
gigi