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