You could consider having 2 helper columns, one for M and another for W. This will avoid having to use MAXIFS when using "older" version of Excel.
This question looks similar to the question you asked here before: Have you tried the solution that was given? Sunny
Possibly another try is =IF(ISNUMBER(SEARCH("week",C2)),7,30)*LEFT(C2,2) As mentioned above by Purfleet, the no. of days in a month may be betwe...
Hi Alan If i don't know the answer I will google to see if such solutions already exist (no need to recreate the wheel). 99% of the time the sol...
You can consider creating a Pivot Table for each country in different sheets and then create the chart from them.
Hi Miguel You should us a comma (,)instead of a semi colon (;) Wrong =VLOOKUP(C3,CHOOSE({1;2},$C$6:$C$18,$B$6:$B$18),2,FALSE) Correct =...
Hi Alan The reason why your formula is not giving the result is because they are referring to the actual cells (even when they are hidden.filtered)...
Hi Rindy There is no attachment.
Hi Chiew Yen If you need to have the formula expand downwards when data is added, then I suggest you convert your range into an Excel Table. In ...
Hi deji You should attach your workbook as it will be clearer. We are unable to see the cell address from your attachment. Your dates are conver...
Hi Paul Can't you just hide the columns AN:AU without data? You can then display each column when you have new data. Hidden columns will not ...
Hi Katie Please refer attached. You will need to select the range of cells containing the list (eg c6:c10) before running the macro It will c...
Hi Chiew Yen Try this Sub CombineSheet1() Dim i As Integer Dim Lr As Long Dim wksDst As Worksheet Set wksDst = Worksheets("Summary") For i = ...
Try this Good luck Sunny
Hi Shaik What error did you encounter? The code worked for me. Maybe you could attach your file for us to have a look. Sunny