# Thread: Formula to extract rows from worksheet

1. ## Formula to extract rows from worksheet

I have a spreadsheet that is updated constantly. Each time it is updated, I need to put a copy out for the employees that does not have any gaps in it. I have attached the spreadsheet. I'm looking for a formula that would only give me Rows 14-18, 20, 22-23, 25, 32-35, 37-41, 43-49, etc. Of course these rows will be different all the time. Just trying to show you the rows I need so you can see the pattern.

I would really appreciate some help with this.

Thanks,
Kim

2. Perhaps something like this? Using array formula.........

3. Risky - thanks! Still need a little assistance. I'm trying to put the extracted files on a 2nd sheet. I adapted your formula to look like this...

=IFERROR(INDEX(Section!A\$2:Section!A\$69,SMALL(IF((Section!\$C\$2:Section!\$C\$69<>"")*(Section!\$I\$2:Section!\$I\$69<>""),ROW(Section!A\$2:Section!A\$69)-ROW(Section!A\$2)+1),ROWS(Section!\$A\$1))),"")

Section is the first worksheet and Extract is the second worksheet that I am placing this formula in. Where did I go wrong?

Thanks

4. Here the step:
1. select on M2 on Sheet Section and press F2 button, you'll see the formula inside cell, after that jysr select the formula and copy, you can just press CTRL-S
2.Go to the second sheet, select A2, and paste the formula or just press CTRL+V
3. Press F2 button again, and you need to be sure press all together CTRL+SHIFT+ENTER button, ENTER alone don't work
4. Final is copied down and cross as necessary

Hope this helps

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•