Get 1 1st Item by the earliest date and time

Which version of Excel do you have? Please update your forum profile.

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

Hi thank you for replying my thread,
Here is the Screenshot of my sheet Hope you can understand it.

FYI i am using Spreadsheet


Attachment 844026

please inserts " https: " before //
//docs.google.com/spreadsheets/d/1XnWcqK982BjkH-vQpAwQVXIB3Px2kYLaa6pt7V2UHRw/edit#gid=1012361527

1. You were told that a screenshot is USELESS. We can not edit it.

2. You have NOT told us which Excel product you are using. "Spreadsheet" is meaningless.

3. I have assumed that you have O365. This will NOT work with earlier products. But we don't know... as you never told us...

Formula:

Please Login or Register  to view this content.

thank you for replying, sorry about my issue, im new on this
The Version i use is Google Spreadsheet
im trying to input the URL but unable to do it.

your formula its worked in excel, trying applied it to google spreadsheet the take function was unble using on google

please inserts " https: " before //
//docs.google.com/spreadsheets/d/1XnWcqK982BjkH-vQpAwQVXIB3Px2kYLaa6pt7V2UHRw/edit#gid=1012361527

Change your forum profile to GoogleSheets. I am moving this to the correct sub-forum.

It won't work in GS. I don't use GS, so I'm out. others will be able to help.

Looking through the list of google sheet functions, it appears that all of those used in Glenn's formula would work with the exception of TAKE.
This proposal uses older functions and adds columns to the Data 1 and Data 2 sheets.
1. The formula in column D of both sheets is similar to: =MIN(MINIFS(A$2:A$6,B$2:B$6,B2),IF(COUNTIFS('Data 2'!B$2:B$4,B2),MINIFS('Data 2'!A$2:A$4,'Data 2'!B$2:B$4,B2),99^99))=A2
2. The formula in column E of both sheets is similar to: =IF(D2=FALSE,0,COUNTIFS(D$2:D2,TRUE))
3. The formula on the Result sheet is: =IFERROR(IFERROR(INDEX('Data 1'!B$2:B$6,MATCH(ROWS(A$2:A2),'Data 1'!$E$2:$E$6,0)),INDEX('Data 2'!B$2:B$4,MATCH(ROWS(A$2:A2),'Data 2'!$E$2:$E$4,0))),"")
Let us know if you have any questions.

Selamat malam slotyuk,

Here is a solution using the data you specified in your opening enquiry, as arranged in the sample file provided by @JeteMc (which has been converted to Google Sheets file).

You can return the first row for each distinct name in column B with this formula:

Please Login or Register  to view this content.