My updated data set is as below

```
tmp_number_1    tmp_name_1         ID
7990918840  Yvette             33098
7958376552  Mum                33098
7951755055  Dad                33098
7951755055  Dad mob            33098
7581498864  Wynne Lewis        33098
7581498864  Wynne Lewis mob    33098
87128486    James Braithewaite 33098
1869353690  Fleetclaims        33098
447915381850    Kath               33098
919446540717    Sujata Egbert      33098
87124812    Chris  Riley       33098
7958376552  Mum Mob            33098
7958376552  Mum Mob new        33098

```

I want the last row of the records where "tmp\_number\_1" is repeated.

Answer I am looking is 

```
tmp_number_1    tmp_name_1           ID
7990918840  Yvette               33098
**7951755055    Dad mob**            33098
**7581498864    Wynne Lewis mob**    33098
87128486    James Braithewaite   33098
1869353690  Fleetclaims          33098
447915381850    Kath                 33098
919446540717    Sujata Egbert        33098
87124812    Chris  Riley         33098
**7958376552    Mum Mob new**        33098

```

\*\* is the last occurance of "tmp\_number\_1"