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 […]

Concatenate cell values

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