Beginner question
Tony Vella
from 1 to 100? I am using Excel 97 on an XP Home machine. Thanks in
advance.
--
Tony Vella in Ottawa, Canada
Excelenator
I'm sure there are tons of ways to do this. Here's one.
- Enter the numbers 1 and 2 in cells A1 and B1 respectively
- Highlight cells A1 and B1
- Right click hold the small square in the lower right hand corner of
the highlighted range.
- Drag over 8 more columns, let the mouse button go and select fill
series
- Now select cell A2 and input =A1+10
- Copy Cell A2 to Cells A2:J10
- copy the entire range and paste values over them
--
Excelenator
------------------------------------------------------------------------
Excelenator's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36768
View this thread: http://www.excelforum.com/showthread.php?threadid=568191
Biff
How do you want the output?
1...........10
11.........20
Or:
1...11...21
2...12...22
For the first example, enter this formula in top left cell of the grid:
=COLUMNS($A:A)+(ROWS($1:1)-1)*10
For the second example:
=ROWS($1:1)+(COLUMNS($A:A)-1)*10
Copy the formula across to 10 columns then down 10 rows.
Then, if you want to get rid of the formulas and convert them to constants:
Select the grid of cells
Goto Edit>Copy
Then, Edit>Paste Special>Values>OK
Biff
"Tony Vella" <tony....@rogers.com> wrote in message
news:waWdnYwGzpVPNU_Z...@giganews.com...
L. Howard Kittle
Here's a couple macros, one for numbers across and one for numbers down.
For numbers across you will need to name a 10 by 10 cell block Data, or any
name you wish, and then change Data in the code to your name.
Sub NumbersAcross()
Dim Cell As Range
Dim i As Integer
i = 1
For Each Cell In Range("Data")
Cell.Value = i
i = i + 1
Next
End Sub
Sub NumbersDown()
Dim i As Integer
Dim Cell As Range
Range("A1").Select
For i = 1 To 100
ActiveCell.Value = i
ActiveCell.Offset(1, 0).Select
If ActiveCell.Row = 11 Then
ActiveCell.Offset(-10, 1).Select
End If
Next
End Sub
HTH
Regards,
Howard
"Tony Vella" <tony....@rogers.com> wrote in message
news:waWdnYwGzpVPNU_Z...@giganews.com...
aaron...@gmail.com
run away while you still can. Excel is a waste of time.
Spit on people that use Excel.
-Aaron
Gord Dibben
Who knows.......maybe some day you will need 115 x 186 matrix<g>
Sub FillNums()
'to fill rows and columns with numbers from 1 to whatever
Dim nrows As Integer
Dim ncols As Integer
On Error GoTo quitnow
RowsorCols = InputBox("Fill Across = 1" & Chr(13) _
& "Fill Down = 2")
Num = 1
nrows = InputBox("Enter Number of Rows")
ncols = InputBox("Enter Number of Columns")
If RowsorCols = 1 Then
For across = 1 To nrows
For down = 1 To ncols
ActiveSheet.Cells(across, down).Value = Num
Num = Num + 1
Next down
Next across
Else
For across = 1 To ncols
For down = 1 To nrows
ActiveSheet.Cells(down, across).Value = Num
Num = Num + 1
Next down
Next across
End If
quitnow:
End Sub
Gord Dibben MS Excel MVP
On Fri, 4 Aug 2006 14:01:31 -0700, "L. Howard Kittle" <lhki...@comcast.net>
wrote:
aaron...@gmail.com
-Aaron
Harlan Grove
>will Excel even hold that many values?
Why don't you start using your fingers and toes. That'd be good for the
first 24 or so.
dbah...@hotmail.com
dbah...@hotmail.com
I would rather use pen and paper than excel
i mean-- draw it out; do the math in my head
btw, what did you score on your math SAT prick??
Harlan Grove
...
>I would rather use pen and paper than excel
No doubt produce as many errors, too.
>btw, what did you score on your math SAT prick??
800. What'd you score on your math GRE?
aaron...@gmail.com
never took a gre; im a dropout
I've spent $30 grand in classes in the past 5 years though
-Aaron
Harlan Grove
aaron...@gmail.com
Just because I spent classes on REAL PROGRAMMNIG LANGUAGES that help me
to write REAL TOOLS?
you write reports-- a la documents.
I write reports-- a la tools.
you do the same goddamn spreadsheet week in and week out.
Excel isn't the right tool for anything.
And your stupid MMULT? i can use that in analysis services out of the
box.
-Aaron
greaseman
Since this thread is quite new, thought I'd give you all a quick heads
up:
Aaron and Harlan have been engaged in their ridiculous tete-a-tete for
over a year, now. As you can easily see from how Aaron responds, any
replies he gives to you are completely useless. And since Harlan never
responds to anyone in this forum, his replies are useless as well.
All I can really say about Aaron is that he is one of those clowns who
brags a lot and says little. As in the case here, where he claims to
have spent $30,000 over five years on classes. He definitely learned
nothing about anything.
Incidentally, he was fired from Microsoft for two reasons: his
ineptitude and his mouth. Do a search on "Aaron" or "Aaron Kempf" or
"dbaHooker" in this forum and you will see some pathetic examples of
his garbage.
--
greaseman
------------------------------------------------------------------------
greaseman's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28808
Harlan Grove
...
>And your stupid MMULT? i can use that in analysis services out of the
>box.
Really?! How? Analysis Services/MDX lacks its own MMULT function, and
it's Excel function library also lacks it. So how would you perform
matrix multiplication with Analysis Services? Provide some details . .
. if you're able.
aaron...@gmail.com
don't discredit me.
I am trying to save these Excel dorks from obsolescence.
Excel is a dead end street-- run away while you still can.
Grow some balls and learn a real program like Crystal Reports or SQL
Server.. or if you're adamant that Excel is the future? Then learn
MDX. MDX is Olap times Excel-- it is a great language.
Sitting on your ass and still being a one-trick pony?
Excel is NOT a real development platform.
It DOESNT have real datatype validation.
It DOESNT have real data entry tools.
The data format-- Excel-- is not open or performant or reliable.
Multiple people can't use the same XLS at the same time.
On a scale of 1 to 10? Excel scores a ZERO.
Spit on people that use Excel.
Cut off their weiners-- so that they stop breeding.
Excel is a disease. I spit on you lepers.
Yes; I was fired from Microsoft-- for standing up for what is right.
2/3rds of the companies that I've ever been at-- use SQL
authentication. Microsoft takes this -tough-guy- tact--- their opinion
is 'fuck sql authentication'
Nobody outside of Microsoft knows how to configure double-hop
authentication.
And thus-- a TON of companies use SQL authentication-- even though it
can't stand up to a simple dictionary attack.
For the record?? I MIGHT BE HEADING BACK TO MICROSOFT SOON.
And let's just say that they're not having me in there for my 'Excel
Skillz'
Excel isn't a SKILL. It is a crutch; a tool and a disease.
Spreadsheet people can lick my NUTS.
If I had my way; you would be drinking whiskey out of a paper bag on
148th and Northrup.
I would pull over and SPIT on you.
'WILL SPREADSHEET FOR FOOD'
GAG ME WITH A SPOON
Jay Petrulis
greaseman wrote:
> Since this thread is quite new, thought I'd give you all a quick heads
> up:
>
> Aaron and Harlan have been engaged in their ridiculous tete-a-tete for
> over a year, now. As you can easily see from how Aaron responds, any
> replies he gives to you are completely useless. And since Harlan never
> responds to anyone in this forum, his replies are useless as well.
>
Aaron). However, please explain the Harlan comment.
No need for me to defend Harlan (this is my cue to defend Harlan).
Harlan can be challenging to deal with and would likely admit that
himself, but he provides a ton of help and usually responds quickly.
Take his tough-love and you can learn a lot.
In these threads, Harlan is merely exposing Aaron as a fraud. Sure, it
detracts from the group, but some of us (me) enjoy the Aaron Kempf
trainwrecks.
aaron...@gmail.com
I'm not the MONKEY that gets paid for repetitive copy and paste.
your jobs should be in India.. and I can't wait till people start
taking Excel seriously as a real Software Development platform.
Until then you guys can take your spaghetti code and shove it.
Million Dollar Spreadsheets that are stuck as single-user reports?
LAUGHABLE.
-Aaron
aaron...@gmail.com
btw; i've got TONS of other aliases.. you can't find them?
-Aaron
Jay Petrulis
Harlan Grove
...
>I'm not the MONKEY that gets paid for repetitive copy and paste.
No, you're the idiot who spends his free time making repetitive AND
worthless postings in newsgroups for a program he doesn't like.
aaron...@gmail.com
Jay;
what is this envy you've got?
you're jealous because I've got balls to do high-end SQL work and
you're stuck writing stupid little spreadsheets?
there is hope for you--
-Aaron
aaron...@gmail.com
million spreadsheet dorks that are taking it easy; copying and pasting.
it's not a way to run a company.
it's not a good way to have a growing career
Harlan Grove
>I'm not USELESS . . .
You're in denial. You'll get through it.
> . . . i'm just the only one that gives a shit abotu the 100
>million spreadsheet dorks that are taking it easy; copying and pasting.
...
But you don't care enough to show any of them, IN DETAIL, how much
easier and/or robust an Access or SQL Server solution would be. One is
left doubting whether you know anything other than how to rant. There's
little if any evidence to support your claims to vast knowledge and
expertise. And anyone (other than you) would think that if you really
did want to convince spreadsheet users to switch to databases, you'd
provide some DETAILED examples showing how much easier all sorts of
operations would be in databases. Your actions, however, support only
the conjecture that you just want to whine and rant.
greaseman
Aaron,
True...you are not useless. I say that because useless is a value and
you have no value.
The only thing you ever mumble about is copying and pasting, since that
is al you apparently know how to do.
The rest of us '100 million spreadsheet dorks' are quite content to USE
EXCEL THE WAY IT WAS DESIGNED TO BE USED!!!!! Is your head such a
vaccuum that you can't get that????????
All I can say is that I hope you have a glass belly button. Why??
Because your head is so far up your butt, that that's the only way
you'll ever see anything!
Jay Petrulis
aaron...@gmail.com wrote:
> Jay;
>
> what is this envy you've got?
>
> you're jealous because I've got balls to do high-end SQL work and
> you're stuck writing stupid little spreadsheets?
>
> there is hope for you--
>
> -Aaron
>
You are so right. I am jealous. Just the other day I inverted a
matrix and multiplied two matrices together to solve a simultaneous
equation problem.
Another time, I created a loan amotization schedule that allowed for
recapitalization of underpayment, excess principal paydown for
overpayment, and provided a way to change the effective interest rate
per period.
In every case, as I was banging my head against the desk, I lamented,
"woe is me" because I didn't have a SQL developer holding my hands.
The tasks were not too difficult in Excel, but just think of what could
be done if I used a DATABASE!!! (dramatic chord)
and for the record?
Are you wearing the juice?
http://www.apa.org/journals/features/psp7761121.pdf
aaron...@gmail.com
right click NEW in windows explorer.. create a new 'Access Application'
open it up by double-clicking
right-click import your spreadsheets
presto-chango you excel dorks are obsolete
aaron...@gmail.com
you don't use EXCEL AS ITS MEANT TO BE USED because
a) you use it for data entry
b) you can't normalize your data
c) you can't even enforce datatypes
the bottom line is that Excel wasn't DESIGNED to be used for ANYTHING.
it was designed to be a time-waster like Solitaire and Internet
Explorer.
Excel wasn't DESIGNED AT ALL-- it somehow evolved into the
spaghetti-code mess that it is today.
The root of the problem is that kids are taught Excel and they use it--
even though there are BETTER, EASIER tools on the market.
Excel is a DISEASE.
I SPIT on you lepers.
-Aaron
aaron...@gmail.com
great article Jay.
of course-- it is discussing you worthless Excel dorks that use Excel
for everything.. right?
because you don't know any better?
Jay Petrulis
aaron...@gmail.com wrote:
> great article Jay.
>
> of course-- it is discussing you worthless Excel dorks that use Excel
> for everything.. right?
>
> because you don't know any better?
>
What are you wearing today? Lemon juice? Apple juice? Orange?
Tomato? A smoothie?
Harlan Grove
>right click NEW in windows explorer.. create a new 'Access Application'
>
>open it up by double-clicking
>
>right-click import your spreadsheets
Yeah, that works so well with spreadsheets that aren't just collections
of simple tables. No doubt it exemplifies your standard work product.
Harlan Grove
>you don't use EXCEL AS ITS MEANT TO BE USED because
>
>a) you use it for data entry
And there are never entry errors in any database forms?
If one knows what one's doing (so not you), it's fairly easy to catch
glaring entry errors in Excel using formulas alone (better using event
handlers, but not absolutely necessary). It's impossible to catch
subtle entry errors, e.g., 536.89 entered when it should have been
563.89, in any program, Access no differently than Excel.
>b) you can't normalize your data
Normalization isn't necessary to USE data. Somehow scientific and
engineering software based on BLAS, LINPACK and EISPACK seems to manage
without normalized data structures. Why do you suppose that is?
>c) you can't even enforce datatypes
On entry, not without VBA, but it's simple to trap entry errors when
referring to entry cells and propagate error values and display
diagnostic messages. It may not be as elegant as database can manage,
but it's possible without much effort. You just have to know what
you're doing, which is why you can't figure it out.
>the bottom line is that Excel wasn't DESIGNED to be used for ANYTHING.
...
Well, nothing you could understand.
>even though there are BETTER, EASIER tools on the market.
So show us WITH DETAILS how these other tools are easier. Without
details, your assertions are no more believable than me just stating
that Basque is an easier language to learn than Aramaic. Maybe it's
true, but why would anyone believe it without any substantial reasons
to do so?
aaron...@gmail.com
She is in love with me because I'm a playboy billionaire database
developer-- think Larry Ellison-- whereas you're a nickel-bag idiot..
working in a gas station
-Aaron
ADP Nationalist
dbah...@hotmail.com
Harlan
most spreadsheets ARE simple tables.
of course you idiots mix subtotals into your DATA. lol.
Excel should be able to have FAKE ROWS in the middle.. so that you can
display subtotals... but when someone goes to import it; it doesn't
cause problems
-Aaron
Harlan Grove
>most spreadsheets ARE simple tables.
Maybe the ones you've seen, not the ones I've seen.
>of course you idiots mix subtotals into your DATA. lol.
Subtotals in tables are unwise, but subtotals in exhibits meant to be
printed are just what's expected from subtotals.
>Excel should be able to have FAKE ROWS in the middle.. so that you can
>display subtotals... but when someone goes to import it; it doesn't
>cause problems
If you had a clue how to use Excel, you could figure out how to remove
the subtotals. It's not that difficult, but no doubt way outside your
competence.
You should always check source files before importing. Arbitrary text
files would be just as unpredictible.
Your problem is that database tables are the only data structure you're
comfortable using, so your wee brain can only conceive of other data as
tables. When they're not, you need your meds.
Jay Petrulis
Harlan Grove wrote:
> ...When they're not, you need your meds.
Best taken with lemon juice.
dbah...@hotmail.com
HARLAN
THESE SIMPLIFIED DATABASE TABLES THAT YOUR TALKING ABOUT?
They're MORE POWERFUL than your baby spreadsheets.
I have worked with Excel for years and years and years.
And then I woke up and realized that it's impossible to submit a query
against 400 different spreadsheets.. so i took some classes and found
some pride.
Excel is for babies.
-Aaron
Jay Petrulis
Harlan Grove
>THESE SIMPLIFIED DATABASE TABLES THAT YOUR TALKING ABOUT?
>
>They're MORE POWERFUL than your baby spreadsheets.
Then it should be simple for you to show us how to take such simple and
powerful tables storing matrices and produce inverse matrices and
matrix products. Go on.
>I have worked with Excel for years and years and years.
And have never figured it out. Sad.
>And then I woke up and realized that it's impossible to submit a query
>against 400 different spreadsheets.. so i took some classes and found
>some pride.
Yes, and some toddlers take pride in piling up mounds of their own
excrement. For them reaching into their diapers is age-appropriate and
indicates some cleverness (even though it finds an unfortunate outlet).
You seem to take similar pride in the mounds of newsgroup excrement you
produce, but in your case it's not age-appropriate or a sign of
cleverness. As for your CLAIMED work product, you probably can't show
it to anyone other than your unfortunate clients. All you could show is
answers to questions posed in newsgroups, but you don't provide any as
a rule. Are you to scared, too lazy or too incompetent to answer
questions rather than rant?