Spreadsheet: 861361d1709233630-excel-filter-formula-with-2-dimensional-criteria-filter_function_2_dimensional_criteria_resolved
Sheet: 1

Type | Company | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | llt
L | 1 | 821678.0520431882 | 1132238.556502287 | 1052151.386255281 | 485224.7765941675 | 573662.170452579 | 783154.575699018 | 393954.198891788 | 397507.2655014976 | 437411.7537328842 | 571286.1018066263 | 767507.6807032366 | 646310.0089523382
C | 2 | 17073444.8563682 | 17863826.25574294 | 19195523.24660087 | 14906476.70926068 | 13768862.30260473 | 17682207.0443485 | 14376916.94629993 | 13223388.96248177 | 14233142.3238621 | 15978490.30850226 | 14735441.00857592 | 14629771.03042831
L | 3 | 275783.7944214683 | 258562.2681995258 | 385424.7719799217 | 287923.6874245449 | 327466.4389666381 | 473489.9475858482 | 435701.6295566931 | 474577.5966929105 | 670696.4410114636 | 395625.0684844433 | 459937.8653297168 | 442767.6576183604
C | 4 | 2405708.356134195 | 2492822.005698129 | 2592686.115258974 | 2185990.996393738 | 2496527.285140461 | 2992136.338673147 | 2669436.41094389 | 2215691.401783753 | 2450856.801540506 | 2483884.793617832 | 2051879.642383893 | 2103481.71189446
B | 5 | 934623.5300206038 | 1039644.472857122 | 1340996.500895506 | 969915.2625256461 | 1098898.584542919 | 1728880.760371893 | 1224225.127671078 | 1416692.409301248 | 1176739.600345406 | 1868072.320752207 | 2206703.399992558 | 1941859.020346115
B | 6 | 21502381.07965106 | 21761382.28436317 | 24408490.23966539 | 20196688.4983805 | 22963406.96641705 | 20663863.57018586 | 18286268.96190313 | 20648940.07111223 | 23734196.85751033 | 22889268.36258742 | 19064898.87999292 | 13888204.40313024
B | 7 | 578922.3781827124 | 579710.505424651 | 716186.2278917772 | 561176.5694699623 | 632695.3088596584 | 650523.9667095802 | 578247.3497026088 | 640152.3399907653 | 583115.134489635 | 676680.5383161965 | 648872.161843951 | 522665.4670614814
B | 8 | 6818117.496008469 | 6814827.57746325 | 7884020.409974709 | 6148483.750158566 | 7345081.349820712 | 7615768.527184397 | 5776007.346111108 | 5968474.389632117 | 7511725.259525307 | 7222051.479324852 | 6643430.850170039 | 4113706.828285415
L | 9 | 274215.1365106085 | 407999.003742042 | 293239.1791277635 | 269972.3238073673 | 759492.363045477 | 954956.1888359279 | 1297935.390321751 | 165372.1018053225 | 547285.8476770893 | 434132.6023951576 | 665868.9303663283 | 132266.3212370168
L | 10 | 477268.3949065512 | 390629.0160532101 | 374764.1870986454 | 332251.5285856572 | 428511.1343552344 | 362503.9121010313 | 295320.3832206068 | 458777.0311330261 | 338303.5066124865 | 401292.8434823829 | 282773.3860702942 | 299375.1493360498
B | 11 | 12078726.47466025 | 13531386.48419195 | 16442623.09752651 | 13083980.34878664 | 14741858.44767728 | 14985151.52078022 | 10923426.01860928 | 12764353.9566998 | 14903006.48582423 | 16853140.35836226 | 13213897.0835214 | 9462402.205989758
L | 12 | 543269.5614761093 | 545543.4873890548 | 621649.9464214317 | 442506.431001642 | 446260.3515611093 | 590240.1358658731 | 309146.3735264312 | 326876.2841219318 | 731076.1252866935 | 409753.6327983811 | 534502.6793889432 | 307123.4542900581
L | 13 | 383820.2986186861 | 525861.2100342376 | 477039.2867080081 | 421683.6417355241 | 477592.0496035771 | 482293.6801100732 | 475985.1794615248 | 426502.371509082 | 438067.0739223752 | 387798.8439134273 | 491427.7283971523 | 464240.590059439
C | 14 | 2648554.248355193 | 2900502.557959892 | 3077648.994997654 | 2380091.481761693 | 1835775.174623143 | 1950642.807829133 | 2040358.163935297 | 1864530.281292388 | 1940493.656246292 | 2719866.316703679 | 2069212.268613544 | 2338962.598637608
L | 15 | 297073.859781665 | 309073.0962603383 | 383859.82592196 | 299516.3332474549 | 409731.6284511682 | 359008.1848742455 | 315582.9488918252 | 305836.0133257695 | 344542.5574759291 | 352758.2618313679 | 285075.419288283 | 247009.514438302
B | 16 | 9489600.161172614 | 8779604.710762808 | 6349349.96786308 | 5202273.51186341 | 5551175.299826701 | 4839610.459619825 | 4031660.720416973 | 4842168.580820114 | 5697013.719347998 | 5324372.380113265 | 4338133.796483461 | 3046360.597195155
L | 17 | 609988.7590283527 | 631962.7704943062 | 666635.0326182608 | 551436.4793223315 | 616439.127187879 | 469910.8402808926 | 271684.645270836 | 355032.6023990109 | 436203.5198327263 | 367923.3620732774 | 375352.083650367 | 544617.2751069323
L | 18 | 1389180.579667372 | 1269818.187237448 | 1221727.212650201 | 1081934.682192496 | 1149612.204460169 | 1271870.501346972 | 939406.059957076 | 865476.3437484412 | 1020633.555832605 | 1233052.944096941 | 993315.7011152642 | 889427.361311742
L | 19 | 1007961.726600675 | 877691.061054959 | 1332810.626532148 | 1144824.866276685 | 986848.2123234235 | 4890198.641689374 | 3645193.493348255 | 1701105.411555205 | 2144923.472012993 | 1963193.501296167 | 1585119.592190583 | 1227876.630133391
B | 20 | 2741860.616199873 | 2937706.371819159 | 3394534.815376876 | 2538846.034632771 | 3010297.889107284 | 2957440.22557973 | 2313315.761961142 | 2694238.030518329 | 2973630.950257623 | 3223349.853906858 | 2250935.3473251 | 1745378.068609267
L | 21 | 434257.755449147 | 439062.8996263008 | 417360.3589875223 | 354080.4811301675 | 349407.5608485048 | 229029.1584859724 | 213244.8845107019 | 255913.4310331631 | 237144.7497196705 | 229108.873737082 | 244497.9406379467 | 283401.821495772
B | 22 | 504593.6434119459 | 425681.5428927558 | 445782.7767022959 | 363981.8370646297 | 445753.669565825 | 428156.1979406779 | 588885.4420916933 | 1010947.431705744 | 503870.1797725629 | 518757.2745184213 | 381860.7997632842 | 321370.644441554
Question: how to use the filter formula to automatically select all "L" type Companies displaying their sales in a month (e.g. [NAME]).
Month to show |  | JUN |  | [NAME] used
Company type |  | B |  | A33
Show top |  | 25 |  | B33
Rank | Company | Sales
 |  | 22963406.96641705
2 | 11 | 14741858.44767728
3 | 8 | 7345081.349820712
4 | 16 | 5551175.299826701
5 | 20 | 3010297.889107284
6 | 5 | 1098898.584542919
7 | 7 | 632695.3088596584
8 | 22 | 445753.669565825