Help with formula
A4=IF(COUNTIF(A1:AS1,1)=2,1,"")
The above formula searches a range of cells looking for the number 1
occurring 2 times and either returning 1 or leaving the cell blank.
How could the formula be changed to only do the search if cell A1 was equal
to the number 1?
|