Hi Meyanui It would help if you can provide us your expected result. Without knowing that, I can only make a guess. Please refer to the attachme...
Hi Nadine You can try looking here It contains lots of examples on MS Outlook. Cheers Sunny
Hi autrrk The challenge is determining "how many months are remaining in the year". Your Start and End Dates are incomplete months and this make...
Hi See if this is what you are looking for. Sunny
Hi mel See if this is what you are looking for. I have included 2 conditional formatting examples. Sunny
Hi natasja I don't think you can add a trendline to a sparkline unless you fake it. Even if you managed to do that, the sparkline will be very diff...
I too encountered the same problem like Steve (Excel 2010 hangs). It only happens if you cut and paste the chart with the buttons together. It will...
Hi Frans Thanks for sharing the link. Very interesting indeed. Just to share some thought on this subject. Most of the time I have to face situa...
Hi Amy Can you let us know what is not working? What formula did you use? An example will be useful. Sunny
Hi Gary One way is to create a column chart and hide all the lines. Draw a circle and move it below the column and group them together to create a ...
Hi shafiz (A) To be able to filter, you will need to fit the picture exactly into a single cell and then set its property to Move and size with cel...
Hi Hooi Thin The best I can think of is using formulas to read your filters and extract using SUMIFS. Sorry, I can't think of another way to sol...
Hi Calla One method is by using the Data-Consolidate option. 1) Add a new worksheet and select cell A1. 2) From the new worksheet select Data...
Hi Hooi Thin Can you consider using SUMIFS with multiple criteria instead of Pivot Tables? What are the fields you are filtering? My attachme...