Hello,
I have a range of cells that are designated as a list. Directly to the right of this list I have created 3 columns that have formulas that calculate data based on each row. The problem is two of these 'calculated data' columns contain a #VALUE error when I click inside the list. When I click on one of the actual calculated data cells the #VALUE error disappears and the correct results of my formulas appear as I want them. I thought this was just a visual glitch but I just tried to make a pivot table from this data and can't do it because the #VALUE errors are also being read by my pivot table.
I have a range of cells that are designated as a list. Directly to the right of this list I have created 3 columns that have formulas that calculate data based on each row. The problem is two of these 'calculated data' columns contain a #VALUE error when I click inside the list. When I click on one of the actual calculated data cells the #VALUE error disappears and the correct results of my formulas appear as I want them. I thought this was just a visual glitch but I just tried to make a pivot table from this data and can't do it because the #VALUE errors are also being read by my pivot table.