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
HI
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
yes
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
https://www.dropbox.com/s/4tfodx1etvlrhi7/Hurricane%20Florence.xlsm?dl=0
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
Thanks
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.
