Remove duplicate values from countifs formula

[lwthomp80]

I have a very involved formula that counts data based on about 5 different criteria; however, the criteria is not defined by the name column. This is where the problem comes in. When I get the count of data that fulfills the criteria, there are a few anomaly items where the same person, in the "Name" column, meets the criteria twice, so I am having to go through and do a sort based on the criteria and manually add "-1, -2, etc" to the end of the formulas that contain duplicate names.

Is there a way to identify the duplicate names after the criteria has been met, so that the count will not include names that appear more than once? Below if the formula I have so far....Thanks!

=(COUNTIFS(Type, "Away from Work", LT_Start,">="&DATE(2013,1,1),LT_Start,"<="&DATE(2014,1,31),LT_End,">="&DATE(2014,1,1), LT_End, "<="&DATE(2014,12,31))+COUNTIFS(Type, "Away from Work", LT_Start,">="&DATE(2013,1,1),LT_Start,"<="&DATE(2014,1,31),LT_End, ""))

 

[Aladin Akyurek]

No, the formula does not refer to a "Name" range...this is why I am running into the problems. This selected data is part of a much larger group of data that gets filtered and counted via the formula, and I am at a loss as to how to identify the names and remove them.

1) Are you applying autofilter?

2) Are you expecting a count of 17 for the exhibit you posted?

3) LT_START must be between 1-Jan-13 and 31-Jan-14, right?

4) LT_END must be between 1-Jan-14 and 31-Dec-14 or LT_END empty, right?