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….
Excel functions like XLOOKUP and MATCH lack the ability to look up values in multiple rows or columns. However, this problem is circumvented with the help of MMULT, which returns the matrix product of two arrays. Before diving into the…
End of content
End of content
