bulk rename data with id Numbers ?
First of all I'm beginner in Excel. i hope a get a right suggestion from her , needs as follows
| ID No | Value |
| 1 | 12485 |
| 2 | 36481 |
| 3 | 14235 |
| 4 | 74515 |
| 5 | 94267 |
| 6 | 74586 |
| 7 | 14257 |
| 8 | 13546 |
| 9 | 14287 |
| 10 | 97458 |
Its my data table ; i have another document that having 19285 dats in a raw, but the datas in the cells are duplicates of Values . ie: ID No. 1 Value 12485 repeated 57 times in different locations. i want to replace the Value with ID No.
I need ;
find all Value and replace with ID No.
When both the value and the Id are chosen, the value should automatically recognize and replace with the Id.
