Return Max Date

[SuperSquirrel]

I'm using the following formula to look up the number of errors a specific person had, and the first time this person was contacted.

=IF(C13=0,"",SMALL(IF(Table1

=A13,Table1[Action Date]),1))[/COLOR][/B]

my reasoning is if the previous cell is 0, then do nothing, I don't care since they have no entries in my table.

If it's not 0, then I want to know the first time that the person was contacted

now my wonderful code is working, for the FIRST time it hits a non-0, but returning 01/00/00 for the the remaining non-0 values...

 

[SuperSquirrel]

I'm an idiot... should be return MIN date not MAX

I tried a different formula - =IF(C13=0,"",MIN(IF(Table1

=A13,Table1[Action Date]))) but the EXACT same results 

[COLOR=#333333]ID Count MIN_DATE[/COLOR]
[COLOR=#333333]3317	0	[/COLOR]
[COLOR=#333333]3464	3	08/17/17[/COLOR]
[COLOR=#333333]3414	2	01/00/00[/COLOR]

 

[SuperSquirrel]

I'm actually a bigger idiot.

I fixed it

=IF(C6=0,"",MIN(VLOOKUP(A6,Table1,7,FALSE)))

Thank you all for your positive excel thoughts to help me through my Excel crisis lol sometimes you just gotta talk it out.

 

[SuperSquirrel]

nope ... it didn't work after all...

I'm just going to stop posting until someone with a bigger brain than me responds... that doesn't take much apparently *hangs head in excel shame*