CountIF with distinct values
I am trying to make a countif — time between 5am and 2pm– then return “afternoon”, for that part i got it right but I just realized that I was counting every row and some of them are duplicates.
I am trying to make a countif — time between 5am and 2pm– then return “afternoon”, for that part i got it right but I just realized that I was counting every row and some of them are duplicates.