![]() |
#4
|
|||
|
|||
![]()
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. |
|
![]() |
||||
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 |
![]() |
pachmarhi | Excel | 3 | 07-18-2014 09:57 PM |
![]() |
ReviTULize | Excel | 1 | 03-28-2013 02:27 AM |
![]() |
jannie | Excel | 1 | 06-22-2011 07:03 PM |