Computer Tech, Gaming & Electronics THIS SPACE OPEN FOR ADVERTISEMENT. YOU SHOULD BE ADVERTISING HERE!
Silicon Valley.
Tips & tricks, tech support, home theatre, online gaming, reviews, latest news... |
 | 
12-30-2015, 05:43 AM
|
#1 | | I answer every Emotion with an emoticon
Join Date: Feb 2005 Location: somewhere
Posts: 7,906
Thanked 2,485 Times in 1,007 Posts
| 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 
Thanks
| 
|  | |
12-30-2015, 06:12 AM
|
#2 | | Old School RS
Join Date: May 2004 Location: Port Moody
Posts: 4,560
Thanked 3,957 Times in 1,205 Posts
|
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
__________________
I'm old now - boring street cars and sweet race cars. | |
| | |
12-30-2015, 08:38 AM
|
#3 | | Rs has made me the woman i am today!
Join Date: Oct 2001 Location: Here! n There!
Posts: 4,149
Thanked 498 Times in 222 Posts
|
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
__________________
Go Canucks Go!
| |
| | |
12-30-2015, 09:03 AM
|
#4 | | RS has made me the bitter person i am today!
Join Date: Apr 2002 Location: In your head
Posts: 4,591
Thanked 376 Times in 176 Posts
| Quote:
Originally Posted by JesseBlue  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.
| |
| | |
12-30-2015, 10:44 AM
|
#5 | | Rs has made me the woman i am today!
Join Date: Jun 2006 Location: Burnaby
Posts: 4,024
Thanked 6,696 Times in 1,625 Posts
|
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?
| |
| | |
12-30-2015, 12:21 PM
|
#6 | | To me, there is the Internet and there is RS
Join Date: Apr 2007 Location: Okanagan
Posts: 16,272
Thanked 8,922 Times in 3,876 Posts
|
What exactly are you trying to create? What sequence of numbers do you want in which columns?
__________________ 1991 Toyota Celica GTFour RC // 2007 Toyota Rav4 V6 // 2000 Jeep Grand Cherokee
1992 Toyota Celica GT-S ["sold"] \\ 2007 Jeep Grand Cherokee CRD [sold] \\ 2000 Jeep Cherokee [sold] \\ 1997 Honda Prelude [sold] \\ 1992 Jeep YJ [sold/crashed] \\ 1987 Mazda RX-7 [sold] \\ 1987 Toyota Celica GT-S [crushed] Quote:
Originally Posted by maksimizer half those dudes are hotter than ,my GF. | Quote:
Originally Posted by RevYouUp reading this thread is like waiting for goku to charge up a spirit bomb in dragon ball z | Quote:
Originally Posted by Good_KarMa OH thank god. I thought u had sex with my wife. :cry: | | 
| | |
12-30-2015, 12:30 PM
|
#7 | | HELP ME PLS!!!
Join Date: May 2002 Location: vancity
Posts: 5,734
Thanked 722 Times in 364 Posts
|
This is what I got so far.
| |
| | |
12-30-2015, 04:05 PM
|
#8 | | Rs has made me the woman i am today!
Join Date: Jun 2006 Location: Burnaby
Posts: 4,024
Thanked 6,696 Times in 1,625 Posts
|
^??????
wtf lol
| |
| | |
12-30-2015, 04:19 PM
|
#9 | | 14 dolla balla aint got nothing on me!
Join Date: Feb 2011 Location: 604
Posts: 674
Thanked 1,034 Times in 174 Posts
|
select 4-9 and then drag it all down.
| |
| | |
12-30-2015, 11:40 PM
|
#10 | | I answer every Emotion with an emoticon
Join Date: Feb 2005 Location: somewhere
Posts: 7,906
Thanked 2,485 Times in 1,007 Posts
|
Thanks all..
I thought I tried selecting the columns and dragged down..
| |
| | |
02-08-2016, 07:27 PM
|
#11 | | My homepage has been set to RS
Join Date: Jan 2012 Location: vancouver
Posts: 2,441
Thanked 1,755 Times in 544 Posts
|
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
Last edited by ilovebacon; 02-08-2016 at 07:33 PM.
| |
| | |
02-08-2016, 09:03 PM
|
#12 | | Willing to sell body for a few minutes on RS
Join Date: Aug 2004 Location: Duncan, BC
Posts: 10,127
Thanked 5,568 Times in 2,107 Posts
|
Right click on X-axis labels > Format Axis > Change Minimum to 42408
| |
| | |
02-08-2016, 09:19 PM
|
#13 | | My homepage has been set to RS
Join Date: Jan 2012 Location: vancouver
Posts: 2,441
Thanked 1,755 Times in 544 Posts
|
nvm thanks i got it figured  | |
| | |
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts
HTML code is Off
| | |
All times are GMT -8. The time now is 03:23 PM.
|
You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!
The banners on the left side and below do not show for registered users!
