Lookup of the latest date arrival date

ExcelNewbie2020

Active Member
Joined
Dec 3, 2020
Messages
350
Office Version
  1. 365
Platform
  1. Windows
Sirs/Ma'ams,


I have a long range of column table, in which, dates as column header. Under each column, there is number 2=Arrival, 1=Departure and 3=whole day.

I would like to lookup for the latest date of arrival, if the return value is a column header?..

SAMPLE.xlsx
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAH
12= ARRIVAL
21= DEPARTURE
33=WHOLE DAY
4BLUE=CURRENT DATE
5AUGUST 2022
6NAME#DEPT01020304050607080910111213141516171819202122232425262728293031
7NAME 11HR23333
8NAME 22HR2333
9NAME 33HR23333333333333333333
10NAME 44HR
11NAME 55HR33333333333333331
12NAME 66ADMIN
13NAME 77ADMIN
14NAME 88ADMIN331
15NAME 99ADMIN2333
16NAME 1010OPERATIONS23333331
17NAME 1111OPERATIONS3333333331
18NAME 1212OPERATIONS33333331233333
19NAME 1313OPERATIONS233333333333331
20NAME 1414OPERATIONS
21NAME 1515OPERATIONS3333333333331
22NAME 1616ACCTG23333333333
23NAME 1717ACCTG3312333
24NAME 1818ACCTG233333333333333333
25NAME 1919ACCTG233333333333333333
26NAME 2020ACCTG23333331
27NAME 2121ACCTG3312333
28NAME 2222WHSE233333333333331
29NAME 2323WHSE23333333333
30NAME 2424WHSE233333333333333333
31NAME 2525WHSE2333
32NAME 2626WHSE1
33NAME 2727MEDICAL233333333333333333
34NAME 2828MEDICAL33333331
35NAME 2929MEDICAL23333333333331
36
37
38
39RESULT
40#DATE ARRIVE
41116-08-22
42217-08-22
43301-08-22
444
455
466
477
488
49917-08-22
501010-08-22
5111
521215-08-22
531303-08-22
5414
5515
561610-08-22
571717-08-22
581803-08-22
591903-08-22
602003-08-22
612117-08-22
622203-08-22
632310-08-22
642403-08-22
652517-08-22
6626
672703-08-22
6828
692903-08-22
Sheet1
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
Glad to help & thanks for the feedback.
 
Upvote 0

Forum statistics

Threads
1,224,825
Messages
6,181,191
Members
453,021
Latest member
pingpong7117

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