All,

I have a problem which I am struggling to efficiently put into code. I have a datatable

ID | NAME | DATE | JOB
0 | Joe | 01/01 | Selling
1 | Bob | 03/01 | Buying
2 | Joe | 02/01 | Manager
3 | John | 01/01 | Buying

How can i programmatically get it to only show a unique list of names and the if there is a duplicate name to only show the latest entry, ie:

ID | NAME | DATE | JOB
1 | Bob | 03/01 | Buying
2 | Joe | 02/01 | Manager
3 | John | 01/01 | Buying

Anyone have any ideas?

Cheers,

Ken