View Full Version
:
Any excel gurus can help me
FerrariEnzo
12-30-2015, 05:43 AM
If I pull the botton right of the cell and drag down, it gives me all the number in order which I dont want... I want to skip some numbers in each column
http://i.imgur.com/ERVbuqL.png
Thanks
lowside67
12-30-2015, 06:12 AM
If you select "009" and drag down, it will give you "010", "011".
However, if you select all 3 of "003, 006, 009" and drag down it will continue the sequence by giving you "12", "15", "18"...
Mark
JesseBlue
12-30-2015, 08:38 AM
Just create a formula on the second line (if it is the same for the third line) and drag that....that or manually type everything as what you have done so far ...hehe
DaFonz
12-30-2015, 09:03 AM
Just create a formula on the second line (if it is the same for the third line) and drag that....that or manually type everything as what you have done so far ...hehe
Do this and then copy -> paste special -> values.
inv4zn
12-30-2015, 10:44 AM
You're going to have to create a formula and then copy that (or drag, w/e) to other cells - which numbers are you trying to skip?
underscore
12-30-2015, 12:21 PM
What exactly are you trying to create? What sequence of numbers do you want in which columns?
DragonChi
12-30-2015, 12:30 PM
This is what I got so far.
inv4zn
12-30-2015, 04:05 PM
^??????
wtf lol
fs604
12-30-2015, 04:19 PM
select 4-9 and then drag it all down.
FerrariEnzo
12-30-2015, 11:40 PM
Thanks all..
I thought I tried selecting the columns and dragged down..
ilovebacon
02-08-2016, 07:27 PM
I need help with this software!! :(
please pm me
The date starts at dec 2/2015. I cant find a way to change it to the current date..
What I really want is that my start date is feb/08/2016
Right click on X-axis labels > Format Axis > Change Minimum to 42408
ilovebacon
02-08-2016, 09:19 PM
nvm thanks i got it figured :)
vBulletin® v3.8.11, Copyright ©2000-2026, vBulletin Solutions Inc.