A.How to remove duplicate Invoices (I) rows? Like in Column B the type shows whether it is Invoice(I) or Order (O).
For mulitple invoices with the same number I have to keep only 1 and delete the rest.
like for number 1061058, there are 8 invoices, I have to keep only 1.
is there any formula instead of using remove duplicate function?
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
B. I want to check which invoices numbers are matching with the number in Cloned_from column?
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
Any formula?
Plz reply for A & B.
For mulitple invoices with the same number I have to keep only 1 and delete the rest.
like for number 1061058, there are 8 invoices, I have to keep only 1.
is there any formula instead of using remove duplicate function?
NUMBER | TYPE | STORE | CLONED_TO | CLONED_FROM |
1061058 | I | 001 | ||
1061058 | I | 001 | ||
1061058 | I | 001 | ||
1061058 | I | 001 | ||
1061058 | I | 001 | ||
1061058 | I | 001 | ||
1061058 | I | 001 | ||
1061058 | I | 001 | ||
1061453 | I | 001 | ||
1061453 | I | 001 | ||
1062192 | I | 001 | ||
1062192 | I | 001 | ||
1062192 | I | 001 | ||
1062192 | I | 001 | ||
1062192 | I | 001 | ||
1062192 | I | 001 | ||
1062192 | I | 001 | ||
1062192 | I | 001 | ||
1062233 | I | 001 | ||
1062252 | I | 001 | 3000629 | |
1062252 | I | 001 | 3000629 | |
1062252 | I | 001 | 3000629 | |
1062252 | I | 001 | 3000629 | |
1062252 | I | 001 | 3000629 | |
1062252 | I | 001 | 3000629 | |
1062252 | I | 001 | 3000629 | |
1062252 | I | 001 | 3000629 | |
1062252 | I | 001 | 3000629 | |
1062252 | I | 001 | 3000629 | |
1062252 | I | 001 | 3000629 | |
1062252 | I | 001 | 3000629 | |
1062252 | I | 001 | 3000629 | |
1062252 | I | 001 | 3000629 |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
B. I want to check which invoices numbers are matching with the number in Cloned_from column?
NUMBER | TYPE | STORE | CLONED_TO | CLONED_FROM |
1061058 | I | 001 | ||
1063077 | I | 001 | 1063080 | |
1063078 | I | 001 | 1063077 | |
1063079 | I | 001 | 1063077 | |
1063080 | I | 001 | 1063077 |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
Any formula?
Plz reply for A & B.