Formula for picking data from cell series

[REDPOOL]

Hello. I have an excel sheet that pulls in a bunch of data from a website.
I would like to summarize the data into a table.
The cells with the data that I need start at cell A91, and every 13th cell afterwards (A91, A104, A117, ect).
I want the cell data from A91 to go into B1, cell data from A104 into B2, ect, for my table.
How can I complete this without manually typing it in?
Thanks in advance.
-REDPOOL

[Pete_UK]

Put this formula in B1:

=INDEX(A:A,(ROWS($1:1)-1)*13+91)

then copy down.

Hope this helps.

Pete

[Ace_XL]

Try in B1

=INDEX(A:A,(ROW(A1)-1)*13+91)

Copy down

[Pete_UK]

For some reason, neither of these replies are showing in the New Posts list, nor on my UserCP.

Pete

EDIT: Ah, they are now - sometimes it needs a kick ...

[REDPOOL]

Works perfectly! Thank you!

[arlu1201]

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.

[pakman5k]

Dear I have problem in my formula
it show its left row correct but when I move to 1st next right it also show the value of the 1st left row
=IFERROR(IF(ROWS(A$12:A12)>$C$3,"",INDEX(Master!$A$2:$A$1200,SMALL(IF(Master!$A$2:$A$1200>=$D$5,IF((Master!$A$2:$A$1200<=$D$3)*(Master!$I$2:$I$1200>=$B$3),ROW(Master!$A$2:$A$1200)-ROW(Master!A$2)+1)),ROWS(A$12:A12)))),"")
Master -> A2:A1200 is may data
Summary is my query and need to get the result start form A12


can you send me your e-mail so send excel to check the problem