I have a issue with this formula and i was looking everywhere, but i was not able to figure it out. What i want to do with this formula is after the code is changed i need to know, how many unique models was used for this changed code
Formula is working only without F column condition, that means, i'm not able to say how many unique models i have for one code.
E column - CODE
015632360000
003550080000
004510600000
003506990680
003506990680
003506990680
F column- MODEL
CUA32
CUC31
CUN06
CUF20
CUF20
CUF19
G column- Date
17.4.2019 0:00
17.4.2019 0:00
17.4.2019 0:00
17.4.2019 0:00
17.4.2019 0:00
17.4.2019 0:00
I column - Date of change
11.4.2019
18.1.2019
18.1.2019
18.1.2019
18.1.2019
18.1.2019
J column-changed CODE
003506990680
003572610000
003582900000
015404890000
003411090000
000000156204
Solution should be for changed CODE 003506990680 2, because for this code were used two models CUF20 and CUF19
=SUMPRODUCT(1/COUNTIFS($E$2:$E$16502;J2;$G$2:$G$16502;"<="&I2+30; $G$2:$G$16502; ">"&I2;$F$2:$F$16502;$F$2:$F$16502))
Do you have any suggestions ? Thank you very much !
Bookmarks