E Ellasheba Member Jul 29, 2019 #1 I want to look across a row of cells and if any one of them has some data in to cell it returns a yes or no return .. . I am using counting to count how many cells have something in, but I want another return that doesn’t count ... many thanks
I want to look across a row of cells and if any one of them has some data in to cell it returns a yes or no return .. . I am using counting to count how many cells have something in, but I want another return that doesn’t count ... many thanks
AliGW Well-Known Member Jul 29, 2019 #2 Something like this: =IF(COUNTIF(range,criterion)>0,"Yes","No")
E Ellasheba Member Jul 30, 2019 #4 Hello I tried it but it only brings back no even when there is something in one of the cells ? What should I be putting in the criterion part? =IF(COUNTIF(A1:T1,criterion)>0,”Yes”,”No”)
Hello I tried it but it only brings back no even when there is something in one of the cells ? What should I be putting in the criterion part? =IF(COUNTIF(A1:T1,criterion)>0,”Yes”,”No”)
Hui Excel Ninja Staff member Jul 30, 2019 #5 =IF(COUNTIF(A1:T1,"<>")>0,"Yes","No") That is a <> with " around them, no spaces
