• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

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

JohnBi

New Member
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

81060
Thanks for any suggestions.
Regards
John
 

Marc L

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

JohnBi

New Member
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
 
Top