Spreadsheet: 877812d1724749832-excel-ranking-formula-error-in-google-sheet-sample-top-10-data-sheet
Sheet: Sheet1

YTD TOP 10 ACCOUNTS BY AGENT
DATE GENERATED |  | AUGUST 12, 2024
MONTH |  | JULY
AGENT CODE |  | AE5
SALES DIVISION |  | LUZON
 | KUNNR | [NAME] | 2024 SALES | TARGET | ATTNMENT | 2023 SALES | GROWTH |  | RANK | KUNNR | [NAME] | YTD SALES ATTAINMENT
 |  |  | 11424944.71 | 8830802.71 | 1.293760611032834 | 8200406.860000005 | 0.3932168129033535 |  |  |  |  | 2024 SALES | TARGET | ATTNMENT | SOB
 | [PHONE] | ROBINSON DEPARTMENT STORE | 1298958.770000004 | 1280465.870000001 | 1.014442321684063 | 1248811.130000006 | 0.0401563045005835 |  | 1
 | [PHONE] | WALTERMART SUPERMARKET, INC. | 970696.4999999987 | 965060.2500000001 | 1.005840308934078 | 938559.189999999 | 0.03424111163409926 |  | 2 | [PHONE]
 | [PHONE] | METRO RETAIL STORES GROUP, INC. | 1105922.159999999 | 1551188.32 | 0.7129515776653079 | 1404162.899999999 | -0.2123975359269216 |  | 3 | [PHONE]
 | [PHONE] | SOUTHEASTASIA RETAIL INC | 2081584.090000001 | 1024629.51 | 2.031548056819095 | 713098.5199999999 | 1.919069429564937 |  | 4 | [PHONE]
 | [PHONE] | HOMEWORKS THE HOMECENTER INC. | 888824.6100000024 | 593106.15 | 1.498592806700795 | 574661.5799999995 | 0.546692246243438 |  | 5 | [PHONE]
 | [PHONE] | CITYSUPER INCORPORATED | 621414.1199999996 | 626620.6799999999 | 0.9916910498389547 | 599694.5399999999 | 0.0362177384506448 |  | 6 | [PHONE]
 | [PHONE] | HOMEWORKS THE HOMECENTER INC. | 153892.3399999999 | 228891.7499999999 | 0.6723367705476497 | 228891.7499999999 | -0.3276632294523502 |  | 7 | [PHONE]
 | [PHONE] | KAREILA MANAGEMENT CORPORATION | 0 | 313800 | 0 | 313800 | -1 |  | 8 | [PHONE]
 | [PHONE] | ROBINSONS SUPERMARKET CORPORATION | 914128.0500000014 | 1242759.120000001 | 0.7355633407059613 | 1202152.970000003 | -0.2395909066381132 |  | 9 | [PHONE]
 | [PHONE] | KAREILA MANAGEMENT CORPORATION | 0 | 9176.77 | 0 | 3915.21 | -1 |  | 10 | [PHONE]
 | [PHONE] | RIVIERA MERCANTILE SYSTEMS INC. | 327325.94 | 335460.4599999999 | 0.9757511809290433 | 327372.28 | -0.0001415513860856255 |  |  | OTHERS | BALANCE ACCOUNTS/ DEALERS
 | [PHONE] | THE LANDMARK CORPORATION | 869445.3299999989 | 553879.7100000001 | 1.569736739408632 | 540026.3300000002 | 0.6100054417716978 |  | TOTAL YTD ATTAINMENT
 | [PHONE] | FORTE SHOWROOM CORPORATION | 0 | 29061.62 | 0 | 28557.96 | -1
 | [PHONE] | CITYSUPER NUVALI INC. | 183052.8000000001 | 76702.50000000001 | 2.386529774127311 | 76702.5 | 1.386529774127311
 | [PHONE] | HARD DISCOUNT PHILIPPINES, INC | 2009700 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0
 |  |  | 0 | 0 |  | 0