HI Friend
i need an assistance with a formula to to Search and find the date & time where Materials ID
In Column G, i Have DESCRIPTION of ITEM Listed
In Column I, i have Date & TIme Listed
In Column O, I have The Description of Item Listed also As Criteria
I need to help with formula to Search Date & Time when the Criteria In Column O if There in Column G then to give the Date & Time in column P
I have place an Example Highlighted Appreciate if i could get a better way and formula to extract it all
Thank
i need an assistance with a formula to to Search and find the date & time where Materials ID
In Column G, i Have DESCRIPTION of ITEM Listed
In Column I, i have Date & TIme Listed
In Column O, I have The Description of Item Listed also As Criteria
I need to help with formula to Search Date & Time when the Criteria In Column O if There in Column G then to give the Date & Time in column P
I have place an Example Highlighted Appreciate if i could get a better way and formula to extract it all
Thank
LIFTING INSPECTION RELEASED DETAILS JAN-2022 to 23 MAY 2022.xlsx | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
G | H | I | J | K | L | M | N | O | P | |||
3 | DESCRIPTION | CATEGORY | Date Inspected | Vessel Name | Date | Rig Name | Supplier Name | DESCRIPTION Cargo ID | SEARCH RESULT Date | |||
4 | TAC 18-03 | C | 01/01/2022 09:00:00 | SEACOR OHIO | 1-Jan-22 | Barge Al Hyleh | ADNH | AF-3 | ||||
5 | 9990BD10664221 | C | 01/01/2022 09:40:00 | SEACOR OHIO | 1-Jan-22 | Barge Al Hyleh | ADNH | AC-20 | ||||
6 | BUNDLE OF PIPE | B | 01/01/2022 10:10:00 | SEACOR OHIO | 1-Jan-22 | Barge Al Hyleh | ADNH | AC-36 | ||||
7 | 275 | C | 01/01/2022 13:50:00 | SEACOR OHIO | 1-Jan-22 | Barge Al Hyleh | ADNH | AD-6 | ||||
8 | 282, 247 | C | 01/01/2022 13:50:00 | SEACOR OHIO | 1-Jan-22 | Barge Al Hyleh | ADNH | AD-8 | ||||
9 | DNVU-49175, DNVU-49155, DNVU-49191, DNVU-49103, DNVU-49123, DNVU-49125 | C | 01/01/2022 10:00:00 | SEACOR OHIO | 1-Jan-22 | Barge Al Hyleh | ADNOC OFFSHORE | MTB-64-76 | ||||
10 | BARGE OXY-07, BARGE OXY-29, BARGE OXY-26, ZK FBN-OXG-28 | C | 01/01/2022 12:30:00 | SEACOR OHIO | 1-Jan-22 | Barge Al Hyleh | ADNOC OFFSHORE | MTB-64-81 | ||||
11 | 6647-4921, SCB-064, TF-20F-020 | C | 01/01/2022 12:30:00 | SEACOR OHIO | 1-Jan-22 | Barge Al Hyleh | ADNOC OFFSHORE | MTB-64-84 | ||||
12 | TF-20F-043, SCB-011, ZL-316 | C | 01/01/2022 12:30:00 | SEACOR OHIO | 1-Jan-22 | Barge Al Hyleh | ADNOC OFFSHORE | MTB-64-37 | ||||
13 | 35-34-04 | C | 01/01/2022 13:15:00 | SEACOR OHIO | 1-Jan-22 | Barge Al Hyleh | ADNOC OFFSHORE | 5123-0707 | ||||
14 | LCB-006 | C | 01/01/2022 12:00:00 | SEACOR OHIO | 1-Jan-22 | Barge Al Hyleh | ADNOC OFFSHORE | JO-Q-057 | ||||
15 | ZTS-204 | C | 01/01/2022 12:00:00 | SEACOR OHIO | 1-Jan-22 | Barge Al Hyleh | ALPHAMED | 251 | ||||
16 | 9259/1-2,266135,266959 | C | 01/01/2022 13:10:00 | SEACOR OHIO | 1-Jan-22 | Barge Al Hyleh | ALPHAMED | 266 | ||||
17 | MB-BAL-04 | C | 01/01/2022 13:10:00 | SEACOR OHIO | 1-Jan-22 | Rig Marawwah | ADNOC L&S | BULK | ||||
18 | A-301,A-302,A-303,A-106,A310,A-311,A-312,A-315,HB-003 | C | 01/01/2022 13:10:00 | SEACOR OHIO | 1-Jan-22 | Rig Marawwah | ADNOC L&S | BULK | ||||
19 | GCA-307 | C | 01/01/2022 14:00:00 | SEACOR OHIO | 1-Jan-22 | Rig Marawwah | ADNOC L & S | BULK | ||||
20 | GCA-102 | C | 01/01/2022 14:00:00 | SEACOR OHIO | 1-Jan-22 | Rig Marawwah | ADNOC OFFSHORE | JU-321 | ||||
21 | BF4012C075 | C | 01/01/2022 22:45:00 | SEACOR OHIO | 1-Jan-22 | Rig Marawwah | ADNOC OFFSHORE | JU-445 | ||||
22 | TRD-45668, 62499, 73154 | C | 01/01/2022 22:45:00 | SEACOR OHIO | 1-Jan-22 | Rig Marawwah | AL AHLIA | A-301 | 01/01/2022 13:10:00 | |||
23 | GI OB 009 | C | 01/01/2022 20:40:00 | SEACOR OHIO | 1-Jan-22 | Rig Marawwah | AL AHLIA | A-302 | 01/01/2022 13:10:00 | |||
24 | 10 BUNDLES, 210299, 13519682, GYD B12, HAL 3340-3, HAL 3340-11, HAL 2735/2 | C | 01/01/2022 22:10:00 | SEACOR OHIO | 1-Jan-22 | Rig Marawwah | AL AHLIA | A-303 | 01/01/2022 13:10:00 | |||
25 | 1479-01 | C | 01/01/2022 22:10:00 | SEACOR OHIO | 1-Jan-22 | Rig Marawwah | AL AHLIA | A-106 | 01/01/2022 13:10:00 | |||
26 | TOTES | T | 01/01/2022 22:10:00 | SEACOR OHIO | 1-Jan-22 | Rig Marawwah | AL AHLIA | A-310 | 01/01/2022 13:10:00 | |||
27 | CBX 221 | C | 01/01/2022 22:10:00 | SEACOR OHIO | 1-Jan-22 | Rig Marawwah | AL AHLIA | A-311 | 01/01/2022 13:10:00 | |||
28 | OGCN 20010 | C | 01/02/2022 09:50:00 | SEACOR OHIO | 1-Jan-22 | Rig Marawwah | AL AHLIA | A-312 | 01/01/2022 13:10:00 | |||
29 | H 5151 | C | 01/02/2022 11:15:00 | SEACOR OHIO | 1-Jan-22 | Rig Marawwah | AL AHLIA | A-315 | 01/01/2022 13:10:00 | |||
30 | 1702058-06, 3902-1, 3902-3 | C | 01/02/2022 11:15:00 | SEACOR OHIO | 1-Jan-22 | Rig Marawwah | AL AHLIA | HB-003 | 01/01/2022 13:10:00 | |||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
I4:I30 | I4 | =CONCATENATE(TEXT(B4,"mm/dd/yyyy")&" "&TEXT(F4,"hh:mm:ss")) |