05-16-2014 12:53 PM
I have the following dataset
|date||NAME OF FORMER||a||b||c|
I would like to sort the rows based on max date in the above table and the name = active. In this case all rows will be sorted based on row 4:
for example the resulting data set looks like below.
This is just a small example of 3 columns but I could have more.
|date||NAME OF FORMER||a||c||b|
Any help is appreciated many Thanks!