The double dash is crucial for complex array logic operations in your spreadsheet.

Write Excel formulas that are easy to understand and don't consume lots of memory.

is a senior editor and author of Notepad, who has been covering all things Microsoft, PC, and tech for over 20 years. Microsoft Excel used to only allow two types of data: text and numbers. After ...