Boa tarde,
tenho duas colunas A e B e varios numeros em ambas as colunas, queria identificar os numeros que existem em ambas as colunas.
Exemplo
| A | B |
|---|---|
| 15829443 | 9772165 |
| 15829443 | 11474911 |
| 15829443 | 14056214 |
| 15811476 | 10249692 |
| 15811476 | 9771054 |
| 15811476 | 6961449 |
| 15778377 | 11467686 |
| 15778377 | 5034862 |
| 15778377 | 9778031 |
| 15735039 | 9778030 |
| 15735039 | 11467685 |
| 15735039 | 9778027 |
| 15735004 | 9778029 |
| 15735004 | 9474292 |
| 15735004 | 9474292 |
| 15727813 | 9728695 |
| 15727813 | 9728695 |
| 15727813 | 9728692 |
| 15724403 | 9728692 |
| 15724403 | 9728692 |
| 15724403 | 9799433 |
| 15724397 | 5060045 |
| 15724397 | 5060045 |
| 15724397 | 5060046 |
| 15723268 | 5060046 |
| 15723268 | 5060046 |
| 15723268 | 14041811 |
| 15718253 | 9770824 |
| 15718253 | 14832588 |
| 15711045 | 9768424 |
| 15711045 | 9867998 |
| 15711045 | 9762782 |