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
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...
Hallo to everybody
I have an Excel file of 1 page that I use to print a selfadhesive A5 label size to
stich on pallet.
The content of the label is the same, except that I need to print the
label with a progressive number on a uniqye Pdf file:
1 of 135
2 of 135
3 of 135
135 of 135
Is there a...
Hallo to everybody,
did you guys get a chance to look to my question?
Do you think there is an Excel formula that can me help?
Thanks in advance.
Regards
Giovanni
Hi Narayan,
thanks for your reply.
Let me try to explain with a picture. The first 2 rows are with the same direction, the third row is rotate to build a more stable pallet.
Hopefully there is chance to do something with Excel.
Thanks and Regards
Giovanni
Based on the Amazing tutorial "Modeling tiles in a room using Excel Conditional Formatting" I recent found on your website, I am trying to adapt the tutorial to fit bundle on a pallet.
Bundle Dim 1 = 22 cm
Bundle Dim 2 = 30 cm
Pallet/room Dim 1 = 80cm
Pallet/room Dim 2 = 120cm
With...
Hello to everybody,
as I am in charge to develop a little app with Excel in the I have been "forced" to learn Excel even if I not anymore young.
Browsing the net to find tips to a question that arise to me I found this Community with a really high level of Excel's skill.
I am sure I'll...
Hallo to everybody,
based on this sample
https://www.dropbox.com/s/7o0rwfws2c2m6v3/Print_Using_ListBox2.xlsm
how is possibile to print the selected sheets as single job?
Thanks for your help and as I am new to this forum, congratulation for the hi level of knowledge of Excel.
Regards
JohbBi
Hallo,
I found this perfect samples.
Am I allowed to asked if there a possibility to print the selected worksheet as a single job with: page 1/5, 2/5, 3/5 and so on if I select a multi sheets to print.
Thanks and Regards
JohnBi