Try using Conditional Formatting. Sunny
Give this a try. The assumption is that the staff retires upon reaching 60/55 years old i.e. if today is his/her 60/55 birthday, it will be his/her...
You will need a custom formula in the Data Validation. Refer file attached.
Hi John You can try using a VLOOKUP. Refer attachment. I noticed that the YEAR BORN are not "real" numbers (left-aligned) so I did the same to t...
Hi Dave There can be many ways to create what you wanted. See my attachment for one example. Hope this helps. Sunny
Hi mey Try comparing the difference in time (B1) with the headway (0:03:30) stored in a cell (e.g. C7 in my example attached). Hope this helps. ...
Hi Hava You can give this a try. You will need to modify your headers to actual dates (all end-of-month dates) for this to work. You may need to...
Hi Frans The macro uses a Worksheet_Change event i.e. whenever there is any change on the worksheet (where the macro is located), it will auto trig...
Hi Paul Maybe you could add a helper column to get the Quarters and then Pivot the result. See if this helps. Sunny
Hi Dave Without looking at your calculators it is a bit difficult to guess what you need. Depending on the complexity, you may not need any VBA (an...
To further add to my reply, the Refresh method assume that your data is an Excel Table. If your data is not an Excel Table and new records are adde...
Hi Frans As you know, PT uses a cache (an exact copy of the source data) and you need to manually "update" this cache whenever there are any change...
Hi Khalil I had previously answered your first question before. Refer to the link below. Sunny
You could try either a) ="Year average: " & ROUND(A4,2) b)="Year average: " & TEXT(A4,"#.00") Sunny
Hi Blanka Maybe you can try changing the text Pre-1937 to 1936 and before. Sunny