Spreadsheet: 90770d1290521630-how-to-count-unique-entries-that-meet-two-criteria-example-1
Sheet: Sheet1

Today | 2010-11-23 00:00:00 |  |  |  | From: | 14 |  | Count Today |  | 18
Future Date |  |  |  |  | To: | 18 |  | Future Date Count |  | 18
ID Number | DOB | Age Today | Age at Date 2 | Count 1 | Count 2
339489 |  | 4.482191780821918 | 4.832876712328767 | 0 | 0
355606 |  | 11.02191780821918 | 11.37260273972603 | 0 | 0
8178 |  | 11.3013698630137 | 11.65205479452055 | 0 | 0
10494 |  | 12.33424657534247 | 12.68493150684932 | 0 | 0
7048 |  | 12.15890410958904 | 12.50958904109589 | 0 | 0
372303 |  | 5.975342465753425 | 6.326027397260274 | 0 | 0
349351 |  | 5.43013698630137 | 5.780821917808219 | 0 | 0
345623 |  | 4.594520547945206 | 4.945205479452055 | 0 | 0
360904 |  | 5.405479452054794 | 5.756164383561644 | 0 | 0
326295 |  | 8.035616438356165 | 8.386301369863014 | 0 | 0
12164 |  | 15 | 15.35068493150685 | 1 | 1
360197 |  | 4.008219178082192 | 4.358904109589041 | 0 | 0
323844 |  | 11.77808219178082 | 12.12876712328767 | 0 | 0
323844 |  | 11.77808219178082 | 12.12876712328767 | 0 | 0
3463 |  | 15.48219178082192 | 15.83287671232877 | 1 | 1
348706 |  | 12.71506849315069 | 13.06575342465753 | 0 | 0
364840 |  | 5.306849315068493 | 5.657534246575342 | 0 | 0
10024 |  | 7.96986301369863 | 8.32054794520548 | 0 | 0
6527 |  | 11.25479452054794 | 11.60547945205479 | 0 | 0
318754 |  | 14.2986301369863 | 14.64931506849315 | 1 | 1
358571 |  | 2.136986301369863 | 2.487671232876712 | 0 | 0
332793 |  | 7.904109589041096 | 8.254794520547945 | 0 | 0
351074 |  | 6.673972602739726 | 7.024657534246575 | 0 | 0
11867 |  | 8.391780821917807 | 8.742465753424657 | 0 | 0
347931 |  | 10.73424657534247 | 11.08493150684932 | 0 | 0
347931 |  | 10.73424657534247 | 11.08493150684932 | 0 | 0
5568 |  | 12.52054794520548 | 12.87123287671233 | 0 | 0
366687 |  | 5.695890410958904 | 6.046575342465753 | 0 | 0
367223 |  | 2.367123287671233 | 2.717808219178082 | 0 | 0
367225 |  | 2.367123287671233 | 2.717808219178082 | 0 | 0
354466 |  | 5.347945205479452 | 5.698630136986301 | 0 | 0
363221 |  | 16.86849315068493 | 17.21917808219178 | 1 | 1
330129 |  | 7.531506849315068 | 7.882191780821918 | 0 | 0
330129 |  | 7.531506849315068 | 7.882191780821918 | 0 | 0
336408 |  | 12.56712328767123 | 12.91780821917808 | 0 | 0
362090 |  | 4.312328767123287 | 4.663013698630137 | 0 | 0
11994 |  | 0.9945205479452055 | 1.345205479452055 | 0 | 0
5232 |  | 13.53424657534247 | 13.88493150684931 | 0 | 0
331616 |  | 12.83561643835616 | 13.18630136986301 | 0 | 0
363619 |  | 9.052054794520547 | 9.402739726027397 | 0 | 0
339535 |  | 6.553424657534246 | 6.904109589041096 | 0 | 0
5062 |  | 12.21917808219178 | 12.56986301369863 | 0 | 0
10653 |  | 9.624657534246575 | 9.975342465753425 | 0 | 0
AIMING HIGH BUDGET
7048 |  | 12.15890410958904 | 12.50958904109589 | 0 | 0
11603 |  | 10.48767123287671 | 10.83835616438356 | 0 | 0
11603 |  | 10.48767123287671 | 10.83835616438356 | 0 | 0
11602 |  | 13.23287671232877 | 13.58356164383562 | 0 | 0
11602 |  | 13.23287671232877 | 13.58356164383562 | 0 | 0
11602 |  | 13.23287671232877 | 13.58356164383562 | 0 | 0
358235 |  | 14.68219178082192 | 15.03287671232877 | 1 | 1
2550 |  | 16.55068493150685 | 16.9013698630137 | 1 | 1
9746 |  | 10.94794520547945 | 11.2986301369863 | 0 | 0
7355 |  | 10.37808219178082 | 10.72876712328767 | 0 | 0
323844 |  | 11.77808219178082 | 12.12876712328767 | 0 | 0
9836 |  | 11.67397260273973 | 12.02465753424658 | 0 | 0
6495 |  | 11.64657534246575 | 11.9972602739726 | 0 | 0
2969 |  | 13.58904109589041 | 13.93972602739726 | 0 | 0
336606 |  | 5.6 | 5.950684931506849 | 0 | 0
3749 |  | 17.39178082191781 | 17.74246575342466 | 1 | 1
11989 |  | 10.12328767123288 | 10.47397260273973 | 0 | 0
6492 |  | 17.0986301369863 | 17.44931506849315 | 1 | 1
5539 |  | 14.55342465753425 | 14.9041095890411 | 1 | 1
6527 |  | 11.25479452054794 | 11.60547945205479 | 0 | 0
8091 |  | 14.43287671232877 | 14.78356164383562 | 1 | 1
11453 |  | 12.23287671232877 | 12.58356164383562 | 0 | 0
345808 |  | 3.479452054794521 | 3.83013698630137 | 0 | 0
333766 |  | 4.46027397260274 | 4.810958904109589 | 0 | 0
8583 |  | 7.6 | 7.950684931506849 | 0 | 0
3769 |  | 17.41369863013699 | 17.76438356164384 | 1 | 1
354466 |  | 5.347945205479452 | 5.698630136986301 | 0 | 0
6001 |  | 13.1041095890411 | 13.45479452054795 | 0 | 0
7705 |  | 10.77260273972603 | 11.12328767123288 | 0 | 0
338729 |  | 7.317808219178082 | 7.668493150684932 | 0 | 0
9918 |  | 13.1041095890411 | 13.45479452054795 | 0 | 0
337609 |  | 11.34794520547945 | 11.6986301369863 | 0 | 0
342790 |  | 18.13424657534247 | 18.48493150684931 | 0 | 0
314960 |  | 6.608219178082192 | 6.958904109589041 | 0 | 0
8918 |  | 7.723287671232876 | 8.073972602739726 | 0 | 0
3375 |  | 15.17534246575342 | 15.52602739726027 | 1 | 1
5232 |  | 13.53424657534247 | 13.88493150684931 | 0 | 0
8445 |  | 17.06575342465753 | 17.41643835616438 | 1 | 1
10074 |  | 16.46301369863014 | 16.81369863013699 | 1 | 1
3981 |  | 17.1013698630137 | 17.45205479452055 | 1 | 1
9816 |  | 6.895890410958904 | 7.246575342465754 | 0 | 0
7128 |  | 9.805479452054794 | 10.15616438356164 | 0 | 0
3535 |  | 15.24931506849315 | 15.6 | 1 | 1
3622 |  | 17.4027397260274 | 17.75342465753425 | 1 | 1
368599 |  | 8.35068493150685 | 8.7013698630137 | 0 | 0
301503 |  | 18.35068493150685 | 18.7013698630137 | 0 | 0
5695 |  | 15.6986301369863 | 16.04931506849315 | 1 | 1
 |  |  |  | 18 | 18