Search results

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

Hi Hui, attached the file and thank for your interest. I hope you are able to help me. Regards John

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

Thank you for your help and both samples. A lot of thing to learn at my side. A great help to my daily (boring) routine. Kind Regards JohnBi

Thank you very much for the great help. It is perfect. Once again thanks. Regards gbianchi

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

Ok. Apoligies for the inconvenience. Regards JohnBi

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