Norensuneram
New Member
- Joined
- Jan 9, 2019
- Messages
- 1
Please can you help
I am looking for an excel formula to highlight cell with
Invoice number (Column B ) that are partial similar (eg 51070122 & 510701-22 ) and the supplier ID Colum A match if possible to bring the amount in column D
<tbody>
</tbody><strike></strike>
<tbody>
</tbody>
I am looking for an excel formula to highlight cell with
Invoice number (Column B ) that are partial similar (eg 51070122 & 510701-22 ) and the supplier ID Colum A match if possible to bring the amount in column D
A | B | C | ||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody>
</tbody>
Thanks Noren | ||
<tbody>
</tbody>