Most valuable professional
  • Hot Topics

Excel Filtering or updating the table screws up this formula for some reason

I have a couple of excel sheets that I am using this formula in. At the start of every month, I delete all but the first record of the table and paste in the new month's data. This however screws up the formula and it ends up with completely different cell references. Filtering the data seems to do the same thing. The forumula I'm using is: =IF(B2="","",IF(ISNA('Print ref'!B2),NA(),'Print ref'!B2-TODAY()&" Days remaining"))

This question generated 12 answers. To proceed to the answers, click here.

This thread is current as of June 4, 2017.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel