Category: INDIRECT

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...

Why I ran from =INDIRECT() function

I think if there is a single function that would be a huge threat to VBA and macros from user perspective, it would be INDIRECT()...

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...