INDIRECT worksheet function


February 2nd, 2016 by admin admin

I have a formula which is used to find out if a particular description is available. It works well except that I have to keep readjusting the range in the formula because it is shortened every time I delete the rows within the range. In the end, I have to make use of the INDIRECT worksheet function to freeze it so that it is not affected by the deleting of rows.

Leave a Reply

You must be logged in to post a comment.

s2Member®