I have a table with data on account number and holder name fields. I need to extract two types of information:
List of most recent option by account from holders of the account
111 AAA 2 15/10/2013
111 BBB 1 15/10/2013
On an account level, the different options selected independently from the holder.
111 2 1
Please find file attached.
Your help would be greatly appreciated.