Spreadsheet: 218849d1362593609-help-on-sorting-formula-example
Sheet: Sheet1

data | data | Patient name | data | data | data | data | Date | past date | current date | data | data | data | data | data
data | data | potter,[NAME] | data | data | data | data | 2011-03-06 00:00:00 | xx |  | data | data | data | data | data
data | data | potter,[NAME] | data | data | data | data | 2011-03-05 00:00:00 | xx |  | data | data | data | data | data
data | data | potter,[NAME] | data | data | data | data | 2011-03-08 00:00:00 | xx |  | data | data | data | data | data
data | data | potter,[NAME] | data | data | data | data | 2011-04-03 00:00:00 | xx |  | data | data | data | data | data
data | data | potter,[NAME] | data | data | data | data | 2011-04-05 00:00:00 | xx |  | data | data | data | data | data
data | data | potter,[NAME] | data | data | data | data | 2012-01-03 00:00:00 |  | x | data | data | data | data | data
data | data | parker,[NAME] | data | data | data | data | 2011-05-05 00:00:00 | xx |  | data | data | data | data | data
data | data | parker,[NAME] | data | data | data | data | 2012-05-05 00:00:00 |  | x | data | data | data | data | data
data | data | doe,jane | data | data | data | data | 2011-02-01 00:00:00 | xx |  | data | data | data | data | data
data | data | doe,jane | data | data | data | data | 2011-02-09 00:00:00 | xx |  | data | data | data | data | data
data | data | doe,jane | data | data | data | data | 2011-02-06 00:00:00 | xx |  | data | data | data | data | data
data | data | doe,jane | data | data | data | data | 2011-02-07 00:00:00 | xx |  | data | data | data | data | data
data | data | doe,jane | data | data | data | data | 2011-10-11 00:00:00 | xx |  | data | data | data | data | data
data | data | doe,[NAME] | data | data | data | data | 2012-02-02 00:00:00 |  | x | data | data | data | data | data
data | data | doe,[NAME] | data | data | data | data | 2012-04-02 00:00:00 |  | x | data | data | data | data | data
data | data | doe,[NAME] | data | data | data | data | 2013-02-09 00:00:00 |  | x | data | data | data | data | data
data | data | doe,[NAME] | data | data | data | data | 2013-03-01 00:00:00 |  | x | data | data | data | data | data
data | data | doe,[NAME] | data | data | data | data | 2013-02-05 00:00:00 |  | x | data | data | data | data | data
data | data | doe,[NAME] | data | data | data | data | 2011-01-01 00:00:00 | xx |  | data | data | data | data | data
data | data | doe,[NAME] | data | data | data | data | 2011-06-01 00:00:00 | xx |  | data | data | data | data | data
data | data | doe,[NAME] | data | data | data | data | 2011-06-08 00:00:00 | xx |  | data | data | data | data | data
data | data | doe,[NAME] | data | data | data | data | 2011-06-09 00:00:00 | xx |  | data | data | data | data | data
data | data | luther,lex | data | data | data | data | 2011-07-08 00:00:00 | xx |  | data | data | data | data | data
data | data | luther,lex | data | data | data | data | 2011-06-05 00:00:00 | xx |  | data | data | data | data | data
data | data | luther,lex | data | data | data | data | 2010-09-02 00:00:00 | xx |  | data | data | data | data | data
data | data | luther,lex | data | data | data | data | 2009-09-09 00:00:00 | xx |  | data | data | data | data | data