REVscene Automotive Forum

REVscene Automotive Forum (https://www.revscene.net/forums/)
-   Gaming, Computer Tech & Electronics (https://www.revscene.net/forums/gaming-computer-tech-electronics_32/)
-   -   Any excel gurus can help me (https://www.revscene.net/forums/706928-any-excel-gurus-can-help-me.html)

FerrariEnzo 12-30-2015 05:43 AM

Any excel gurus can help me
 
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

Quote:

Originally Posted by JesseBlue (Post 8712229)
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

1 Attachment(s)
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

1 Attachment(s)
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 :)


All times are GMT -8. The time now is 03:06 PM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
SEO by vBSEO ©2011, Crawlability, Inc.
Revscene.net cannot be held accountable for the actions of its members nor does the opinions of the members represent that of Revscene.net