I have a table with 20 columns. The first 5 columns are for data entry. One column uses a sample code with multiple parts to describe aspects of the sample. The remaining columns contain formulas that extract portions of the sample code resulting in the text equivalent of a part of the code. What appears to be random, the formulas will change the row reference and extract data from a different row than from the same row. Here are some examples:
IF(C3="","",LEN('Main Page'!$C3)) (The first row)
IF(C289="","",LEN('Main Page'!$C289)) (The last row with the correct row reference)
IF(C290="","",LEN('Main Page'!$C573)) (The next row, and so on)
IF(C291="","",LEN('Main Page'!$C574))
IF(C320="","",LEN('Main Page'!$C603))
IF(C321="","",LEN('Main Page'!$C290))
It appears that something was inserted at row 289 that restarted in row 321.
Any ideas?
Bookmarks