Excel-related articles.
Press Shift + Ctrl + A after a function to display all its arguments. Then put a leading single quote to signify text. I often find this useful if I need to retrieve the arguments of a function I’m explaining….
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…
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
