[Solved] Picking variable Parts of Columns to make new one

Kapa150 · Post by **Kapa150** » Tue May 05, 2020 5:46 pm

Hi Everybody,

i don't know if this is even possible, but i thought i'd ask since people in this forum have been very helpful before!

i have a couple of columns with coordinate values (several columns for x coord, and several for y coord) and i want to pick out the first n (this is a variable that changes) number of each column and add them to a new column.

in the attachment you can see what i mean. the values that are supposed to be at the top of the colums are the values in J-M (that's not an issue because here the n doesn't change) but then the values following them (values from R-AK) have to be below them (and only the highlighted ones! and again, if n changes, others get hightlighted. n is in Q2). the end result should look like the columns A and B (only if i change n, it should change the number of x and y coords listed. currently n=4, so it shows 4 of each colum)

does anyone know how to do that?

thx

jrkrideau · Post by **jrkrideau** » Tue May 05, 2020 7:31 pm

Cn you explain in substantive terms what you are doing? It is probably possible to do what you want. Though not by me!

After looking at the sheet for a little while I get the feeling that the layout is far too complicated. It looks like the layout that makes sense to a human and not to a spreadsheet

So if you can give us a good description of what the data is and what output you want, we may be able to make some suggestions

Kapa150 · Post by **Kapa150** » Tue May 05, 2020 8:52 pm

thx for the response, sure i can explain.
it draws a star. the two circles (J, K are the x and y coords for the inner circle, L, M are the coords for the outer circle) and R+AK are the lines connecting the inner dots with the outer ones (forming a star). it's also rotatable (P2 is the rotation is radiants). you can plot the A and B coords as an XY Diagram if you wanna check it out. (further to the right, there is another star, a pentagram, that works in a similar way)
the reason i wanna have them in a column is for convenience (so i can see them all in one place) and so it can put them in the form that i want them more easily (see D5 downwards to check out the form that i want them in).
now please don't misunderstand, i'm not looking for other ways of getting the coords in the form (D5 downwards), i'm sure there is some other way, but i am specifically interested in whether what i asked in the original post is possible. namely picking n number of the coords and arranging them in a column for x and y respectively.

i hope that clears things up. if not feel free to ask for more clarifications
cheers,

(PS: it looks complicated because i don't know what i'm doing

i improvised the thing so it's not as clean as it could be i'm sure xD. but i wanna build on it, and NOT change it fundamentally)

Post by **MrProgrammer** » Tue May 05, 2020 9:00 pm

Kapa150 wrote:i have a couple of columns with coordinate values (several columns for x coord, and several for y coord) and i want to pick out the first n (this is a variable that changes) number of each column and add them to a new column.

It would help if you would just state that the mysterious n is the value of cell Q2 instead of making us dig for that. Examine the formulas in A12:B12 and below. Read about functions you are not familiar with.

202005051332.ods: (39.77 KiB) Downloaded 121 times

Edit: I see that [Solved] Changing Color of n Fields is a similar question from the OP.

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

Kapa150 · Post by **Kapa150** » Tue May 05, 2020 9:03 pm

"It would help if you would just state that the mysterious n is the value of cell Q2 instead of making us dig for that." MrProgrammer
i did, in the original post "n is in Q2"
i can even tell you what it is, if you're interested, it's the number of points inbetween the inner and outer circler (for the first star)

Kapa150 · Post by **Kapa150** » Tue May 05, 2020 9:07 pm

i just realized that your profile pic has a pentagram in it. the second star (if you scroll to the right, is a pentagram)

Draw A0, AP from 7 to 61 as an XY diagram if you wanna check it out

(it also rotates if you change the value in P2 (enter the rotation in radiants)

cheers,

Kapa150 · Post by **Kapa150** » Tue May 05, 2020 9:11 pm

i just checked out your solution to my question MrProgrammer. and it seems to do what i asked, but if you draw the star after increasing n, the star is wrong. maybe that's a problem with my spreadsheet tho, i'll have to look into that

Kapa150 · Post by **Kapa150** » Tue May 05, 2020 9:15 pm

oh, it's just because oyu removed the references, nvm

thx for the quick response! i tried it in my spreadsheet and it works! Now all that's left to do, is try to figure out that all those commands mean xD

ty

[Solved] Picking variable Parts of Columns to make new one

[Solved] Picking variable Parts of Columns to make new one

Re: Picking variable Parts of Columns and making a new one

Re: Picking variable Parts of Columns and making a new one

Re: Picking variable Parts of Columns and making a new one

Re: Picking variable Parts of Columns and making a new one

Re: Picking variable Parts of Columns and making a new one

Re: Picking variable Parts of Columns and making a new one

Re: Picking variable Parts of Columns and making a new one