|
|
#1
12-19-2017, 12:59 PM
|
|||
|
|||
Absolute Column Error
Howdy,
I am trying to drag and copy a formula to alot of cells, The formula is: ='Master Index'!$AB4 I am trying to use an absolute value for column AB and not row 4; however, when I drag and apply the formula to all the other cells it is as if the formula was $AB$4. What do I need to do to lock the formula to just the AB column. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Absolute Value Size Consistency
|
bdavidson40 | Word | 4 | 08-28-2017 03:48 AM |
| Error message in pivot when i try drag and placing a column in the row label | olybobo | Excel | 0 | 05-10-2016 02:05 PM |
| Always on top, absolute times for slideshow | cab07 | PowerPoint | 0 | 07-06-2014 05:06 AM |
|
Inconsistent Calculated Column Formula Error
|
amlevesq | Excel | 1 | 04-22-2014 11:53 AM |
| column width error message | norwood | Word VBA | 2 | 10-07-2013 05:05 PM |
Windows 7 64bit 
Office 2013
Threaded Mode