## TRANSPOSE function

Excel » Functions » Lookup and reference » TRANSPOSE function »

Count cells containing text from list

The array formula in cell F3 counts cells in column B that contains at least one of the values in […]

How to use the TRANSPOSE function

The transpose function allows you to convert a vertical range to a horizontal range, or vice versa. A vertical range […]

Count overlapping days in multiple date ranges

The MEDIAN function lets you count overlapping dates between two date ranges. If you have more than two date ranges […]

Excelxor is such a great website for inspiration, I am really impressed by this post Which numbers add up to […]

Quickly concatenate values into one cell [No VBA]

Joining multiple cell values in Excel is not easy, for example, the CONCATENATE function allows you to only reference a […]

Extract unique distinct values based on the 4 last characters

Sean asks: The good thing about this formula is that it is short and easy to remember. The main drawback […]