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 items, and you want a function that will return some of that list (with no order), then this is how you can do it. This has been sitting around for […]
Detect which cells has additional spaces added by mistake by user. =IF(AND(Left(F2, 2) = “No”, LEN(F2) >2, “Space at end”, “”)
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 Comments are now called “Notes” I used Notes a lot, mainly to remind me of certain expectations of some cells, or guide the user to some additional info about some […]
