Prev Previous Post   Next Post Next
  #1   Report Post  
kharrison
 
Posts: n/a
Default Sampling

I have multiple columns of data which consist of numeric and text. There are
15000 rows of which I wish to extract a sample of 2500 rows. When I use the
sampling feature it only gives me an extract of the first column of data
which is numeric. How can I get Excel to bring the rest of the data in the
other columns across with it.

If that is not possible, how do I then go about matching up the extracted
numerics with the numerics in the original range.

Regards
Kharrison
 
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



All times are GMT +1. The time now is 12:34 AM.

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"