COUNT function
Excel » Functions » Statistical » COUNT function »
The COUNT function counts all numerical values in an argument, it allows you to have up to 255 arguments. Formula […]
The formula in cell C3 grabs the first word in B3 using a blank as the delimiting character. =LEFT(B3,SEARCH(" ",B3)-1) […]
If cell contains multiple values
This article demonstrates formulas that perform a partial match for a given cell using multiple strings specified in cells F2 […]
This article demonstrates two ways to calculate expenses evenly split across multiple people. The first one is a formula solution, […]
A dynamic named range grows automatically when new values are added and also shrinks if values are deleted. This saves […]
Highlight records containing text strings (AND Logic)
The picture above shows you how to highlight rows containing text strings using conditional formatting. Example, continents criterion (cell B3) […]
Create dependent drop down lists containing unique distinct values
This article explains how to build dependent drop down lists. Here is a list of order numbers and products. We […]
Convert dates into date ranges
The array formula in cell D4 extracts the start dates for date ranges in cell range B3:B30, the array formula […]
I read an interesting blog post Is A Particular Word Contained In A Text String? on Spreadsheetpage. That inspired me […]
This article describes how to count unique distinct values. What are unique distinct values? They are all values but duplicates are […]