Hi Tony My original codes actually gives your expected result as in column J as per your attachment. From your latest post to canapone I noticed...
Hi Tony Maybe if you could post samples of your expected results in a worksheet, it will help clear the confusion. Frankly, I am still confused ...
Hi Roy Just like what Jerry said, you will have to delete column A and create a helper column You can try this formula since your dates are in U...
This will also work if there is a combination of weeks e.g. 2,3,4,1-5 etc in the same cell (here it is assumed that the week range is 5 days. Can be m...
Hi all If the the week range is fixed e.g. 5-day range (you can check to see if any dash exist to determine if it is a range), then count the numbe...
Hi Tigger Give this function a try. Function skCountWeeks(cell As Range) Dim WeeksArray() As String Dim x As Integer Dim i As Integer ...
Hi Olivier You could try pivoting your data and using slicers for Country, City etc as your dependent validation. Apparently you can hide items ...