Forum

Hi Eric, You haven't given me an example of the desired result, so in the attached file I've just unpivoted the data and put it in the sheet called...

Hi Eric, You don't need to demote the headers first. Just unpivotand then the dates will be in a column of their own as they should be i.e. in a ta...

Hi Brent, You can change the formula in cell U2 to this and copy down: =IF(AND(MONTH(T2)>1,MONTH(T2)<9),"Outside Season",IF(MONTH(T2)<9...

Hi Kanwal, If you click on the Applied Steps in the file I attached you can see each step I took. If you need further guidance then I recommend you...

Hi Phyo, Welcome to our forum! Our courses don't have subtitles, sorry. Mynda

Hi Kanwal, Welcome to our forum! You can use the Group By tool to find the max and min dates, then merge those dates back to the original data. See...

Hi Brent, Thanks for sharing your file. It's not clear what to do with dates that fall from February to August, so in the attached file I've treate...

Hi Greg, Looks like that resource has been removed. I couldn't find an alternate link to it, sorry. Mynda

Wow, congratulations, Kristoffer! It's great to know my tutorials were helpful 🙂

Hi Bandi, If you want to ignore filtered cells you need to use the SUBTOTAL function. See column I of the file attached. Mynda

Hi Brent, Please try uploading your file again and be sure to click 'start upload' after selecting your file. Thanks, Mynda

Nice tip, Duncan! Although in this case it won't automatically update based on the values and the colour scales Marsil wants.

Hi Ewan, If your date format is different to that of the source data then you should be using 'Change Type Using Locale'. To do this, remove the fi...

Hi Lakshmipathi, Thanks for your kind words about my training. I'll keep your request in mind 😉 Mynda

Hi Vicky, This is a limitation by Yahoo. If you have Microsoft 365/Office 365 you can use the STOCKHISTORY function for this. Mynda