Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

On the sheet the named "Cycle Time", I need a formula in cell L3 that will search for the person's name in cell A3 in column P on the sheet named "Xactanalysis Raw Data" and return the earliest date in column Z of the "Xactanalysis Raw Data" sheet for that person's name back to cell L3 of "Cycle Time". I intend to copy this formula down the sheet.
Solved by G. J. in 16 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 12/09/2018 - 02:55
Excelchat Expert 12/09/2018 - 02:55
can you please share the excel with the data
User 12/09/2018 - 02:56
hang on trying to send in a link
User 12/09/2018 - 02:56
it wont let me paste the box link in the chat
User 12/09/2018 - 02:57
that is it in the spreadsheet window
Excelchat Expert 12/09/2018 - 02:57
let me try
Excelchat Expert 12/09/2018 - 02:58
its taking very long to load .. Do you mind if i download it and update the formula and send it to you
User 12/09/2018 - 02:58
that is fine. Did what I needed come through in the post a problem?
Excelchat Expert 12/09/2018 - 02:59
want to search person's name in A3 of cycle sheet in column p of Xactanalysis Raw Data
Excelchat Expert 12/09/2018 - 02:59
Get the min date and place it in L3
Excelchat Expert 12/09/2018 - 02:59
is that right
User 12/09/2018 - 03:00
Excelchat Expert 12/09/2018 - 03:00
give me few min to work on the formula
Excelchat Expert 12/09/2018 - 03:06
i gave got the formula but cannot upload here as it is a macro file
Excelchat Expert 12/09/2018 - 03:06
Excelchat Expert 12/09/2018 - 03:06
can you try to download it from here
Excelchat Expert 12/09/2018 - 03:06
l3 formula =MIN(IF($A3='XactAnalysis Raw Data'!$P$2:$P$1537,'XactAnalysis Raw Data'!$Z$2:$Z$1537))
Excelchat Expert 12/09/2018 - 03:07
its an array formula so after entering the formula you have to click cntrl+shift+enter
User 12/09/2018 - 03:08
it downloaded let me look at it
User 12/09/2018 - 03:08
I figured it needed to be an array but I wasn't sure how to make it fine the earliest date
Excelchat Expert 12/09/2018 - 03:09
Min or small will work
User 12/09/2018 - 03:10
Excelchat Expert 12/09/2018 - 03:10
User 12/09/2018 - 03:10
I should have what I need to do what I need to next
Excelchat Expert 12/09/2018 - 03:11
Please do not forget to leave a feedback once you have clicked on end session
Excelchat Expert 12/09/2018 - 03:11
User 12/09/2018 - 03:11
no problem
Excelchat Expert 12/09/2018 - 03:11
have a lovely day

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc