Search : in
By :

Excel row removal/selection

Last answer on May 21, 2009 6:26:31 pm BST kateo, on Jul 14, 2008 3:54:15 pm BST 
 Report this message to moderators

Hello,
I am trying to select certain rows from a very large data sheet. Ideally I would like to select every 25th row so as to get a random sample of data.
I've tried filters, row functions & formulas but nothing seems to work.
I'd appreciate any suggestions.
Many thanks,
KO

Configuration: Excel 2003
Windows XP
Internet Explorer 7.0

Best answers for « Excel row removal/selection » in :
Delete duplicates in an Excel column Show Delete duplicates in an Excel column To remove duplicates in an Excel column: Click on the Data menu Filter Advanced Filter In this menu, select the column where the duplicates Check the box "Extract without duplication"...
Delete all rows except first and last row Show
Select a subset of cells within a row (Solved) Show
How to freeze a row in an excel sheet ShowHow to freeze a row in an excel sheet To freeze a line in an excel sheet, for example line 1: Select line 2. Go to menu Window and select Freeze panes.
Removing the welcome logo when starting Windows XP ShowRemoving the welcome logo when starting Windows XP Here is a simple tip on how removing the XP logo and speeding up Windows XP booting time. 1.Select My Computer icon and right click on it. 2.On the menu select the Properties...
How to remove Hyperlink on copied text from website? ShowHow to remove Hyperlink on copied text from website? When copying information on website, obviously the hyperlink from the text will also appear on the edited text. To remove the hyperlink from the text, you need to right on the designated...
Download Excel Password Recovery Master Show
Download Office Password Remover Show
Download Removable Media Undelete Tool ShowRemovable Media Undelete Tool is a data recovery utility to find Microsoft Office documents that you have removed accidentally or not. You can restore documents created with Word, Excel, Access or PowerPoint. It provides easy and step by step...
Spreadsheets - Cell Selection ShowCell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. Line Selection An entire line can be chosen by clicking directly on the line...
Ask your question Reply

1

Ivan-hoe, on Jul 14, 2008 9:39:42 pm BST
  • +4

Hello,
I do not think there is any solution with filters ; using formulas would be quite complicated. I suggest you use the macro below, which selects every 25th row from row 2. 

Sub Kateo()
    Dim MyRange As Range, i As Integer
    Set MyRange = Rows(2)
    For i = MyRange.Row To Cells(Rows.Count, "A").End(xlUp).Row Step 25
        Set MyRange = Union(MyRange, Rows(i))
    Next i
    MyRange.Select
End Sub

Ivan

   
Reply to Ivan-hoe

2

Eccu, on Nov 10, 2008 7:53:44 am GMT
  • +1

I've got a frustrating Excel Vba question (I've fought with this one for a while).

I'm trying to group values of column 2 based on column 4 values on sheet A (distinct values from column 4 - matching values from column 2).

These found values should be concatenated on sheet B according to the same column 4 value.

Any suggestions?

Thanks, Elja

   
Reply to Eccu

3

 Smbaumer, on May 21, 2009 6:26:31 pm BST

Do you know how you would alter that so it would select cells in column A only, instead of the whole row?

   
Reply to Smbaumer
Ask your question Reply
They need your help