I'm not sure if this is possible, but does anyone know of a way I can use a formula that does not calculate any other cells that already have a formula in them.
There is no such thing as a formula that does not calculate, otherwise it would not be a formula but "data". One cell may reference another, such as A1=B1, which is, strictly speaking, cell referencing, but this too could be a formula of sorts (indirectly) if B1 contains a formula.
The reason being, I have to work with a specific type of imported spreadsheet from a .dat file, and the best way to filter out the information I do not want, is to exclude everything that has a formula. I'm hoping to use some sort of IF statement and exclude all formula driven cells.
Perhaps if you explain in greater detail/clarity what it is you want to accomplish a solution can be provided.
Can you not filter on values or some other criteria?
Without knowing further details about your workbook, perhaps you can adapt this script to help with filtering. It will look at all cells in a column and if the cell has a formula will write a value of one (1) in the adjacent column and a zero if it does not have a formula.
You might follow this up with Advanced Filter with criteria to copy only records with a "0" to another sheet.
Bookmarks