Hide and unhide rows in Excel The article today “Hide and Unhide rows and columns” is just a quick introduction to hide and unhide rows. The first section covers hiding and showing a continuous series of rows. There are several methods, but we keep it to one and a series of rows this time. In […]
1 look-up function, Index and Match In today’s article the focus are the lookup functions Index and Match, and how they can be used together. Attached to the Article you will find a PDF version for printout. There is also an Excel file that have one sheet containing a dataset (booklist with columns author, title […]
Look up a value The article today is the first explanation for use of a nested Excel function on Office-Tips.net. There are several ways of looking up values in Excel, our example is finding a value based on a set of given criteria’s.