Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 5 columns
ID Name Amount RSF
1 abc 2345 543
1 bcd 5432 345
1 cde 3456 231
2 efg 7654 321
2 EFT 7654 567
3 fgh 3421 560
Here I want the o/p as below
ID Name Amount RSF
1 bcd 5432 345
2 efg 7654 567
3 fgh 3421 560
For ID '1' I want single row of data based on highest Amount AND also If amount is same I want it based on the highest RSF(Ex: ID '2')
Thanks much.
Also,I have this in Straight table.
This is what I am getting
Since this data is not contained in your Excel sample data set, what's wrong with it?