Specific data in a range

[Amit Punia]

In the attached file, there are 2 columns - Column A and Column O. In between there is data.

Want a formula in column O which tell that all the cells in between are having data mentioned in column A. If the in between cells are having data which is in column A, it should show "Correct", even if any cell is blank(still the same output - "correct"). If the data of column A is not available in any of the cell, then it should say "Incorrect".

Example - In column A2, data is "1248", In column O2 I need a formula which gives the output "Correct" if all the other cells starting from B2 till N2 is having this specific number i.e. 1248. Even if any of the cell from B2 to N2 is blank, it should show "Correct" as output.
But if it's not available in any cell which is non blank, then it should show "Incorrect".

 

[shrivallabha]

In cell O2 put following formula and copy down,
=IF(SUMPRODUCT(--ISNUMBER(SEARCH(A2,B2:N2)))=COUNTA(B2:N2),"Correct","Incorrect")

 

[Amit Punia]

Thanks Shri, It's working absolutely fine. Thanks a lot.