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...
Get column name (columnname as A,B,C, etc) as input inside cell
Excel already has the formula ROW() =Row() Which as we may already know will give us the number of the row we are in, if...
iframe in Excel (XLiFrame)
This is the iframe in Excel, if you are familiar with the HTML concept of iframe, you will understand this one right away, it is...
Rotate table using 1 formula
Rotating table (Transpose) using functions so that the table is updated once the source table is updated. Also can be used as automatically rotating tables...