-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
dragged
-
S
INDIRECT Formula
I have the following formula:- =INDIRECT("'"&TEXT($P$1,"d mmmm yyyy")&"'!"&"A4") How can this be amended so that the A4 part will adjust (so A5, A6, A7) etc when dragged down?- surkdidat
- Thread
- adjust amended dragged formula part
- Replies: 3
- Forum: Excel Questions
-
R
Adjusting Pixel
Hello! Anyone knows how to change the pixel? I tried changing the pixel under Format Cells, but the cells becomes too large. If I dragged the cells to meet the required pixel size, the cell is too small and I cannot see the data.- Raisha2018
- Thread
- cells data dragged pixel required
- Replies: 0
- Forum: Excel Questions
-
B
Change Column Reference When Formula is Dragged Down
How can I change the Column reference as a formula is dragged down? For example, Sumif(sheet1!CY:CY, When I drag down the formula, I want it to change to be: Sumif(sheet1!CZ:CZ, And so on. Is it some kind of Indirect or Offset formula? Thanks!- billbilliamson
- Thread
- change column dragged formula reference
- Replies: 2
- Forum: Excel Questions
-
B
Change Column Reference When Formula is Dragged Down
How can I change the Column reference as a formula is dragged down? For example, Sumif(sheet1!A:A, When I drag down the formula, I want it to change to be: Sumif(sheet1!B:B, Is it some kind of Indirect or Offset formula? Thanks!- billbilliamson
- Thread
- change column dragged formula reference
- Replies: 2
- Forum: Excel Questions
-
S
Increment values in a special manner
Hi, I have a number which goes like XXXXX/dd-mm-yy. What I want is that when this number is entered into a cell and then dragged down, the XXXXX part should get incremented by one number each but the /dd-mm-yy should remain the same. Is it possible...??? TIA- shaju
- Thread
- dragged incremented number part xxxxx
- Replies: 10
- Forum: Excel Questions
