Count only duplicate values one time in a date range - Pls help

Dear all, Pls help me.
I am using below formula in the attached excel sheet to count only duplicate values single time. I need to extend the formula to include date range. Pls go through attached excel file and help me to find the formula for including date range ( i want to count repeated values only between 5th and 6th march in attached excel sheet)

=SUM(IF(FREQUENCY(IF(C1:C10000<>"",MATCH(C1:C10000,OPD!C1:C10000,0)),ROW(C1:C10000)-ROW(C1)+1)>1,1))

Any help pls?

The quickest solution is just to find the first cell for March 5th (C95) and the last cell for March 6th (C261) and change every C1 in your formula to C95 and every C10000 to C261. You're left with:

=SUM(IF(FREQUENCY(IF(OPD!C95:C261<>"",MATCH(OPD!C95:C261,OPD!C95:C261,0)),ROW(OPD!C95:C261)-ROW(OPD!C95)+1)>1,1))

Use Ctrl + Shift + Enter.

If you want a more permanent solution with variable start/end dates... how do you want that to look?

If you enter the start date in D2 and the end date in E2, putting the ugly formula below in E3 (entered with ctrl + shift + enter) will give you the results you want between the two dates (inclusive).

Formula:

Please Login or Register  to view this content.

There might be a simpler way (I hope so), but modifying your original formula to look like this worked reliably.