Need some help on this cause I’m getting an issue
I’ve this three columns (Time, R1 and R2) and I’m trying to count the mismatches between R1 and R2 but for each month (on the time column)
I already used a formula but I’m having an issue to add 1.
=iferror(if(EOMONTH($A64,0)=$A64,SUMPRODUCT(month(Database!$C$2:$C) = month($A64),--(Database!G$2:G <> Database!H$2:H)),""),"Error")
This part “month(Database!$C$4:$C) = month($A5)” is where I compare the information of the months, ( but I’m having an issue cause cause “month(Database!$C$4:$C)” only retrieves 4 that is the month of april)
This part “(Database!G$4:G <> Database!H$4:H)” is where I compare the columns R1 and R2
The part “EOMONTH($A5,0)=$A5” is where I take the month to based myself
Time R1 R2 2020-04-30 BA BU 2020-04-30 BU BA 2020-04-29 BA BU 2020-04-29 BU BA 2020-04-28 BA BU 2020-04-28 AA BA 2020-04-25 AA BA 2020-04-22 BU BA 2020-04-19 AA BU 2020-04-19 AA BA 2020-03-27 BA AA 2020-03-27 BA AA 2020-03-26 BU AA 2020-03-18 BA AA 2020-03-18 AA BU