![]() |
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 09:30 PM. |
Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2026, vBulletin Solutions 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