Spreadsheet: 688735d1595931064-counting-for-a-recent-ranking-value-excel-help-example
Sheet: EXAMPLE PROBLEM

REF | STATUS | DATE | RANK | Preferred rank
1001722 | Initial | 2014-11-01 00:00:00
1002878 | Periodic | 2010-04-01 00:00:00
1002878 | Periodic | 2010-10-01 00:00:00
1002878 | Periodic | 2011-05-01 00:00:00
1002878 | Full follow-up | 2012-01-01 00:00:00
1002878 | Periodic | 2012-07-01 00:00:00
1002878 | Periodic | 2013-11-01 00:00:00
1002878 | Initial | 2019-08-01 00:00:00
1006870 | Initial | 2013-12-01 00:00:00
1006870 | Initial | 2015-01-01 00:00:00
1006870 | Periodic | 2015-09-01 00:00:00
1006870 | Partial Follow-up | 2016-05-01 00:00:00
1006870 | Partial Follow-up | 2016-11-01 00:00:00
1006870 | Periodic | 2017-09-01 00:00:00
1006870 | Periodic | 2019-09-01 00:00:00
1006870 | Partial Follow-up | 2020-01-01 00:00:00
1009645 | Initial | 2014-06-01 00:00:00
1009645 | Periodic | 2016-08-01 00:00:00
1009645 | Partial Follow-up | 2017-03-01 00:00:00
1009645 | Partial Follow-up | 2017-07-01 00:00:00
1009645 | Periodic | 2018-07-01 00:00:00
1009868 | Initial | 2013-12-06 00:00:00
1009868 | Periodic | 2016-07-18 00:00:00
1009868 | Partial Follow-up | 2017-01-10 00:00:00
1009868 | Periodic | 2018-06-26 00:00:00
1012476 | Initial | 2013-12-01 00:00:00 |  | 7
1012476 | Initial | 2014-04-08 00:00:00 |  | 6
1012476 | Periodic | 2014-09-01 00:00:00 |  | 5
1012476 | Periodic | 2015-11-27 00:00:00 |  | 4
1012476 | Periodic | 2017-06-21 00:00:00 |  | 3
1012476 | Periodic | 2018-06-27 00:00:00 |  | 2
1012476 | Periodic | 2019-07-04 00:00:00 |  | 1
1015358 | Initial | 2013-11-01 00:00:00
1015358 | Periodic | 2015-02-01 00:00:00
1015358 | Full follow-up | 2015-11-01 00:00:00
1015358 | Partial Follow-up | 2016-03-01 00:00:00
1015358 | Periodic | 2017-11-01 00:00:00
1015358 | Periodic | 2019-11-01 00:00:00
1015358 | Partial Follow-up
1017018 | Initial | 2010-06-14 00:00:00
1017018 | Periodic | 2012-02-20 00:00:00
1017018 | Periodic | 2013-04-23 00:00:00
1017018 | Periodic | 2015-05-08 00:00:00
1017018 | Periodic | 2017-04-27 00:00:00
1017018 | Periodic | 2018-05-01 00:00:00
1017018 | Periodic | 2018-11-01 00:00:00
1017018 | Periodic | 2019-11-01 00:00:00
1017105 | Initial | 2014-03-01 00:00:00
1017105 | Periodic | 2015-09-01 00:00:00
1017105 | Periodic | 2017-09-01 00:00:00
1017700 | Initial | 2014-11-01 00:00:00
1018533 | Initial | 2014-04-01 00:00:00
1023970 | Initial | 2014-08-01 00:00:00
1024031 | Initial | 2014-08-01 00:00:00
1024031 | Full follow-up | 2015-04-01 00:00:00
1024031 | Periodic | 2016-10-01 00:00:00
1024031 | Periodic | 2018-10-01 00:00:00
1027839 | Initial | 2012-01-30 00:00:00
1027839 | Initial | 2013-03-07 00:00:00
1027839 | Periodic | 2014-03-13 00:00:00
1027839 | Periodic | 2016-04-26 00:00:00
1027839 | Partial Follow-up | 2016-10-05 00:00:00
1027839 | Periodic | 2018-04-01 00:00:00
1027839 | Full follow-up | 2018-10-10 00:00:00
1027839 | Partial Follow-up | 2019-07-12 00:00:00
1028860 | Initial | 2014-02-01 00:00:00
1028860 | Periodic | 2015-09-01 00:00:00
1031724
1032051 | Initial | 2014-10-01 00:00:00
1032051 | Periodic | 2017-04-01 00:00:00
1032051 | Periodic | 2019-03-01 00:00:00
1032476 | Initial | 2014-04-01 00:00:00
1032476 | Periodic | 2015-03-01 00:00:00
1038656 | Initial | 2009-05-01 00:00:00
1038656 | Periodic | 2010-06-01 00:00:00
1038656 | Periodic | 2013-03-01 00:00:00
1038656 | Full follow-up | 2013-08-01 00:00:00
1038656 | Periodic | 2014-01-01 00:00:00
1038656 | Initial | 2014-04-01 00:00:00
1038656 | Full follow-up | 2014-09-01 00:00:00
1038656 | Full follow-up | 2014-11-01 00:00:00
1038656 | Initial | 2014-12-01 00:00:00
1038656 | Periodic | 2015-04-01 00:00:00
1038656 | Full follow-up | 2015-07-01 00:00:00
1038656 | Full follow-up | 2015-10-01 00:00:00
1038656 | Full follow-up | 2015-11-01 00:00:00
1038656 | Periodic | 2016-04-01 00:00:00
1038656 | Partial Follow-up | 2016-10-01 00:00:00
1038656 | Periodic | 2017-04-01 00:00:00
1038656 | Full follow-up | 2017-09-01 00:00:00
1038656 | Periodic | 2018-02-01 00:00:00
1039074 | Periodic | 2014-03-01 00:00:00
1039074 | Initial | 2012-03-01 00:00:00
1039074 | Full follow-up | 2012-12-01 00:00:00
1039074 | Periodic | 2013-10-01 00:00:00
1039074 | Periodic | 2014-01-01 00:00:00
1039074 | Periodic | 2015-02-01 00:00:00
1039074 | Periodic | 2015-11-01 00:00:00
1039074 | Full follow-up | 2016-05-01 00:00:00
1039074 | Periodic | 2016-12-01 00:00:00
1039074 | Partial Follow-up | 2017-05-01 00:00:00
1039074 | Periodic | 2017-11-01 00:00:00
1039074 | Periodic | 2018-11-01 00:00:00
1039728 | Initial | 2013-05-01 00:00:00
1039728 | Full follow-up | 2013-07-01 00:00:00
1039728 | Periodic | 2013-09-01 00:00:00
1039728 | Initial | 2013-10-01 00:00:00
1039728 | Periodic | 2014-02-01 00:00:00
1039728 | Periodic | 2015-05-01 00:00:00
1039728 | Full follow-up | 2015-12-01 00:00:00
1039728 | Periodic | 2016-05-01 00:00:00
1039728 | Periodic | 2016-07-01 00:00:00
1039728 | Partial Follow-up | 2016-09-01 00:00:00
1039728 | Periodic | 2017-03-01 00:00:00
1039728 | Full follow-up | 2017-09-01 00:00:00
1039728 | Periodic | 2018-02-01 00:00:00
1043873 | Periodic | 2017-09-01 00:00:00
1043873 | Periodic | 2018-07-12 00:00:00
1043873 | Initial | 2009-02-01 00:00:00
1044001 | Initial | 2013-12-11 00:00:00
1044001 | Initial | 2014-05-30 00:00:00
1044001 | Periodic | 2016-07-15 00:00:00
1044001 | Partial Follow-up | 2016-12-22 00:00:00
1044001 | Periodic | 2018-07-02 00:00:00
1044001 | Partial Follow-up | 2018-12-01 00:00:00
1044058 | Full follow-up | 2016-06-15 00:00:00
1044058 | Periodic | 2018-02-01 00:00:00
1044058 | Initial | 2017-04-03 00:00:00
1044467 | Full follow-up | 2020-06-01 00:00:00
1044467 | Initial | 2010-09-23 00:00:00
1044467 | Periodic | 2011-12-23 00:00:00
1044467 | Full follow-up | 2012-03-06 00:00:00
1044467 | Periodic | 2013-01-14 00:00:00
1044467 | Periodic | 2013-09-01 00:00:00
1044467 | Periodic | 2013-11-22 00:00:00
1044467 | Periodic | 2014-02-21 00:00:00
1044467 | Full follow-up | 2014-08-21 00:00:00
1044467 | Full follow-up | 2014-10-21 00:00:00
1044467 | Periodic | 2015-01-30 00:00:00
1044467 | Periodic | 2015-09-24 00:00:00
1044467 | Periodic | 2015-12-16 00:00:00
1044467 | Periodic | 2016-01-15 00:00:00
1044467 | Periodic | 2016-04-05 00:00:00
1044467 | Periodic | 2016-03-31 00:00:00
1044467 | Periodic | 2017-01-13 00:00:00
1044467 | Periodic | 2018-01-05 00:00:00
1044467 | Periodic | 2018-12-01 00:00:00
1044467 | Full follow-up | 2019-04-01 00:00:00
1046332 | Periodic | 2018-02-01 00:00:00
1046332 | Periodic | 2020-02-01 00:00:00
1046332 | Initial | 2014-05-06 00:00:00
1049058 | Initial | 2014-10-16 00:00:00
1049058 | Full follow-up | 2016-12-12 00:00:00
1049058 | Periodic | 2017-11-01 00:00:00
1049058 | Periodic | 2018-12-01 00:00:00
1049967 | Initial | 2009-03-01 00:00:00
1049967 | Periodic | 2010-10-01 00:00:00
1049967 | Periodic | 2012-10-01 00:00:00
1049967 | Periodic | 2014-11-01 00:00:00
1049967 | Full follow-up | 2015-03-01 00:00:00
1049967 | Periodic | 2015-12-01 00:00:00
1049967 | Periodic | 2016-11-01 00:00:00
1049967 | Partial Follow-up | 2017-04-01 00:00:00
1049967 | Periodic | 2017-11-01 00:00:00
1049967 | Periodic | 2018-04-01 00:00:00
1049967 | Periodic | 2018-11-01 00:00:00
1049967 | Periodic | 2019-10-01 00:00:00
1051398 | Initial | 2014-05-15 00:00:00
1051398 | Periodic | 2016-05-04 00:00:00
1051398 | Periodic | 2017-05-11 00:00:00
1051398 | Periodic | 2018-04-01 00:00:00
1051398 | Periodic | 2019-03-01 00:00:00
1053996 | Initial | 2013-09-24 00:00:00
1053996 | Full follow-up | 2014-01-15 00:00:00
1053996 | Periodic | 2015-10-05 00:00:00
1053996 | Full follow-up | 2016-05-23 00:00:00
1053996 | Periodic | 2016-10-25 00:00:00
1053996 | Periodic | 2018-01-01 00:00:00
1053996 | Periodic | 2018-12-01 00:00:00
1053996 | Periodic | 2019-12-01 00:00:00
1055198 | Initial | 2009-07-01 00:00:00
1055198 | Periodic | 2011-09-01 00:00:00
1055198 | Periodic | 2012-12-01 00:00:00
1055198 | Initial | 2013-12-01 00:00:00
1055198 | Initial | 2014-01-01 00:00:00
1055198 | Periodic | 2014-03-01 00:00:00
1055198 | Periodic | 2016-03-01 00:00:00
1055198 | Periodic | 2018-02-01 00:00:00
1055198 | Periodic | 2020-01-01 00:00:00
1055445 | Periodic | 2019-11-01 00:00:00
1055445 | Initial | 2009-04-10 00:00:00
1055446 | Periodic | 2012-01-19 00:00:00
1055447 | Full follow-up | 2012-08-04 00:00:00
1055448 | Periodic | 2013-05-20 00:00:00
1055449 | Periodic | 2013-09-30 00:00:00
1055450 | Full follow-up | 2014-04-11 00:00:00
1055451 | Periodic | 2014-06-04 00:00:00
1055452 | Full follow-up | 2014-11-17 00:00:00
1055453 | Full follow-up | 2015-01-30 00:00:00
1055454 | Periodic | 2015-09-03 00:00:00
1055455 | Partial Follow-up | 2016-03-21 00:00:00
1057111 | Initial | 2016-03-21 00:00:00
1057111 | Full follow-up | 2016-11-14 00:00:00
1057111 | Periodic | 2017-11-21 00:00:00
1057111 | Periodic | 2018-11-01 00:00:00
1057111 | Periodic | 2019-11-01 00:00:00
1058083 | Periodic | 2018-06-01 00:00:00
1058083 | Initial | 2015-02-03 00:00:00
1058309 | Periodic | 2016-11-17 00:00:00
1058309 | Periodic | 2018-11-01 00:00:00
1058309 | Initial | 2016-03-17 00:00:00
1059964 | Periodic | 2015-03-02 00:00:00
1059964 | Periodic | 2016-05-30 00:00:00
1059964 | Periodic | 2017-11-01 00:00:00
1059964 | Periodic | 2019-10-01 00:00:00
1060098 | Initial | 2016-11-01 00:00:00
1062405 | Initial | 2014-01-22 00:00:00
1062405 | Full follow-up | 2014-09-22 00:00:00
1062405 | Periodic | 2015-10-19 00:00:00
1062405 | Periodic | 2017-01-11 00:00:00
1062405 | Periodic | 2018-01-06 00:00:00
1062405 | Periodic | 2018-12-01 00:00:00
1062405 | Full follow-up | 2019-04-22 00:00:00
1062405 | Periodic | 2019-12-17 00:00:00
1063080 | Periodic | 2018-08-23 00:00:00
1063080 | Initial | 2012-07-01 00:00:00
1063080 | Initial | 2019-08-01 00:00:00
1063220 | Initial | 2014-07-01 00:00:00
1063220 | Periodic | 2016-08-01 00:00:00
1063220 | Periodic | 2017-07-01 00:00:00
1063220 | Periodic | 2019-01-01 00:00:00
1065108 | Initial | 2013-11-01 00:00:00
1065108 | Full follow-up | 2014-08-01 00:00:00
1065108 | Periodic | 2015-09-01 00:00:00
1065108 | Partial Follow-up | 2016-04-01 00:00:00
1065108 | Periodic | 2016-10-01 00:00:00
1065108 | Periodic | 2017-09-01 00:00:00
1065108 | Periodic | 2018-08-01 00:00:00
1065108 | Periodic | 2019-08-01 00:00:00
1066793 | Initial | 2012-12-01 00:00:00
1066793 | Periodic | 2014-05-01 00:00:00
1066793 | Periodic | 2016-09-01 00:00:00
1066793 | Partial Follow-up | 2016-12-01 00:00:00
1066793 | Periodic | 2017-09-01 00:00:00
1066793 | Periodic | 2018-09-01 00:00:00
1068873 | Initial | 2014-01-01 00:00:00
1068873 | Periodic | 2015-07-01 00:00:00
1068873 | Periodic | 2016-09-01 00:00:00
1068873 | Partial Follow-up | 2017-04-01 00:00:00
1071768 | Periodic | 2018-09-01 00:00:00
1071768 | Initial | 2010-05-14 00:00:00
1071768 | Periodic | 2012-05-15 00:00:00
1071768 | Full follow-up | 2014-03-10 00:00:00
1071768 | Partial Follow-up | 2014-09-11 00:00:00
1071768 | Full follow-up | 2015-06-03 00:00:00
1071768 | Periodic | 2017-05-04 00:00:00
1071768 | Partial Follow-up | 2017-09-04 00:00:00
1074336
1074336 | Initial | 2011-12-08 00:00:00
1074336 | Periodic | 2012-11-28 00:00:00
1074336 | Periodic | 2014-04-10 00:00:00
1074336 | Full follow-up | 2014-10-21 00:00:00
1074336 | Full follow-up | 2015-03-10 00:00:00
1074336 | Full follow-up | 2015-09-17 00:00:00
1074336 | Periodic | 2017-03-28 00:00:00
1074336 | Partial Follow-up | 2017-09-21 00:00:00
1074336 | Periodic | 2019-03-01 00:00:00
1074486 | Initial | 2014-03-01 00:00:00
1074486 | Full follow-up | 2015-02-01 00:00:00
1074486 | Periodic | 2017-01-01 00:00:00
1074486 | Partial Follow-up | 2017-08-01 00:00:00
1074486 | Periodic | 2019-02-01 00:00:00
1076454 | Initial | 2014-05-05 00:00:00
1076454 | Periodic | 2016-11-15 00:00:00
1076454 | Periodic | 2018-12-01 00:00:00
1079372 | Initial | 2014-05-01 00:00:00
1079372 | Full follow-up | 2015-02-17 00:00:00
1079372 | Periodic | 2016-10-26 00:00:00
1079372 | Periodic | 2018-09-01 00:00:00
1082160 | Initial | 2014-06-26 00:00:00
1082160 | Full follow-up | 2015-06-02 00:00:00
1082160 | Periodic | 2016-09-15 00:00:00
1082160 | Periodic | 2018-10-01 00:00:00
1087634 | Initial | 2014-04-10 00:00:00
1087634 | Periodic | 2016-06-15 00:00:00
1087634 | Periodic | 2017-11-28 00:00:00
1088974 | Initial | 2009-03-01 00:00:00
1088974 | Periodic | 2010-04-01 00:00:00
1088974 | Full follow-up | 2010-10-01 00:00:00
1088974 | Periodic | 2011-04-01 00:00:00
1088974 | Periodic | 2012-06-01 00:00:00
1088974 | Periodic | 2013-09-01 00:00:00
1088974 | Full follow-up | 2014-02-01 00:00:00
1088974 | Periodic | 2014-06-01 00:00:00
1088974 | Periodic | 2014-09-01 00:00:00
1088974 | Full follow-up | 2015-04-01 00:00:00
1088974 | Periodic | 2015-12-01 00:00:00
1088974 | Full follow-up | 2016-06-01 00:00:00
1088974 | Periodic | 2016-08-01 00:00:00
1088974 | Periodic | 2017-01-01 00:00:00
1088974 | Periodic | 2017-11-01 00:00:00
1088974 | Periodic | 2019-04-01 00:00:00
1088974 | Periodic | 2020-03-01 00:00:00
1089005 | Periodic | 2016-11-23 00:00:00
1089005 | Initial | 2012-06-25 00:00:00
1089005 | Initial | 2014-01-08 00:00:00
1089005 | Full follow-up | 2014-07-25 00:00:00
1089005 | Full follow-up | 2015-04-13 00:00:00
1089005 | Periodic | 2016-08-11 00:00:00
1089005 | Full follow-up | 2017-01-23 00:00:00
4056968 | Initial | 2019-05-01 00:00:00
4056968 | Periodic
4065715 | Initial | 2017-03-13 00:00:00
4066247 | Periodic | 2019-11-01 00:00:00
4066247 | Initial | 2018-10-01 00:00:00
4066247 | Periodic | 2019-07-01 00:00:00
4068389 | Periodic | 2019-12-01 00:00:00
4068389 | Initial | 2019-08-01 00:00:00
4068389 | Periodic | 2019-12-01 00:00:00
4072781 | Initial | 2020-02-13 00:00:00
LK Supp
pplier | Periodic | 2015-09-01 00:00:00
Site R | Initial | 2011-12-01 00:00:00
Site R | Full follow-up | 2012-11-01 00:00:00
Site R | Periodic | 2013-06-01 00:00:00