LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bbb bbb is offline
external usenet poster
 
Posts: 8
Default How can i randomly select 780 rows from 4000 rows of data

In Excel i have a spreadsheet with 4000 rows of data and would like to
randomly select a list of 780 rows showing only one cell of the data?
 
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
Select certain data rows lee's news New Users to Excel 2 December 19th 06 09:19 PM
Sometimes data will jump rows randomly. Jason Excel Discussion (Misc queries) 1 April 11th 06 08:34 PM
Is there a way to randomly select rows in Excel? Samantha Excel Discussion (Misc queries) 4 May 12th 05 02:59 PM
How do I select multiple rows randomly in MS Excel? Varun Excel Discussion (Misc queries) 2 April 18th 05 08:10 AM
Unable to select rows in the repeat rows on top option Noppie Excel Discussion (Misc queries) 2 December 28th 04 03:17 PM


All times are GMT +1. The time now is 09:12 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"