How do you use the HLOOKUP function in Google Sheets, and what are some best use cases? The HLOOKUP function searches for data in the first row of a range and returns a specific nth cell in the...
Category: Apps
Can a Google Sheets drop-down list in a cell allow you to do multiple select? Google Sheets doesn't natively support the ability to select more than one item on a drop-down list in a cell, but...
How do you stop a long running map/reduce script in SuiteScript? There are two ways to stop the running of a map/reduce script: cancel the script in the Map/Reduce Script Status area, or make the...
What is the formula to add in Excel? There are two popular ways to add numbers together in Excel: using the plus sign + or using the SUM formula. Use the + sign where values being added are...
If a cell contains words it can be easy to split these into individual cells using the Text to columns feature in Excel. Simply select the cells you want to split into multiple columns, navigate to...
When you start entering text into a cell and the first character of that cell is a plus symbol (+) you will get an error #NAME? and you would have noticed the cell changed to =+A. So how can you just...