Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rows
I have a worksheet with 716 rows and I need to chose every 17th row. I am
very new to excel please help me... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rows
You already have an active thread open
on that question(with the subject "Filter"). Posting duplicate questions just causes confusion and annoyance. -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Deborah" wrote in message ... I have a worksheet with 716 rows and I need to chose every 17th row. I am very new to excel please help me... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rows
Here is a very simple method using AutoFilter. In an un-used column, enter:
=IF(MOD(ROW(),17)=0,"X","") and copy down The column will be blank except for rows 17, 34, etc.... Apply Autofilter to this column to hide the other rows. -- Gary''s Student - gsnu200772 "Deborah" wrote: I have a worksheet with 716 rows and I need to chose every 17th row. I am very new to excel please help me... |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rows
I apologize for that. I didn't make myself clear that I am very unfamiliar
and the response I got I could not understand. Again I apogize for any confusion I caused you. "Ron Coderre" wrote: You already have an active thread open on that question(with the subject "Filter"). Posting duplicate questions just causes confusion and annoyance. -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Deborah" wrote in message ... I have a worksheet with 716 rows and I need to chose every 17th row. I am very new to excel please help me... |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rows
Thank you I hope I was not a bother or annoyance to you as the other person
posted. "Gary''s Student" wrote: Here is a very simple method using AutoFilter. In an un-used column, enter: =IF(MOD(ROW(),17)=0,"X","") and copy down The column will be blank except for rows 17, 34, etc.... Apply Autofilter to this column to hide the other rows. -- Gary''s Student - gsnu200772 "Deborah" wrote: I have a worksheet with 716 rows and I need to chose every 17th row. I am very new to excel please help me... |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rows
Why do you want to choose these rows is a question that has not yet been asked.
Perhaps you don't have to choose them to work with them. Gord Dibben MS Excel MVP On Fri, 7 Mar 2008 07:31:04 -0800, Deborah wrote: Thank you I hope I was not a bother or annoyance to you as the other person posted. "Gary''s Student" wrote: Here is a very simple method using AutoFilter. In an un-used column, enter: =IF(MOD(ROW(),17)=0,"X","") and copy down The column will be blank except for rows 17, 34, etc.... Apply Autofilter to this column to hide the other rows. -- Gary''s Student - gsnu200772 "Deborah" wrote: I have a worksheet with 716 rows and I need to chose every 17th row. I am very new to excel please help me... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy rows of data (eliminating blank rows) from fixed layout | Excel Discussion (Misc queries) | |||
Cut filtered rows, paste into next empty row of new sheet, and delete cut rows | Excel Worksheet Functions | |||
Excel 2003 -Rows hidden. Scrolling unhides rows ! How do I stop th | Excel Discussion (Misc queries) | |||
Pivot Tables: How do I show ALL field rows, including empty rows?? | Excel Worksheet Functions | |||
Can Excel "slide up" rows with content thru empty rows to condense | Excel Worksheet Functions |