Max function with multiple criteria in vba

kmonkmol

kmonkmol

Board Regular
Joined
Mar 13, 2014
Messages
50
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

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
Sort by date Sort by votes
You need to elaborate as to how do you want the answer to be shown with an example
 
Upvote 0
earthworm said:
You need to elaborate as to how do you want the answer to be shown with an example
Click to expand...
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.
 
Upvote 0
Its easy but i think you are using another platform
kmonkmol said:
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.
Click to expand...
Please share the data using xl2bb that can be copied.
 
Upvote 0
Fluff said:
See post#1 ;)
Click to expand...
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.

Book1
NOP
1Employee NameLast To timeLastest Date
2THOYYEB11:00 AM09-Nov-2021
3SUMON7:51 PM11-Sep-2021
4MURADH8:55 PM11-Sep-2021
5MOINUDHEEN27:51 PM11-Sep-2021
6ABU6:00 PM11-Sep-2021
7MUHSIN5:50 PM11-Sep-2021
8ABINU6:29 PM11-Sep-2021
9ISMAIL7:51 PM11-Sep-2021
10MOHAMED ASIF6:29 PM11-Sep-2021
11BIKASH7:20 PM11-Sep-2021
12MANEESH6:25 PM11-Sep-2021
13SIDDIQUE8:55 PM11-Sep-2021
14SANDEEP7:51 PM11-Sep-2021
15MANEESH`3:39 PM11-Sep-2021
16MADHAV7:20 PM11-Sep-2021
17MAZHARUL6:22 PM11-Sep-2021
18MADAM7:51 PM11-Sep-2021
Sheet1
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))
 
Upvote 0
Solution
You must log in or register to reply here.

Similar threads

D
  • Solved
Multiple answer for particular timesets and making a box if all relevant data matches
Replies
7
Views
178
myall_blues
myall_blues
youbitto
  • Solved
Copy paste from multiple Excel and Csv files to another excel file VBA
Replies
2
Views
207
youbitto
youbitto
SaraWitch
  • Solved
VLOOKUP formula with multiple IF statements
Replies
2
Views
908
SaraWitch
SaraWitch
F
  • Question Question
Looking to index some data based on multiple criteria, then index further data based on the 1st indexed data results
2
Replies
13
Views
911
KRice
K
S
  • Question Question
Deleting multiple rows, columns, unmerging, pivot table all at once.
Replies
2
Views
102
HighAndWilder
H

Forum statistics

Threads
1,224,808
Messages
6,181,073
Members
453,020
Latest member
mattg2448

Share this page

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
Back
Top