Count unique values with two criteria within date range?

[Robban7911]

I have some issues to solve a formula to count unique values in Column A:A from a date (Cell G2/H2) and forward with the two separate criterias (Cell G1/H1) in Column L:L.
The purpose is to know when the setpoint of 30 loads is met, which means that it is time for the operator to change the furnace's filter.

A more detailed description is that I want to see how many unique loads (Column A:A) have been run in each furnace (eg. T2T-XL 1) in Column L:L since the last filter change Cell G2?

Does anyone have a good formula to easily just change the date (cell G2/G3) when changing the furnace filter and then it calculates the number of loads by itself?

Thanks!

 

[awoohaw]

is each row considered one unique load?

 

[Robban7911]

is each row considered one unique load?

No. Like you see in row 1407-1409 the charge-id is the same (23-06 0053 /01). This means that these three rows should be count as 1 load. Also row 1411-1412 (23-07 0008 /01) should count as 1 load. But row 1410 (23-07 0003 /01) and row 1415 (23-08 0007 /01) should count as 1 load each.

 

[Fluff]

Hi & welcome to MrExcel.
How about

=ROWS(UNIQUE(FILTER($A$8:$A$5000,($B$8:$B$5000>=G2)*($L$8:$L$5000=G1))))

 

[Robban7911]

Hi & welcome to MrExcel.
How about

=ROWS(UNIQUE(FILTER($A$8:$A$5000,($B$8:$B$5000>=G2)*($L$8:$L$5000=G1))))

Thanks a lot for the help

 

[Fluff]

Glad we could help & thanks for the feedback.