Wednesday’s announcement of 14 new Excel functions was welcoming news. However, despite switching to the BETA Channel yesterday, I am not one of the lucky ones who have access to the new batch yet. Nevertheless, I was particularly drawn to…
Calendars are useful for scheduling events, constructing to-do lists, and managing projects. Many applications exist for mobile and desktop, such as Outlook, iCloud Calendar, and Google Calendar. Whilst these are feature-packed and great for day-to-day use, nothing beats an Excel…
If you have a set of dates, you might also want their week numbers. These can be returned using the WEEKNUM or ISOWEEKNUM functions. What is the difference though? Function Syntaxes • serial_number — a valid date in serial number…
You might refer to the characters in a password or the digits on a padlock as a combination. Strictly speaking, this isn’t true though, as the position of each letter, number or symbol is significant, so it’s actually a permutation. Excel…
Introducing RANDUNIQUE — for when you want to return an array of unique random numbers. Three weeks ago, I showed a couple of methods of how to do this with formulas. () After a few refinements, those formulas have now…
Previously, I showed you how to use the SCAN function to calculate the running total with a single formula (). However, given only Office Insiders can access it right now, it’s probably not wise to use it in shared workbooks….
End of content
End of content
