I have Imported a 30 page file from another software program into Excel.
I then added a formula which calculates several columns and copy and pasted it to all 30 pages.
Since some rows are subheading (text), I end up with the #VALUE! error on these rows. What do I need to do to universally remove the formula from these rows without having to correct each affected cell individually.
I can't get a total on this column because of these errors and that is why I need to remove them.
Bookmarks