Compare2, a tool to compare two sheets using formulas
Tool will compare between two sheets using formula/functions method. Once you type in full folder locations (for both files), file names and sheets names in file1 and file2. Make sure …
Skills Grid
A small Excel file to show how we can create a chart-like Excel sheet Used in my Resume to show different skill sets and the level of expertise in each
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 …
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 …