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]

	A​	B​	C​	D​	E​	F​	G​
1​	Date1	Date2	Date3		Latest Date		Column
2​	9/11/2017​	2/15/2017​	5/2/2018​		11/1/2018​		2/15/2017​
3​	11/14/2017​	6/25/2018​	4/2/2018​				6/25/2018​
4​	9/18/2018​	1/6/2018​	5/6/2018​				1/6/2018​
5​	7/13/2018​	11/1/2018​	9/10/2018​				11/1/2018​
6​	6/8/2018​	9/3/2017​	1/21/2017​				9/3/2017​
7​	1/10/2018​	7/21/2017​	8/4/2018​				7/21/2017​
8​	7/11/2018​	5/22/2018​	8/21/2018​				5/22/2018​
9​	7/1/2018​	1/29/2017​	7/30/2018​				1/29/2017​
10​	5/7/2017​	9/6/2018​	4/23/2017​				9/6/2018​
11​	12/6/2017​	7/3/2017​	2/20/2017​				7/3/2017​

Sheet: Sheet57

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