Multi Conditional Min Formula Help

[NYMIEZER]

I am using the current MAX formula to extract the latest date from
column H, based on conditions in column A and column C.

How can I re-write this formula to extract the earliest date from column H,
as replacing MAX with MIN does not work.

When I replace with MIN, the result = 1/0/1900

Any help would be great.

<TABLE style="WIDTH: 308pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=411 border=0 x:str><COLGROUP><COL style="WIDTH: 308pt; mso-width-source: userset; mso-width-alt: 15030" width=411><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 308pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=411 height=17>MAX(INDEX((A3:A9000=A3)*(C3:C9000=C3)*H3:H9000,0))</TD></TR></TBODY></TABLE>

 

[Domenic]

Try...

=MIN(IF(A3:A9000=A3,IF(C3:C9000=C3,H3:H9000)))

...confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

 

[NYMIEZER]

This did not work, the formula set each cell equal to itself rather than populate the min.

My data is as follows

Car Jan 5th
Car Feb 5th
Car Mar 5th
TOY Apr 5th
TOY May 5th


I am trying to display Jan 5th as the MIN
Car and Apr 5th for the MIN of Toy, but i
need the mins populated next to each Car
and Toy respectively.

 

[Domenic]

A few questions...

1) How many columns do you have?

2) Is the month in one column and the day in another?

3) Is the data sorted first by Car/Toy, in ascending order, and then by date, in ascending order? If not, can it be?

 

[NYMIEZER]

I have 3 columns.

Column A has things like Car, Toy condition 1.
Column C has colors like black, white, condition 2.
Column H has the dates in this formation dd/mm/yy

The data is sorted or can be if needed in any fashion.

 

[Domenic]

I just re-read your other post and if I understand you correctly, you'd like to see the following, correct?

Car Jan 5th Jan 5th
Car Feb 5th Jan 5th
Car Mar 5th Jan 5th
TOY Apr 5th Apr 5th
TOY May 5th Apr 5th

 

[NYMIEZER]

That is correct.

 

[Domenic]

Assuming that A3:A9000 contains the item (Car, Toy, etc.), C3:C9000 contains the colour, H3:H9000 contains the date, and that the data is sorted first by Column A, in ascending order, then by Column C, in ascending order, and then by Column H, in ascending order, try...

I3, copied down:

=VLOOKUP(C3,INDEX($C$3:$C$9000,MATCH(A3,$A$3:$A$9000,0)):INDEX($H$3:$H$9000,MATCH(A3,$A$3:$A$9000,1)),6,0)

Hope this helps!

 

[NYMIEZER]

This worked perfectly.

Thank you for all your help on this.

 

[Domenic]

You're very welcome!