First I like to thank the community for attending MDIS 2017. It has been a great sucess and it was amazing to see MDIS sold out again (and double the amount of attendees from last time). The last 3 days have been amazing. We, the Excel team, are so greatf
Hi, I have a Table A which requires some formulation or VBA to display Table B on another sheet with a bar graph generated. Table B requires only the selected months and will only display when there is a value of 1 and above. If all selected months are in
I need to crerate a formula that will add $100 everytime an account increases $10,000. So, basically, if I have an account with $5,000, the fee is $100. As soon as the account grows to $10,000, the fee increases by $100 to total $200, then when the accoun
Thank you! This worked PERFECTLY!!! I am also in need of help with another formula. Basically I have a number that increases every month based on using 50% of another increasing number - but I need the final number to stop once it meets a certain lev
you can create a SharePoint list from data in an Excel workbook, but after the list has been created, there is no further connection between the workbook and the list. It is a one-time thing only. So, when you add new data to that Excel workbo
In Excel 2016 Windows or Mac: has anyone been able to get the FORECAST.ETS.SEASONALITY function to return anything other than zero? I've tried this function on several sets of data, some with very obvious seasons, but this function doesn't recognize them.
Yes, for the business with forecasting based on monthly results seasonality will always be 12 (or zero). However, that could be more useful cases like time peaks during the day for call center; availability of candidates on labour market during the y