Earliest Date by multiple criteria

**jayblaze21** · 04-01-2016, 05:18 PM

HI All,

Newbie here looking for some help. Basically what i'm looking for is for excel function that will put in column C the earliest date within a calendar year using a date range in column B with reference to multiple repeating values in column A?? If that makes any sense. I provided a sample below. If it takes mutiple functions in columns D & E to get the desired result i'm open to that as well. Hopefull this can be done without VBA. Thanks guys.

Blue 1/1/2016 1/1/2016
Blue 10/1/2016 1/1/2016
Blue 8/1/2017 6/1/2017
Blue 6/1/2017 6/1/2017
Green 3/1/2017 3/1/2017
Green 6/1/2017 3/1/2017
Red 5/1/2016 4/1/2016
Red 4/1/2016 4/1/2016
Red 3/1/2017 2/1/2017
Red 2/1/2017 2/1/2017

**Tony Valko** · 04-01-2016, 05:55 PM

Try this...

Data Range

	A	B	C
2	Blue	1/1/2016	1/1/2016
3	Blue	10/1/2016	1/1/2016
4	Blue	8/1/2017	6/1/2017
5	Blue	6/1/2017	6/1/2017
6	Green	3/1/2017	3/1/2017
7	Green	6/1/2017	3/1/2017
8	Red	5/1/2016	4/1/2016
9	Red	4/1/2016	4/1/2016
10	Red	3/1/2017	2/1/2017
11	Red	2/1/2017	2/1/2017

This array formula** entered in C2:

=MIN(IF((A$2:A$11=A2)*(YEAR(B$2:B$11)=YEAR(B2)),B$2:B$11))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Format as Date

Copy down as needed

**jayblaze21** · 04-01-2016, 06:21 PM

Awesome! Thank you so much. Much Appreciated it.

**Tony Valko** · 04-01-2016, 06:53 PM

You're welcome. Thanks for the feedback!

Earliest Date by multiple criteria

LinkBack

Thread Tools

Rate This Thread

Display

Earliest Date by multiple criteria

Re: Earliest Date by multiple criteria

Re: Earliest Date by multiple criteria

Re: Earliest Date by multiple criteria

Thread Information

Users Browsing this Thread

Similar Threads

How to find the earliest or latest date with criteria selection?

[SOLVED] Find earliest date in table with multiple criteria

[SOLVED] Count Unique Values Based on Earliest Date Criteria

[SOLVED] Index match multiple criteria based on earliest date

Need to return the earliest date respective to one criteria

Find earliest date based on specific criteria in other columns

Find earliest date based on certain criteria

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions