Excell Question

[djbeenie]

On excel - tools - data analysis ... I have a worksheet that I want to select a 10% sample from. So I go under the aforementioned steps and select sampling. Then I will select the number equaling ten percent and the information is put onto another worksheet. The problem is that it only carries over the information in column A and does not transfer the data associated with the selected row (even though the whole worksheet is highlighted?). Any ideas...


dj beenie

http://www.eternal-rhythms.com

 

[Zathras]

Use the sample add-in function to retrieve only keys (or row numbers - see below) from one column. Then...

Arrange the data such that column A contains unique keys, then use VLOOKUP or MATCH functions to retrieve data from any additional columns you need.

Alternatively, arrange the data such that column A contains row numbers, then use the INDEX function to retrieve data from any additional columns you need.

If you don't or can't put row numbers in column A, you can combine the techniques by using MATCH to put the source row number next to the sample key and then use that with the INDEX function to retrieve the extra column data.

 

[Zathras]

Another possibility is to add a column to the main database and use MATCH or VLOOKUP to see whether the key is in the sample and then use an auto data filter to select those rows which have a match.

 

[djbeenie]

Thank you so much for your input!

dj beenie

http://www.eternal-rhythms.com