Is it possible for me to multiple one row of numbers by another row of numbers and have the products generated in another row?
Yeah, though I forgot how to specifically. I'd have to mess with it for 5-10 minutes.
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)
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.
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.
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?
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.
65535 row limit?
are you serious?
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?
you're aware there are 59049 possibilities right?
I'm working on it though
I'm not afraid. My passion will pull me through.
Here, I'm pretty sure that's what you wanted.
Thanks.
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.