PDA

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

Jmac
02-08-2016, 09:03 PM
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 :)