Year: 2022

Return 12 values in one number

A technic I loved using, return list of items (up to 12 items now) in ONE number. Let us say you have list of 12...

Cells with additional spaces

Detect which cells has additional spaces added by mistake by user. =IF(AND(Left(F2, 2) = "No", LEN(F2) >2, "Space at end", "")...

Comments versus Notes

It is official and looks better now, I know it might be confusing, but I liked it so far Excel now has “Comments”, the classic...

Searching table in 2 dimensions.

Using VLOOKUP + MATCH (HLOOKUP + MATCH, OFFSET + 2 MATCHes or INDEX + 2 MATCHes) to search a table in both axis. This post...

Search across sheets in function

Just when you need to search for a thing across sheets in a workbook. I am bored, so I am adding articles from my old...