Just trying to make my life easier, Is there a formula I could do that would take every other cell in a range?
Right now I am doing a formula like: If(CountIf(A2,A4,A6,A8)=4,"T","F") but I have a lot more cells than that and a lot of ranges. Is there a way to do something like A2:A8 offset by 1 to get the same result?
Thanks ahead of time. I tried search first to no avail, so if anyone has link, that would be great also. Thanks!