![]() |
#1
|
|||
|
|||
![]()
I ran into the following problem in EXCEL 2010 and 2013:
- I have a very large file that is roughly 43,000 rows long - I filtered the 43,000 rows to yield only specific types of items - In a column to the right of the filtered data I pasted a relative formula in each row that added 3 at each row - The quantities of items in each row was 3, so I thought the paste would yield a sum of all filtered items - The formula paste actually took place in all 43,000 rows instead of just the visible filtered rows yielding an erroneous total (much larger) - At least I think it is erroneous. Should Excel paste the formula even in rows that have been filtered out and are no longer visible? If so, does that make sense? I suspect I am missing something, and would appreciate any inputs. Thanks, |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Paste to a series of boxes with one paste? | BudVitoff | Misc | 0 | 11-27-2013 02:51 PM |
![]() |
tinfanide | Word | 6 | 03-06-2013 12:21 AM |
![]() |
gbaker | Excel | 4 | 06-21-2012 08:10 AM |
![]() |
raven26c | Word | 1 | 11-18-2011 02:49 AM |
Issue with formula's from an outside source | phroche | Excel | 0 | 11-07-2008 03:08 PM |