Need To Refer To Alternate Rows

**unpluggedmusic** · 10-14-2012, 09:14 AM

Dear all,

I have a list few-hundred long, filled with unwanted rows. This is a common problem when I had to copy large amounts of info from webpages. I want to manage this long list using a separate sheet, but I have to remove the alternate unwanted rows by doing : =A1, =A3, =A5, etc.

The list is few-hundred long and I cannot do this forever. Is there a formula so I can drag it and drop it? I have attached a sample copy of my problem.

Thanks guys.

**Jakobshavn** · 10-14-2012, 11:18 AM

=indirect("a" & rows($1:1)*2-1)

**TMS** · 10-14-2012, 11:37 AM

Try:

=INDIRECT("'Pasted From Webpage'!" &LEFT(ADDRESS(1,COLUMN(A1)),FIND("$",ADDRESS(1,COLUMN(A1)),2)-1)&ROWS($1:2)*2)

Copy down and across.

Regards, TMS

**unpluggedmusic** · 10-14-2012, 11:39 AM

Thanks guys!! works like magic!

**TMS** · 10-14-2012, 11:44 AM

You have two solutions. Which one "worked like magic"?

Regards, TMS

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save