drag

Is there any way to drag two of the same dates down a column. Example Date of 1/1/18 in cell A1 and same date 1/1/18 in cell A2. I would like to be able to highlight both cells and drag them down or any method so the date will advance incrementally in the next two cells, A3 and A4, etc.

Hello, I have a formula that links a cell from another WB. The formula works fine but when I drag it down the column in order to link other cells it doesn't copy correctly. It actually copies identical without adding the next row as a reference. I know by placing a "$" in front of either letter...

I need a formula I can drag across multiple columns, which will calculate the first Monday of the month increasing by one month each column. So far I've come up with the following, which seems to work but is over-engineered and I'm worried about it slowing down the rest of my sheet. Does...

I am not much good at this and any help would be appreciated. I can’t drag formula down column. =Sum($E59:E164)/105 =Sum($E59:E165)/106 Note division is Ascending by each entry Drag gives: =Sum($E59:E164)/105 =Sum($E59:E165)/106 which is correct...

<tbody> <tbody> Column "W" of my worksheet is formatted as Percentage, If I drag & drop one cell to the cell below, the percentage copies correctly. If I drag a contiguous group of cells in any row that contain column "W" the percentage is increased by 100% in Column "W". 20% in...

Is it to possible to do the following: A B C D E F... BA BB BC 4 5 2 8 9 6 (4-5) (2-8) (9-6) In column BA, I want to subtact COL a from COL B In column BB, I want to subtract COL C from COL D This is repeated 150 times so the...

Hey all, Thanks for the help in advance. I am using this formula currently to pull a cell value from another sheet: ='0.3a Daily Outputs CON'!$S8 When I drag the formula to the right, I want to to change the cell reference to S20 - I.E Move 12 rows down in the referenced sheet (as this is...

Hi all, Suddenly today, the little cursor to drag down to fill has "stopped working". I have a VBA-defined Name which is called by "FontColor" in my function as in the picture (I had to block out sensitive info). The code for FontColor in my defined name is: GET.CELL(24,Sheet1!X3:X252). The...

Hi, Hope this makes sense to someone. A1 = Question 1 A2 = Possible answer A A3 = Possible answer B A4 = Possible answer C A5 = Possible answer D In cells A6, A7, A8 & A9 I would like to display the contents of either A2, A3, A4 or A5 this must be in a random order as I wish to drag the...

Hi, I am hoping someone can help me. I have the following formula inputted in Sheet 1 in cell A3: =INDEX(Sheet2!$B2:DJ2,MATCH($A$2,Sheet2!$B$1:$DJ$1,0)) It basically states that if the drop down list in A2 matches with any cell in Row1 in Sheet 2 then it will drag through whatever is below...

Hi everybody, I am trying to work out the median across a row E.g. C1:F1. I need to drag this calculation to the right and in doing so, keep the column the same but have the row skip 7, So on a new sheet A1 contains =Median('Sheet1'!C1:F1), B1 contains =Median('Sheet1'!C8:F8) etc. It would...

Hello, I am currently trying to make a macro in excel to automate dragging my formulas down every month. For reporting purposes, I need to drag all rows of the formula down one row to show data for the new month. I am new to this application of excel so I was wondering how I could use it to...

Hello, I made a table (see E2:J6) based on the data from A1:A12. To get the data for this, I made a formula that gets the name from a specific category. This formula is: IFERROR(INDEX($C$1:$C$4,MATCH(F2, $B$1:$B$4,0)),"") If I drag this row to the right (so e.g. from F3:J3), the data gets...

Hello guys, I'm working on an excel spreadsheet and I've run into an issue with tables. Whenever I reference the entire column and try to drag it along with CRTL+D, the column refernce stays static and does not change. Is there a way to allow relative column referencing with tables so whenever...

Hello, I am trying to figure out a formula to skip columns D, G, etc. when I drag an =cell value formulas in a different worksheet Example: Cell A1=B70 and B1=C70. When I drag the formula column D, G, and the 20 other columns are in the way. Is there a way to skip pver those columns?

Hi Friends, I am new to this forum. I am getting below error in excel- "we couldnt get data from external source. here is the error message we got - The query referenced calculated column xx which does not hold any data because evaluation of one of the rows caused an error." I connected my...

Hi guys, I would like to ask, how can i drag VBA Formula? Okey this is my formula for my excel project... Private Sub CommandButton3_Click() Range("G5").Value = Range("G5").Value - Range("K5").Value Range("K5").Value = "" Range("G5").Value = Range("G5").Value + Range("I5").Value...

Hi All, When I try and click and drag to select cells to copy (for example) if I have to drag to make the page scroll down Excel keeps entering this weird formula and it is really difficult to get rid of - does anyone know why it is happening (or what stupid thing I am doing???) Pic of example...

Hello all, Trying to keep a =cell to always refer to that cell number (not the contents but the actual cell itself) even if i drag/move the contents of referenced cell. Absolute reference ($a$1 doesnt work) For clarity; I want Sheet2 A2 to ALWAYS reference to sheet1 A5.Even if I drag the...

I have a column of various numbers in column B I have the following formula COUNTIF($B2:$B2218,"=0"), Is there a way for me to have this formula incrementally increas as I drag it over so I would want it to go to: COUNTIF($B2:$B2218,"=0") COUNTIF($B2:$B2218,"=1") COUNTIF($B2:$B2218,"=2")...