Max function with multiple criteria in vba

kmonkmol

New Member
Joined
Mar 13, 2014
Messages
28
Hi
I have a data sheet, and using entry from user form, so I need to show a particular staff last activity time in particular date, i will attach my data sheet here
Thank You


Entry Form.xlsm
ABCDEFGHIJKL
1S. NoDateFromTimeToTimeWrkCategoryEmployee NameUnitWork QTY Average/HourSubmitted BySubmitted On
2109-11-202108:15 AM10:10 AMSlicingTHOYYEBKGDates Almond Slicing7.3005.2HUB11-09-2021 10:27
3209-11-202108:15 AM10:15 AMSlicingSUMONKGDates Almond Slicing7.0005.2HUB11-09-2021 10:27
4309-11-202108:15 AM10:10 AMSlicingMURADHKGDates Walnut Slicing7.0005HUB11-09-2021 10:28
5409-11-202108:15 AM10:10 AMSlicingMOINUDHEEN2KGDates Almond Slicing7.1005HUB11-09-2021 10:28
6509-11-202108:35 AM10:45 AMSlicingABUKGDates Walnut Slicing7.2605HUB11-09-2021 10:51
7609-11-202110:00 AM11:00 AMSlicingMUHSINKGDates Walnut Slicing4.8005HUB11-09-2021 11:02
8709-11-202108:15 AM11:00 AMSlicingABINUKGDates Almond Slicing6.8005HUB11-09-2021 11:06
9809-11-202110:15 AM11:00 AMSlicingTHOYYEBKGDates Almond Slicing2.8005.2HUB11-09-2021 11:08
10909-11-202108:15 AM11:00 AMSlicingISMAILKGDates Almond Slicing6.5006.5HUB11-09-2021 11:10
111009-11-202108:15 AM11:00 AMSlicingMOHAMED ASIFKGDates Almond Slicing6.0505.2HUB11-09-2021 11:14
121109-11-202108:15 AM11:00 AMSlicingBIKASHKGDates Almond Slicing7.1005.2HUB11-09-2021 11:38
131209-11-202110:15 AM11:48 AMSlicingMANEESHKGDates Walnut Slicing3.8005HUB11-09-2021 11:49
141309-11-202110:15 AM11:48 AMSlicingMURADHKGDates Walnut Slicing4.7005HUB11-09-2021 11:50
151409-11-202111:15 AM11:48 AMSlicingMUHSINKGDates Walnut Slicing1.5005HUB11-09-2021 11:51
161509-11-202111:15 AM11:50 AMSlicingBIKASHKGDates Almond Slicing1.2005HUB11-09-2021 11:53
171611-09-202110:20 AM12:25 PMSlicingSUMONKGDates Almond Slicing6.2005.2HUB11-09-2021 12:28
181711-09-202111:15 AM12:25 PMSlicingMOINUDHEEN2KGDates Almond Slicing4.1005.2HUB11-09-2021 12:29
191811-09-202111:15 AM12:25 PMSlicingABUKGDates Almond Slicing3.9005.2HUB11-09-2021 12:29
201911-09-202111:15 AM12:25 PMSlicingABINUKGDates Almond Slicing3.1005.2HUB11-09-2021 12:30
212011-09-202111:15 AM12:25 PMSlicingMOHAMED ASIFKGDates Almond Slicing2.8005.2HUB11-09-2021 12:30
222111-09-202111:15 AM12:25 PMSlicingISMAILKGDates Almond Slicing3.4005.2HUB11-09-2021 12:31
232211-09-202112:01 PM12:45 PMStuffingSIDDIQUEKGAlmond Stuffing2.6004.425HUB11-09-2021 12:56
242311-09-202112:01 PM12:45 PMStuffingBIKASHKGAlmond Stuffing4.5004.425HUB11-09-2021 12:56
252411-09-202111:50 AM12:45 PMStuffingMUHSINKGAlmond Stuffing5.0004.425HUB11-09-2021 12:57
262511-09-202112:25 AM12:50 PMStuffingSANDEEPKGAlmond Stuffing2.5004.425HUB11-09-2021 12:58
272611-09-202111:50 AM12:50 PMStuffingMURADHKGAlmond Stuffing5.9004.425HUB11-09-2021 12:59
282711-09-202111:50 AM12:55 PMStuffingMANEESHKGAlmond Stuffing7.2004.425HUB11-09-2021 13:01
292811-09-202112:30 PM01:10 PMStuffingsumonKGCashew Stuffing3.3004.35HUB11-09-2021 13:10
302911-09-202112:40 PM01:10 PMStuffingabuKGCashew Stuffing2.6004.35HUB11-09-2021 13:11
313011-09-202112:40 PM01:10 PMStuffingmoinudheen2KGCashew Stuffing2.9004.35HUB11-09-2021 13:12
323111-09-202112:40 PM01:10 PMStuffingMOHAMED ASIFKGCashew Stuffing1.7004.35HUB11-09-2021 13:12
333211-09-202112:40 PM01:10 PMStuffingISMAILKGCashew Stuffing2.0004.35HUB11-09-2021 13:12
343311-09-202112:40 PM01:10 PMStuffingABINUKGCashew Stuffing2.6004.35HUB11-09-2021 13:13
353411-09-202112:45 PM01:18 PMStuffingbikashKGAlmond Stuffing1.8006.5HUB11-09-2021 13:20
363511-09-202112:45 PM01:22 PMStuffingMUHSINKGWalnut Stuffing1.2004HUB11-09-2021 13:23
373611-09-202112:45 PM01:22 PMStuffingSANDEEPKGWalnut Stuffing2.0004HUB11-09-2021 13:25
383711-09-202112:45 PM01:22 PMStuffingMURADHKGWalnut Stuffing1.5004HUB11-09-2021 13:26
393811-09-202112:45 PM01:22 PMStuffingMANEESHKGWalnut Stuffing1.9004HUB11-09-2021 13:26
403911-09-202101:10 PM01:25 PMStuffingSIDDIQUEKGWalnut Stuffing1.0004HUB11-09-2021 13:27
414011-09-202101:20 PM01:28 PMStuffingBIKASHKGPista Stuffing0.6002.4HUB11-09-2021 13:29
424111-09-202101:20 PM01:28 PMStuffingSUMONKGPista Stuffing0.6002.4HUB11-09-2021 13:29
434211-09-202101:20 PM01:28 PMStuffingMOINUDHEEN2KGPista Stuffing0.5002.4HUB11-09-2021 13:29
444311-09-202101:20 PM01:28 PMStuffingISMAILKGPista Stuffing0.6002.4HUB11-09-2021 13:30
454411-09-202101:20 PM01:28 PMStuffingMOHAMED ASIFKGPista Stuffing0.5002.4HUB11-09-2021 13:30
464511-09-202101:20 PM01:28 PMStuffingABINUKGPista Stuffing0.5002.4HUB11-09-2021 13:30
474611-09-202102:35 PM03:05 PMPACKINGSIDDIQUEPCSD250P6.000HUB11-09-2021 15:12
484711-09-202102:35 PM03:05 PMPACKINGMANEESHPCSD250P6.000HUB11-09-2021 15:12
494811-09-202102:35 PM03:05 PMPACKINGMOINUDHEEN2PCSD250P6.000HUB11-09-2021 15:12
504911-09-202102:35 PM03:05 PMPACKINGMUHSINPCSD250P6.000HUB11-09-2021 15:12
515011-09-202102:35 PM03:05 PMPACKINGMURADHPCSD250P6.000HUB11-09-2021 15:12
525111-09-202102:35 PM03:05 PMPACKINGSUMONPCSD250P6.000HUB11-09-2021 15:13
535211-09-202102:35 PM03:05 PMPACKINGSANDEEPPCSD250P5.000HUB11-09-2021 15:13
545311-09-202102:35 PM03:30 PMStuffingABUKGWalnut Stuffing3.6004HUB11-09-2021 15:31
555411-09-202102:35 PM03:30 PMStuffingABINUKGWalnut Stuffing3.0004HUB11-09-2021 15:31
565511-09-202103:06 PM03:39 PMPACKINGSIDDIQUEPCSD500P5.000HUB11-09-2021 15:40
575611-09-202103:06 PM03:39 PMPACKINGMURADHPCSD500P5.000HUB11-09-2021 15:41
585711-09-202103:06 PM03:39 PMPACKINGMOINUDHEEN2PCSD500P4.000HUB11-09-2021 15:41
595811-09-202103:06 PM03:39 PMPACKINGMANEESH`PCSD500P4.000HUB11-09-2021 15:41
605911-09-202103:06 PM03:39 PMPACKINGSUMONPCSD500P4.000HUB11-09-2021 15:42
616011-09-202103:06 PM03:39 PMPACKINGSANDEEPPCSD500P4.000HUB11-09-2021 15:42
626111-09-202103:06 PM03:39 PMPACKINGMUHSINPCSD500P4.000HUB11-09-2021 15:42
636211-09-202103:07 PM04:00 PMPACKINGMUHSINPCSD1000P1.420HUB11-09-2021 16:03
646311-09-202103:07 PM04:00 PMPACKINGSIDDIQUEPCSD1000P1.400HUB11-09-2021 16:03
656411-09-202103:07 PM04:00 PMPACKINGMOINUDHEEN2PCSD1000P1.400HUB11-09-2021 16:03
666511-09-202103:07 PM04:00 PMPACKINGMURADHPCSD1000P1.400HUB11-09-2021 16:04
676611-09-202103:07 PM04:00 PMPACKINGSUMONPCSD1000P1.400HUB11-09-2021 16:04
686711-09-202103:07 PM04:00 PMPACKINGMANEESHPCSD1000P1.400HUB11-09-2021 16:04
696811-09-202103:07 PM04:00 PMPACKINGSANDEEPPCSD1000P1.400HUB11-09-2021 16:04
706911-09-202102:50 PM04:00 PMCuttingMADHAVKGWALNUT CUTTING5.0005HUB11-09-2021 16:05
717011-09-202102:36 PM04:00 PMStuffingBIKASHKGPista Stuffing3.5002.4HUB11-09-2021 16:19
727111-09-202102:36 PM04:00 PMStuffingMOHAMED ASIFKGPista Stuffing3.1002.4HUB11-09-2021 16:19
737211-09-202102:36 PM04:00 PMStuffingISMAILKGPista Stuffing3.4002.4HUB11-09-2021 16:20
747311-09-202102:36 PM04:00 PMStuffingABUKGPista Stuffing1.5002.4HUB11-09-2021 16:21
757411-09-202102:36 PM04:00 PMStuffingABINUKGPista Stuffing0.4002.4HUB11-09-2021 16:21
767511-09-202104:15 PM04:38 PMPACKINGSIDDIQUEPCSDS250P6.850HUB11-09-2021 16:42
777611-09-202104:15 PM04:38 PMPACKINGMURADHPCSDS250P6.850HUB11-09-2021 16:43
787711-09-202104:15 PM04:38 PMPACKINGMOINUDHEEN2PCSDS250P6.850HUB11-09-2021 16:43
797811-09-202104:15 PM04:38 PMPACKINGMANEESHPCSDS250P6.850HUB11-09-2021 16:43
807911-09-202104:15 PM04:38 PMPACKINGSANDEEPPCSDS250P6.850HUB11-09-2021 16:43
818011-09-202104:15 PM04:38 PMPACKINGMUHSINPCSDS250P6.850HUB11-09-2021 16:44
828111-09-202104:15 PM04:38 PMPACKINGSUMONPCSDS250P6.850HUB11-09-2021 16:44
838211-09-202104:15 PM04:49 PMStuffingBIKASHKGCashew Stuffing1.4004.35HUB11-09-2021 16:49
848311-09-202104:15 PM04:49 PMStuffingISMAILKGCashew Stuffing1.3004.35HUB11-09-2021 16:50
858411-09-202102:36 PM04:00 PMStuffingMAZHARULKGPista Stuffing4.1002.4HUB11-09-2021 16:54
868511-09-202104:15 PM04:49 PMStuffingMAZHARULKGCashew Stuffing1.3004.35HUB11-09-2021 16:57
878611-09-202104:15 PM05:00 PMStuffingABINUKGOrangepeel Stuffing1.0504.6HUB11-09-2021 17:01
888711-09-202104:15 PM05:00 PMStuffingABUKGOrangepeel Stuffing1.2004.6HUB11-09-2021 17:02
898811-09-202104:15 PM05:00 PMStuffingMOHAMED ASIFKGOrangepeel Stuffing1.2004.6HUB11-09-2021 17:02
908911-09-202104:40 PM05:08 PMPACKINGSIDDIQUEPCSDS500P6.140HUB11-09-2021 17:10
919011-09-202104:40 PM05:08 PMPACKINGMURADHPCSDS500P6.140HUB11-09-2021 17:10
929111-09-202104:40 PM05:08 PMPACKINGMOINUDHEEN2PCSDS500P6.140HUB11-09-2021 17:10
939211-09-202104:40 PM05:08 PMPACKINGMANEESHPCSDS500P6.140HUB11-09-2021 17:10
949311-09-202104:40 PM05:08 PMPACKINGSANDEEPPCSDS500P6.140HUB11-09-2021 17:11
959411-09-202104:40 PM05:08 PMPACKINGSUMONPCSDS500P6.140HUB11-09-2021 17:11
969511-09-202104:40 PM05:08 PMPACKINGMUHSINPCSDS500P6.140HUB11-09-2021 17:11
979611-09-202105:00 PM05:30 PMPACKINGMADHAVPCSD1000P2.000HUB11-09-2021 17:38
989711-09-202104:50 PM05:50 PMStuffingISMAILKGFig Stuffing3.3308.7HUB11-09-2021 17:52
999811-09-202104:50 PM05:50 PMStuffingMAZHARULKGFig Stuffing3.3308.7HUB11-09-2021 17:52
1009911-09-202104:50 PM05:50 PMStuffingMOHAMED ASIFKGFig Stuffing3.3308.7HUB11-09-2021 17:52
10110011-09-202105:35 PM05:45 PMStuffingMADHAVKGCashew Stuffing0.5004.35HUB11-09-2021 17:55
10210111-09-202105:10 PM05:50 PMPACKINGSIDDIQUEPCSDS1000P3.570HUB11-09-2021 17:56
10310211-09-202105:10 PM05:50 PMPACKINGMURADHPCSDS1000P3.570HUB11-09-2021 17:57
10410311-09-202105:10 PM05:50 PMPACKINGMOINUDHEEN2PCSDS1000P3.570HUB11-09-2021 17:57
10510411-09-202105:10 PM05:50 PMPACKINGMANEESHPCSDS1000P3.570HUB11-09-2021 17:57
10610511-09-202105:10 PM05:50 PMPACKINGSUMONPCSDS1000P3.570HUB11-09-2021 17:57
10710611-09-202105:10 PM05:50 PMPACKINGSANDEEPPCSDS1000P3.570HUB11-09-2021 17:58
10810711-09-202105:10 PM05:50 PMPACKINGMUHSINPCSDS1000P3.570HUB11-09-2021 17:58
10910811-09-202105:00 PM06:00 PMStuffingABUKGWalnut Stuffing3.8004HUB11-09-2021 18:03
11010911-09-202105:45 PM06:10 PMPACKINGMADHAVPCSAD250P14.0004HUB11-09-2021 18:11
11111011-09-202105:52 PM06:15 PMStuffingISMAILKGWalnut Stuffing1.0504HUB11-09-2021 18:20
11211111-09-202105:52 PM06:22 PMStuffingBIKASHKGWalnut Stuffing1.4004HUB11-09-2021 18:25
11311211-09-202105:52 PM06:22 PMStuffingMAZHARULKGWalnut Stuffing1.7004HUB11-09-2021 18:26
11411311-09-202105:00 PM06:29 PMStuffingABINUKGWalnut Stuffing4.8004HUB11-09-2021 18:30
11511411-09-202105:00 PM06:29 PMStuffingMOHAMED ASIFKGWalnut Stuffing3.8004HUB11-09-2021 18:30
11611511-09-202105:50 PM06:25 PMPACKINGSIDDIQUEPCSDSL500P6.420HUB11-09-2021 18:48
11711611-09-202105:50 PM06:25 PMPACKINGMURADHPCSDSL500P6.420HUB11-09-2021 18:48
11811711-09-202105:50 PM06:25 PMPACKINGMOINUDHEEN2PCSDSL500P6.420HUB11-09-2021 18:48
11911811-09-202105:50 PM06:25 PMPACKINGSANDEEPPCSDSL500P6.420HUB11-09-2021 18:48
12011911-09-202105:50 PM06:25 PMPACKINGSUMONPCSDSL500P6.420HUB11-09-2021 18:49
12112011-09-202105:50 PM06:25 PMPACKINGMANEESHPCSDSL500P6.420HUB11-09-2021 18:49
12212111-09-202105:50 PM06:25 PMPACKINGMADAMPCSDSL500P6.420HUB11-09-2021 18:51
12312211-09-202106:25 PM06:45 PMPACKINGMADAMPCSDWP250P4.000HUB11-09-2021 18:52
12412311-09-202106:25 PM06:45 PMPACKINGSIDDIQUEPCSDWP500P5.000HUB11-09-2021 18:53
12512411-09-202106:25 PM06:45 PMPACKINGMURADHPCSDWP500P5.000HUB11-09-2021 18:55
12612511-09-202106:25 PM06:45 PMPACKINGMOINUDHEEN2PCSDWP500P5.000HUB11-09-2021 18:55
12712611-09-202106:25 PM06:45 PMPACKINGSANDEEPPCSDWP500P4.000HUB11-09-2021 18:55
12812711-09-202106:25 PM06:45 PMPACKINGSUMONPCSDWP250P4.000HUB11-09-2021 18:57
12912811-09-202106:45 PM06:52 PMPACKINGSIDDIQUEPCSDWA250P1.000HUB11-09-2021 19:01
13012911-09-202106:50 PM07:05 PMPACKINGSIDDIQUEPCSDWA500P3.160HUB11-09-2021 19:08
13113011-09-202106:50 PM07:05 PMPACKINGMURADHPCSDWA500P3.160HUB11-09-2021 19:08
13213111-09-202106:50 PM07:05 PMPACKINGMADAMPCSDWA500P3.160HUB11-09-2021 19:09
13313211-09-202106:50 PM07:05 PMPACKINGMOINUDHEEN2PCSDWA500P3.160HUB11-09-2021 19:09
13413311-09-202106:50 PM07:05 PMPACKINGSANDEEPPCSDWA500P3.160HUB11-09-2021 19:09
13513411-09-202106:50 PM07:05 PMPACKINGSUMONPCSDWA500P3.160HUB11-09-2021 19:09
13613511-09-202106:10 PM07:20 PMSlicingMADHAVKGDates Almond Slicing4.2005.2HUB11-09-2021 19:21
13713611-09-202106:10 PM07:20 PMSlicingBIKASHKGDates Almond Slicing2.6005.2HUB11-09-2021 19:22
13813711-09-202106:10 PM07:20 PMSlicingISMAILKGDates Almond Slicing2.4005.2HUB11-09-2021 19:22
13913811-09-202107:06 PM07:16 PMPACKINGSIDDIQUEPCSDWW250P3.000HUB11-09-2021 19:36
14013911-09-202107:06 PM07:16 PMPACKINGSUMONPCSDWW250P3.000HUB11-09-2021 19:36
14114011-09-202107:06 PM07:16 PMPACKINGMURADHPCSDWW250P3.000HUB11-09-2021 19:36
14214111-09-202107:06 PM07:16 PMPACKINGMOINUDHEEN2PCSDWW250P3.000HUB11-09-2021 19:36
14314211-09-202107:06 PM07:16 PMPACKINGSANDEEPPCSDWW250P3.000HUB11-09-2021 19:36
14414311-09-202107:06 PM07:16 PMPACKINGMADAMPCSDWW250P3.000HUB11-09-2021 19:37
14514411-09-202107:07 PM07:37 PMPACKINGSANDEEPPCSMSL200P3.000HUB11-09-2021 19:39
14614511-09-202107:07 PM07:25 PMPACKINGSIDDIQUEPCSDWW500P4.000HUB11-09-2021 19:41
14714611-09-202107:07 PM07:25 PMPACKINGSUMONPCSDWW500P4.000HUB11-09-2021 19:41
14814711-09-202107:07 PM07:25 PMPACKINGMOINUDHEEN2PCSDWW500P4.000HUB11-09-2021 19:42
14914811-09-202107:07 PM07:25 PMPACKINGMADAMPCSDWW500P4.000HUB11-09-2021 19:42
15014911-09-202107:07 PM07:25 PMPACKINGMURADHPCSDWW500P4.000HUB11-09-2021 19:42
15115011-09-202107:07 PM07:25 PMPACKINGISMAILPCSDWW500P4.000HUB11-09-2021 19:44
15215111-09-202107:35 PM07:44 PMPACKINGSANDEEPPCSMD200P3.000HUB11-09-2021 19:45
15315211-09-202107:30 PM07:35 PMPACKINGSUMONPCSDWO250P1.000HUB11-09-2021 19:47
15415311-09-202107:30 PM07:35 PMPACKINGMURADHPCSDWO250P1.000HUB11-09-2021 19:47
15515411-09-202107:30 PM07:35 PMPACKINGISMAILPCSDWO250P1.000HUB11-09-2021 19:47
15615511-09-202107:30 PM07:35 PMPACKINGMOINUDHEEN2PCSDWO250P1.000HUB11-09-2021 19:47
15715611-09-202107:30 PM07:35 PMPACKINGSANDEEPPCSDWO250P1.000HUB11-09-2021 19:47
15815711-09-202107:30 PM07:35 PMPACKINGMADAMPCSDWO250P1.000HUB11-09-2021 19:47
15915811-09-202107:35 PM07:40 PMPACKINGMADAMPCSDWO500P2.000HUB11-09-2021 19:47
16015911-09-202107:38 PM07:51 PMPACKINGMURADHPCSAJW200P1.710HUB11-09-2021 19:52
16116011-09-202107:38 PM07:51 PMPACKINGISMAILPCSAJW200P1.710HUB11-09-2021 19:52
16216111-09-202107:38 PM07:51 PMPACKINGMOINUDHEEN2PCSAJW200P1.710HUB11-09-2021 19:52
16316211-09-202107:38 PM07:51 PMPACKINGSANDEEPPCSAJW200P1.710HUB11-09-2021 19:52
16416311-09-202107:38 PM07:51 PMPACKINGSUMONPCSAJW200P1.710HUB11-09-2021 19:52
16516411-09-202107:38 PM07:51 PMPACKINGMADAMPCSAJW200P1.710HUB11-09-2021 19:53
16616511-09-202107:52 PM08:55 PMPACKINGSIDDIQUEPCSAD500P1.420HUB11-09-2021 19:57
16716611-09-202107:52 PM08:55 PMPACKINGMURADHPCSAD500P1.420HUB11-09-2021 19:57
Database
Cell Formulas
RangeFormula
A2:A167A2=ROW()-1
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

earthworm

Well-known Member
Joined
May 19, 2009
Messages
634
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
You need to elaborate as to how do you want the answer to be shown with an example
 

kmonkmol

New Member
Joined
Mar 13, 2014
Messages
28
You need to elaborate as to how do you want the answer to be shown with an example
Sir
Please find attached image of user form, If I Pick a employee Name I need to show That Persons Last "To Time" from latest Date Show
Eg.jpg
in circled Text column.
 

earthworm

Well-known Member
Joined
May 19, 2009
Messages
634
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
Its easy but i think you are using another platform
Sir
Please find attached image of user form, If I Pick a employee Name I need to show That Persons Last "To Time" from latest Date ShowView attachment 50905 in circled Text column.
Please share the data using xl2bb that can be copied.
 

earthworm

Well-known Member
Joined
May 19, 2009
Messages
634
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
See post#1 ;)
I forgot.

@kmonkmol

Paste this in column N , O , P

Note that this is non array formula . hope you are not using old version of office.

Cell Formulas
RangeFormula
O2:O18O2=INDEX($D$2:$D$167,AGGREGATE(14,6,ROW($D$2:$D$167)-ROW($D$2)+1/($F$2:$F$167=$N2),1))
P2:P18P2=INDEX($B$2:$B$167,AGGREGATE(14,6,ROW($B$2:$B$167)-ROW($B$2)+1/($F$2:$F$167=$N2),1))
 
Learn Excel from Bill Jelen

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

Forum statistics

Threads
1,151,492
Messages
5,764,686
Members
425,230
Latest member
DzOus

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top