Using VLOOKUP + MATCH (HLOOKUP + MATCH, OFFSET + 2 MATCHes or INDEX + 2 MATCHes) to search a table in both axis. This post has been sitting for a while in my archive, waiting for me to get some time to polish and post.
Formula to get first name from 2 formats either (Lastname, First) or (Firstname Last) formats.
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 archive.
Finding which vehicle with minimum (or maximum) amount of savings among peers. This is an old request, found its formula in my archive to calculate which of the 4 columns is actually has the minimum (or maximum) of savings among other columns. Trick is as you guessed it was OFFSET.
A trick learned awhile ago. Creating shapes connected to cell, that updated automatically. When following steps attached, you will be able to connect any shape to any cell in away making it “linked”, so when cell changes the shape will also get updated. Used it to enlarge or track user attention to a certain value, […]
Just a quick find I noticed few days ago. If you notice, the & inside cell has turned into an underline of the letter after CQ – G&A has turned to CQ – GA This is a programming technique we used to apply in Menus to allow users to execute a shortcut, looks like here […]