Selecting only every first of third row in column

[Keg65]

I've just started a new job today, and it seems as if everything that can go wrong has. Nothing that's really my fault but because of it all I was hoping to prove how reliable I can be by not buckling under this pressure.
Well basically I was hoping someone could aid me in figuring out how to select every first of three rows in a column on Microsoft excel.

To help you further understand my situation, it's basically that they gave me an excel spreadsheet with the first rows containing the name of a school and the second and third containing addresses. I would only need every first of three rows.

I'd really appreciated the help.

Erik

 

[Jeff Meyers]

A quick and easy suggestion: Use a helper column (to the left or right of your data) and fill it down with the repeating series 1 2 3. Then sort on this column in ascending order. All of your "1's" will be at the top giving the first of every three row grouping.

 

[Jeff Meyers]

And oops - forgot to say welcome to the Mr Excel message board!

 

[Trevor G]

Welcome to the Forum Erik,

Lets look at an example

Excel Workbook
	A
1	School Details
2	Kings School
3	Address1
4	Address2
5	Lions School
6	Address1
7	Address2
Sheet1

Then on sheet 2 I have added the following formula then dragged down

Excel Workbook
	A
1	School Names
2	Kings School
3	Lions School
Sheet2

 

[mathchick]

wow, what an awesome and simple solution! I was trying to work out something with a formula.

Keg65 -- welcome to the forum and good luck with the new job.

 

[Keg65]

Thank you I really appreciate it, and the immediate response. I will try this as soon as my computer starts... it's been running updates for the past two hours.

 

[Keg65]

Well my first day went so much better once the computer finally started. I ended up using the simpler solution rather than the formula (which even I thought I'd need) and got the work done in no time. Anyways, before I get back to work I simply wanted to thank you guys again for all the help.

Erik

 

[Jeff Meyers]

Glad it worked out for you. Thank you for the feedback. Good luck with the new job.