Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-01-2014, 02:11 AM
rabend rabend is offline Formula Paste Issue Windows 8 Formula Paste Issue Office 2013
Novice
Formula Paste Issue
 
Join Date: Jun 2014
Posts: 1
rabend is on a distinguished road
Default Formula Paste Issue

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,
Reply With Quote
 



Similar Threads
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
Formula Paste Issue Paste Special: Copy and Paste Formatting Only? tinfanide Word 6 03-06-2013 12:21 AM
Formula Paste Issue Cut & Paste issue gbaker Excel 4 06-21-2012 08:10 AM
Formula Paste Issue Word 2007 Copy/Paste Excel issue 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:48 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft