How to check if in a range at least on cell of each contains a letter

[JohnBi]

Hello to everybody,
in the following range C11: H133 I have to insert a mandatory letter "X" .
Out of 6 cells only one must contains an "X": can ben C12, or D12 --> H12
Is there a way to check, except row 104:
- if each row is not empty and only a cell has a letter "X" in the raw C11-->H11; C12--> H12 up to row 133;
- return the cell row address if a row is empty or there more than a cell with "X"
- save the file in ods file format with the name of the file same as value of C1


Thanks for any suggestions.
Regards
John

 

[Marc L]

Hello, you can start with an easy CountIf formula for example combinated with an If condition to return the ROW index ...​

​

 

[JohnBi]

Hello, you can start with an easy CountIf formula for example combinated with an If condition to return the ROW index ...​

​

Thank you Marc for your suggestions, however I haven't been able to find out the right formula as per your input.
I ended up with
=AND(countIf($C17:$H17;"X")<>1;CountIf($C17:$H17;"<>"&"X")>0).

Regards
John

 

[Marc L]

Thread moved to the appropriate forum section ...​

​