LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default How you decimate data using EXCEl (i.e., remove every second or t.

I have a data file (over 9000 rows and 10 columns worth of data), and I would
like to remove every fifth row to reduce the amount of data. How do i
accomplish this?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
decimate rows in Excel 2007 Alistair Excel Discussion (Misc queries) 3 September 30th 11 11:15 PM
How do I remove data in a row in excel without losing all data in lindad Excel Worksheet Functions 1 April 29th 10 07:18 PM
How do I remove the text qualifier (') from my data in Excel? Robert HAI Excel Discussion (Misc queries) 0 October 30th 06 06:05 PM
how do I remove repeated data in excel S. Virgile Excel Worksheet Functions 1 June 27th 06 06:00 PM
Excel 97-remove link but keep data Van Excel Discussion (Misc queries) 3 January 12th 06 08:04 PM


All times are GMT +1. The time now is 07:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"