One of the coolest tricks in Microsoft Excel is the ability to use it to calculate complicated matrix functions. While this isn't a totally mainstream use, if you've ever needed to work with matrices ...

How to count individual cells within a row by their fill color in Excel Your email has been sent The article How to easily sum values by a cell’s background color in Excel shows you an easy way to ...

How to conditionally count the number of times any value occurs in Excel Your email has been sent Specifying the conditional count of a value sounds like a daunting task, but two Excel functions make ...

A subrequirement that derives from multiple primary requirements can be achieved using the concatenation of the cells in the reference coupled with a line-feed character. For example, if CEI ...