Hi Frans Always glad to help whenever I can. All the best at the competition for the children. Sunny
See my example
Hi Peter You could try sorting your Pivot Table Row Labels by moving (dragging) April, May and June to the top. Hope this helps. Sunny
Hi Frans Managed to GOOGLE up a solution for you. See if this is what you are looking for. Sunny
One slight improvement is to set the % data series to be 100% overlap to keep the column alignment centred.
Hi David See if this helps. Those in red are add/changed by me. I have to copy the header from the "Header" worksheet as the header from your ac...
Hi Frans Have you tried selecting all the cells first before you enter the formulas and pressing C-S-E? Sunny
Hi lea See the attachment. One uses a helper column and the other uses formulas in the conditional formatting itself. Both will detect duplic...
Hi Paul It will be better if you can attach an example. Sunny
Hi Canapone The formula doesn't extract text if the range contains a mixture of numbers and text. It only extract the numbers. I have slightly c...
Hi Maurizio Very interesting use of Listbox to create a calendar. "Stealing" your idea, I have created a listbox calendar of my own, although it is...
Hi Rachael Addendum In the worksheet, cell I3 should read: Select the range I2:N2 before entering the formula and then pressing CTRL-SHIFT-EN...
Hi Rachael I'm not an expert on array formulas but somehow I got it working (I hope). Select a range before entering the modified formula and th...
Hi Hava Try not to manually adjust the alignment of the column containing data. If Excel recognize a value as a number, it will automatically be ri...
Hi Maurizio To answer your questions: 1) how can I bring back the color in its natural state, when I press the Reset button or (Clear All) so th...