• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

quick excel question...

D

Dubb

Platinum Member
basically, I have a sheet with about 1200 rows in it. I need the data from every 13th row (row 1, row 13, etc), and collapsed down so that row 13 becomes row 2 and so on.

so I either need a way to delete the rows I don't want, or select and copy what I do.

Anybody?

it's 11 pm on a saturday night, and I'm doing work. Help me out.
 
Originally posted by: MartyMcFly3
cant you just hide the rows?
Click to expand...

Unless you know something about hiding that I don't (which is possible), that would still require alot of shift/ctrl selecting of the rows to hide, no?
 
Originally posted by: Dubb
Originally posted by: MartyMcFly3
cant you just hide the rows?
Click to expand...

Unless you know something about hiding that I don't (which is possible), that would still require alot of shift/ctrl selecting of the rows to hide, no?
Click to expand...

Yeah but it solves your problem. Not the most efficient way of doing it but it IS a solution.
 
thing is, then I might as well just ctrl-select the rows I want and copy/paste them.

such a thing would be both time and sanity prohibitive.
 
I don't know the "right" way to do this but I know plenty of creative ways. Does the data all need to stay in the order it's currently sorted in?
 
is the data on any of the cells on row 13 disticnt?

if so you can use data filter, then choose the column, then filter only to that distinct data
 
Does putting the word "quick" in the thread's title increase the number, improve the quality or rapidity of the responses?
 
Originally posted by: z0mb13
is the data on any of the cells on row 13 disticnt?

if so you can use data filter, then choose the column, then filter only to that distinct data
Click to expand...

Or add a column to the far right that counts from 1-13 and repeats all the way down, then filter just "13" from that column. That'll do it.
 
Originally posted by: HotChic
Originally posted by: z0mb13
is the data on any of the cells on row 13 disticnt?

if so you can use data filter, then choose the column, then filter only to that distinct data
Click to expand...

Or add a column to the far right that counts from 1-13 and repeats all the way down, then filter just "13" from that column. That'll do it.
Click to expand...

Ding ding ding! even better
 
Originally posted by: HotChic
Originally posted by: z0mb13
is the data on any of the cells on row 13 disticnt?

if so you can use data filter, then choose the column, then filter only to that distinct data
Click to expand...

Or add a column to the far right that counts from 1-13 and repeats all the way down, then filter just "13" from that column. That'll do it.
Click to expand...

WINNAR!!!!
 
Record a macro with you completing the desired task for the first few rows. Edit the macro with a for-loop to do the rest of the rows.
 
Public Sub ColumnFilter()
Dim i As Long, wrk As Worksheet
Set wrk = ActiveSheet
i = 1
With wrk
do while I < 5000
.Cells(i, "G").Value = "Yes"
if i = 1 then
i = i - 1
End If
i = i + 13
Loop
End With
End Sub

Copy the above into the excel VB editor. change the 5000 to however many cells you have. Change the "G" to whatever blank column. When the macro finishes, create a filter on the column, and filter for "Yes"
 
Originally posted by: Siddhartha
Does putting the word "quick" in the thread's title increase the number, improve the quality or rapidity of the responses?
Click to expand...

by quick I meant that it should be easy for someone to answer, provided they know a little more about excel and are slightly less brain fried than I.
 
Originally posted by: z0mb13
Originally posted by: HotChic
Originally posted by: z0mb13
is the data on any of the cells on row 13 disticnt?

if so you can use data filter, then choose the column, then filter only to that distinct data
Click to expand...

Or add a column to the far right that counts from 1-13 and repeats all the way down, then filter just "13" from that column. That'll do it.
Click to expand...

Ding ding ding! even better
Click to expand...

actually, one of the columns is empty except on the rows I need. Using the filter > sort decending seems to do just fine.

Thanks all for the responses!
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top