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