Apr 29, 2014 · Concatenate won't copy down my column I'm using a concatenate formula for first and last names ex: =CONCATENATE (A2," ",B2) When I try to drag it down my column from …

Dec 8, 2016 · Re: Applying formula to a column with different sized merged cells You could instead select C3:C269, paste =A3*B3 in the formula bar, press and hold the Ctrl key, then …

Feb 22, 2021 · I used Xlookup to create an array formula to return 5 columns of data. The formula works fine, but I can't get it to fill down. If I change the Xlookup formula to return just 1 column …

Jul 14, 2022 · Re: Copy formula down column with a non sequential reference Quick check - are you still using Excel 2016? ADVICE: get rid of ALL merged cells and normalise your data. It …

Feb 16, 2017 · On every formula I have attempted to copy down the column excel continues to return the value received in the first row. As an example I need to reformat a date field (e.g., …

Aug 16, 2022 · How do I copy a Formula Down a Column? This should be a super simple question, but I have never had the need for this function with copying the formula down a …

Jan 27, 2011 · Re: Copy formula down column but need to skip 'n' rows Please remember to mark your thread as Solved. How to mark a thread Solved Go to the first post Click edit Click Go …

Apr 22, 2017 · How to get formula to change by -1 column as you drag down rows By stephme55 in forum Excel General Replies: 4 Last Post: 03-11-2016, 03:15 PM

Oct 24, 2017 · Re: Copy formula from another cell only changing column letter Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the …

Jul 1, 2013 · As the formula is copied down, this part becomes ROW (A4), ROW (A5) etc. on successive rows, i.e. it returns 3, 4, 5 etc starting from G20 - this is the column number on row …