In the screenshot below there is a list of students from St John’s school (Cells A2 – A7) and a list of students who attended a specific exam (Cells B2-B6). The COUNTIF function can be used to compare two lists and return the number of items within both lists. We’ll start with some basic scenarios and slowly layer on the complexity until we achieve some advanced formula magic. This post looks at one aspect of this and considers how to use the COUNTIF function to create and compare lists to check for duplicate or unique values. Counting cells which meet specific criteria may not seem particularly useful, but when combined with other functions, and boolean (true/false) logic, it creates new capabilities you never thought possible. Question: Until then what is the best option?ĬOUNTIF is an untapped powerhouse for most Excel users. Therefore, it could be 6 or more years before enough users have the new functionality to use it safely and ensure compatibility. However, not everybody has the subscription and will upgrade when it is sensible for their business, often combining it with a hardware refresh. These new formulas are being rolled out to Office 365 subscribers over the next few months. The Excel team recently announced new dynamic array formulas, which can create unique lists, sort and filter with a simple formula.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |