Hi guys,
easy question. im maiking statistics and i need to get information from cell A6, A12, A18....
When i fiill to first line =A6
second =A12
3rd = A18
when i "strectch it" i wont fill to 4th line =A24, but illogicly =A9 on 5th =A10...
How can i fill me neede information?
P.S.: Sry guys for my bad englando.. :D
assuming your data is in column A and you want that formula to work in Column B
then use in B1 below formula
=INDEX(A:A,ROWS($A$1:A1)*6) and drag down then B1 will have A6's value B2 will have A12's value and so on
if you want to have B1 = A6 value then C1 = A12 value, D1=A18 value then use below
=INDEX($A:$A,COLUMNS($A$1:A1)*6) and drag to right
Last edited by hemesh; 01-28-2016 at 11:47 AM.
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
Im sure that i want first version. But when i want select data from different page, so first will be:
1st : =údaje!G6
2nd : =údaje!G12
So = INDEX(údaje!G:údaje!G, ROWS(údaje!$G$1:údaje!$G$1)*6)
becouse it is not working for me.. ^^ I need to use it many times a i need to understand it..
= INDEX(údaje!G:údaje!G, ROWS(údaje!$G$1:údaje!$G1)*6) try this
i have removed red part in above formula
= INDEX(údaje!G:údaje!G, ROWS(údaje!$G$1:údaje!$G$1)*6)
I don't know the language but I think that this is the equivalent of the formula given by hemesh.
Formula:
Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
it looks i have to use ";" intead of ",", but i looks like it has to have 3 parts =INDEX(field; row; [colomn])
as you are using only one parameter such as column G, this will work.
In case you are using a matrix such as 5 rows and 5 columns i.e. A1:D5 then you need to supply rows and columns both to fetch data from Specific row and column
in that case =index(A1:D5,2,3) will give you data from second row and third column.
You can just change commas "," to semicolons ";" to make formula work in your case which is provided post#4 or post #5
Guys, it isnt working.. here is link to my doc - http://leteckaposta.cz/384737604
Can u please fill it on page 2? As i said ill need to implement it like 20 times..
May be you need to change "," to ";"
formula is in column C in sheet 2
Ahhh maybe it doesnt work due to language..
You are welcome ! I forgot truly about language part.
Maybe this is what will work
Formula:Please Login or Register to view this content.
And guys, if i want to select f.e. A5, A11, A17..?
This will extract A5, A11, A17 etc as you fill down the column. This formula assumes the data is in column A and you are extracting to column B. If you are extracting to a different location change the "B" references to the starting references that you are using including the row number so if you are starting in F4 for example change the B1 to F4.
Formula:Please Login or Register to view this content.
I don't know if you need a ; or a , after A:A choose what you need.
How about
=index(A:A,(ROWS($A$1:A1)*6)-1)
Thats clever i have to try it..:D
@ Mihelherbiii ! Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks