Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 01-10-2016, 08:48 AM
xor xor is offline copy non zero values to new column Windows 10 copy non zero values to new column Office 2013
Expert
 
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Do you know array formulas (which it is)?

If not, please observe that when entering or editing such a formula you most hold down Ctrl and Shift before pressing Enter. When you have entered one array formula you can copy it to other cells in normal ways. If you do it correctly Excel will automatically put braces around the formula.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
If column B cell is a certain value then copy and paste the value to column A Snaybot Excel Programming 1 12-01-2015 07:10 PM
Copy column 1 data into Column 3 ShailShin Word VBA 1 06-18-2015 10:49 AM
copy non zero values to new column Insert values from multiple rows based on value in one column pachmarhi Excel 3 07-18-2014 09:57 PM
copy non zero values to new column Auto-create row from column values ReviTULize Excel 1 03-28-2013 02:27 AM
copy non zero values to new column Eliminating zeros, null values and negatives in a column jannie Excel 1 06-22-2011 07:03 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:16 PM.


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