Text-to-Columns, dynamically using formulas
I often use the technique of concatenating columns into 1 cell with separators. Something like the CSV, 1 line that has all values for a single row (all columns for …
Category: Logical
IFS (and IFNA) to avoid nested IFs
I tend to see more and more the usage of nested IF functions recently Now, do not get me wrong, IF is great, but come on, are you going to …
Highlight dates dynamically
Conditional formatting is another powerful feature in Excel, especially when you combine it with functions A simple function as in below if you set it up inside Conditional formatting, can …
IF with AND and IF with OR
The powerful function If can already do a lot of tricks, but we can for sure do more when we use it with AND or OR functions. Also, once we …
New function IFERROR, finally
We have already gotten used to use VLOOKUP, MATCH and other functions that generates errors inside an IF But, we do not need that anymore We can use the new …
Calculate hours between two cells
We needed that several times in the past Then I found it in an old file in my laptop, thought to share it for others to help So, when A1 …
Workdays – Across months
Get total number of days per month This was a question from one of my friends, This set of formulas will calculate how many days (Networkdays) in each of the …
Week number to Month number
Now we need to convert week number to month number This is exactly the same as week number to date (reverse weeknum) So, when the week number is in A5, …