extract full column from another sheet

[tranh]

Hi Mr. Excel,
there are few date columns in data sheet and I want to collect 1 column that match the latest date column to another sheet
is there any simple way that does not need to use VBA, because VBA doesn't work when I share this worksheet to others.

thanks,
Tranh

 

[Oscar Cronquist]

[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

A​

[/th][th]

B​

[/th][th]

C​

[/th][th]

D​

[/th][th]

E​

[/th][th]

F​

[/th][th]

G​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

1​

[/td][td]Date1[/td][td]Date2[/td][td]Date3[/td][td][/td][td]Latest Date[/td][td][/td][td]Column[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

2​

[/td][td]

9/11/2017​

[/td][td]

2/15/2017​

[/td][td]

5/2/2018​

[/td][td][/td][td]

11/1/2018​

[/td][td][/td][td]

2/15/2017​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

3​

[/td][td]

11/14/2017​

[/td][td]

6/25/2018​

[/td][td]

4/2/2018​

[/td][td][/td][td][/td][td][/td][td]

6/25/2018​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

4​

[/td][td]

9/18/2018​

[/td][td]

1/6/2018​

[/td][td]

5/6/2018​

[/td][td][/td][td][/td][td][/td][td]

1/6/2018​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

5​

[/td][td]

7/13/2018​

[/td][td]

11/1/2018​

[/td][td]

9/10/2018​

[/td][td][/td][td][/td][td][/td][td]

11/1/2018​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

6​

[/td][td]

6/8/2018​

[/td][td]

9/3/2017​

[/td][td]

1/21/2017​

[/td][td][/td][td][/td][td][/td][td]

9/3/2017​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

7​

[/td][td]

1/10/2018​

[/td][td]

7/21/2017​

[/td][td]

8/4/2018​

[/td][td][/td][td][/td][td][/td][td]

7/21/2017​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

8​

[/td][td]

7/11/2018​

[/td][td]

5/22/2018​

[/td][td]

8/21/2018​

[/td][td][/td][td][/td][td][/td][td]

5/22/2018​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

9​

[/td][td]

7/1/2018​

[/td][td]

1/29/2017​

[/td][td]

7/30/2018​

[/td][td][/td][td][/td][td][/td][td]

1/29/2017​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

10​

[/td][td]

5/7/2017​

[/td][td]

9/6/2018​

[/td][td]

4/23/2017​

[/td][td][/td][td][/td][td][/td][td]

9/6/2018​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

11​

[/td][td]

12/6/2017​

[/td][td]

7/3/2017​

[/td][td]

2/20/2017​

[/td][td][/td][td][/td][td][/td][td]

7/3/2017​

[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet57[/td][/tr][/table]

Array formula in cell range G2:G11:
=INDEX($A$2:$C$11,0,MIN(IF(E2=A2:C11,MATCH(COLUMN(A2:C11),COLUMN(A2:C11)),"")))

Formula in cell E2:
=MAX(A2:C11)

 

[tranh]

sorry if i made any misunderstanding and because I'm very new here...
I did add images on my previous post but maybe something went wrong so those images didn't show up...

Below are 2 images that hope it explains more of my question

there are few date columns in data sheet and I want to collect 1 column that match the latest date column to another sheet
is there any simple way that does not need to use VBA, because VBA doesn't work when I share this worksheet to others.

Thanks,

 

[tranh]

sorry if i made any misunderstanding and because I'm very new here...
I did add images on my previous post but maybe something went wrong so those images didn't show up...

Below are 2 images that hope it explains more of my question

[/URL][/IMG]

there are few date columns in data sheet and I want to collect 1 column that match the latest date column to another sheet
is there any simple way that does not need to use VBA, because VBA doesn't work when I share this worksheet to others.

[/URL][/IMG]

Thanks,

 

[tranh]

[/URL][/IMG]

 

[Oscar Cronquist]

Array Formula entered in cell range E4:E9:

=INDEX(A4:D9,0, MATCH(MAX(A3:D3),A3:D3,0))

1. Select cell range E4:E9.
2. Copy/Paste formula into the formula bar.
3. Press and hold CTRL + SHIFT
4. Press Enter