Hi, i am new to this forum and request some help on excel.
i intend to use 3 conditions on the below table. the formula i used is =if(isnumber(match(b2,A2:A5,0)*AND(c2="",b2,0) however i am unable to extract the required result.
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>
to explain my request. the isnumber match cross verifies the credit column with the debit column to identify contra entries
Since the credit column does not have a contra entry and the unit number is available, the value of 1000 needs to be populated in "identified"
the second row has a value under credit column but does not have a value entered under unit which should be populated in "unidentified"
the 3rd column has a contra entry for the same value and also has a unit number entered, however since this is a contra entry the value should be populated under "contra"
<tbody>
</tbody>
i intend to use 3 conditions on the below table. the formula i used is =if(isnumber(match(b2,A2:A5,0)*AND(c2="",b2,0) however i am unable to extract the required result.
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>
to explain my request. the isnumber match cross verifies the credit column with the debit column to identify contra entries
Since the credit column does not have a contra entry and the unit number is available, the value of 1000 needs to be populated in "identified"
the second row has a value under credit column but does not have a value entered under unit which should be populated in "unidentified"
the 3rd column has a contra entry for the same value and also has a unit number entered, however since this is a contra entry the value should be populated under "contra"
debit | Credit | unit No | identified | unidentified | contra |
0 | 1000 | 1 | |||
0 | 2000 | ||||
0 | 4000 | 5 | |||
4000 | 0 |
<tbody>
</tbody>