Spreadsheets

There will come a time when using Google Sheets where you will be checking the value of a cell against multiple criteria, which one is the best to use? There …

What happens when you get the oblique error from Excel VBA that there has been an invalid property assignment (Error 450)? Here’s how I was able to find the solution.

Continuing to advance my feature previously on combining two columns into one unique column, here we combine multiple columns into one unique sorted column in Google Sheets.

If you need to join two columns of unknown height together then follow this step-by-step illustrated guide.