PDA

View Full Version : Excel Question


ace3g
02-26-2020, 08:38 PM
If I have a condition =COUNTIF($M$2:$R$27,B2)>=1 that turns certain cells green, how can I count those cells in row that are green? Range that turns green is: =$B$2:$G$39 -- First row I want to count is B2:G2.

I think I almost figured it out: =SUM(COUNTIF(B2:G2,$M$2:$R$27)) but I only want it to count the first time a number in B2:G2 matches numbers from M2:R27, no duplicates.
ElNono
02-27-2020, 05:05 AM
https://media2.giphy.com/media/xL7PDV9frcudO/giphy.gif
spurraider21
02-27-2020, 06:41 AM
Did you try turning it off and back on?
baseline bum
02-27-2020, 08:21 AM
Use console instead, but wait for the new XBox.
ace3g
02-27-2020, 08:49 AM
By the way this is a legit post, not from a robot. I was hoping someone with excel knowledge could help.
ace3g
02-27-2020, 10:39 AM
I finally got this resolved, disregard.
SpursforSix
02-27-2020, 10:42 AM
Did you try turning it off and back on?


I finally got this resolved, disregard.

it worked, didn't it
FrostKing
02-27-2020, 07:25 PM
https://images-na.ssl-images-amazon.com/images/I/415j93WXF9L._SX331_BO1,204,203,200_.jpg
koriwhat
02-28-2020, 04:37 PM
https://images-na.ssl-images-amazon.com/images/I/415j93WXF9L._SX331_BO1,204,203,200_.jpg

:lol :tu