Final Fantasy Hacktics

General => The Lounge => Topic started by: Dokurider on November 04, 2008, 06:23:59 pm

Title: Excel Question
Post by: Dokurider on November 04, 2008, 06:23:59 pm
Is it possible for me to multiple one row of numbers by another row of numbers and have the products generated in another row?
Title:
Post by: Lydyn on November 04, 2008, 06:28:27 pm
Yeah, though I forgot how to specifically. I'd have to mess with it for 5-10 minutes.
Title:
Post by: Skip Sandwich on November 04, 2008, 07:26:39 pm
do you mean like the colective sum of a row of numbers * the sum of another row of numbers? or do you mean something that would just spread out a long series of mulitplactions over the sheet? For the first, just list your numbers in your chosen rows, then go to the cells where you want the products to be displayed and just use the product function, =product(A1:E1, A2:E2) or whatever corordinates corespond to your rows of numbers. (each row seperated by a comma).
If you want to say, have just like A1 * A2 and so on and so forth, then just set up your rows, then in A3 or wherever you want the products to be displayed, type in =A1*A2 and then click on the cell, then drag the little black box in the bottom right over to the right, so that it copies that formula over for you, automatically changing it to reference the cells directly above the cells you drag over (so the cell B3 will become =B1*B2, and C3 will become =C1*C2 and so on)
Title:
Post by: Dokurider on November 05, 2008, 12:58:18 pm
Nevermind, I kinda got it. Maybe.

I'm thinking the stuff I'm trying to do with Excel is too complex for it to handle.
Title:
Post by: Zenko on November 05, 2008, 04:53:48 pm
mm I'd be surprised.

Excel is pretty powerful.

My main problems with it are the limits: 255 columns, 65535 rows, 32767 characters per slot.
Title:
Post by: Dokurider on November 05, 2008, 05:39:04 pm
Well, what I'm trying to is this:

I have a set of Co-ordinate Pairs: (0,0), (0,1), (1,0), (1,1), (0,2), (2,0), (2,2) (0,3) and (3,0)
I want them in groups of 5, repeating doesn't matter. Order matters. And, I want all the possible permutations to be generated for me to see. How do I do this?
Title:
Post by: Zenko on November 05, 2008, 06:11:38 pm
I suppose a drawing in mspaint or something would be appeciated because all I can think of right now is that it would somehow look like a multiplication table.
Title:
Post by: Archael on November 05, 2008, 06:23:42 pm
65535 row limit?


are you serious?
Title:
Post by: Dokurider on November 05, 2008, 06:39:21 pm
How about we pretend they are letters instead?

A B C

I want them arranged in groups of 5.

AAAAA
AAAAB
AAABA
AAABB
AABAA
AABBA
AABBB
ABAAA
ABBAA
ABBBA
ABBBB
BAAAA
BBAAA
BBBAA
BBBBA
BBBBB

That's what I want. Get it?
Title:
Post by: Zenko on November 05, 2008, 06:56:43 pm
you're aware there are 59049 possibilities right?

I'm working on it though
Title:
Post by: Dokurider on November 05, 2008, 06:59:21 pm
I'm not afraid. My passion will pull me through.
Title:
Post by: Zenko on November 05, 2008, 07:23:12 pm
Here, I'm pretty sure that's what you wanted.
Title:
Post by: Dokurider on November 05, 2008, 07:24:42 pm
Thanks.
Title:
Post by: Zenko on November 05, 2008, 07:25:14 pm
Took some time to upload, even in .rar....

I used pretty advanced stuff for excel and I really doubt much excel users could do this kind of stuff.