I have an excel spreadsheet that has 100000 lines of formula (column C) that will apply referencing the data I paste on column A. When I want to copy the result list, I select the cell C1 and ctrl+shift+down to select the whole range and then I ctrl+c.
The problem I'm facing is that the empty cells that have formula are still counted as if they have value. So if I paste only 97000 lines on column A, when I want to select data from column C I can't use ctrl+shift+down properly since it selects all the way down to C100000. Is there any way I can ignore cells with formulas where the calculated value is empty or non existant when moving cells or selecting range?