• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need to help to get earliest date from range

mu4you

New Member
Dear Sir,

Kindly need help,

I have multiple events in columns B and I am looking for the output in new sheet which event was 1st event. Example, the Row # 17 should show first. in this way I have around 4000 records.

Thanking you in advance, I prefer the formula without macro.
 

Attachments

  • Copy of SAMPLE.xlsx
    10.4 KB · Views: 8
1. Your dates are shown as text. You need to convert them to numerical Date values. Then apply the Min function to find the earliest date.
 
Back
Top