Very interesting, Frans . I will definitely keep this in my toolkit for future use. Thanks for sharing. Sunny
Hi David Can you settle for a formula instead of an auto-fill? A1: 03/01/2017 A2: 04/01/2017 A3: =A1+7 Copy A3 down as far as you want....
Hi npr See if this is useful. Sunny
Hi Paul Can you post an example file and the expected result? It will be easier to understand your needs. Sunny
Hi Maurizio Try this. Please recreate a new text file. Sunny
There are different formulas that will give the same result, depending on your needs and how your data was set up. Most important is that the formu...
Hi npr Welcome to the board. You should attach a sample file (not images) so that those who want to help you do not have to recreate the file th...
Hi Give this a try =IF(ISERROR(FIND("-",SUBSTITUTE(A1," - ",""))),"OK","ERROR") Sunny
Attached is the formula that I was working on but it is rather long when combined.
Hi Mynda When I looked at rathanak's question, I assumed that numbers and alphabets are to be excluded. =SUMPRODUCT(--NOT(ISNUMBER(A1:A9))) will...
Sorry Maurizio, spelled your name wrongly.
Hi Maruzio From what I can understand what you are saying using Google translate :), you want a form that will auto resize to fit the buttons, text...
Hi David Try this. You will need to filter the Master Record worksheet. The macro CreateWSFitered will create the worksheets for the filtered re...
Hi rathanak Give this a try. Sunny
Hi rathanak Just unprotect the input cell C2 before you protect the worksheet. Sunny