![]() |
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 |
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 |
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 |
Quote:
|
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? |
What exactly are you trying to create? What sequence of numbers do you want in which columns? |
1 Attachment(s) This is what I got so far. |
^?????? wtf lol |
select 4-9 and then drag it all down. |
Thanks all.. I thought I tried selecting the columns and dragged down.. |
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 |
Right click on X-axis labels > Format Axis > Change Minimum to 42408 |
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