Purge Key Generator Microsoft Excel?
Microsoft excel? - purge key generator
What key is used as a purge key if you 22,000 points and you want information about cleaning using 400 or 500 points at random with the help of Excel, if inter -
|
Subscribe to:
Post Comments (Atom)
2 comments:
It appears that you delete rows at random from Excel spreadsheet. One way to do that is to achieve this, a column next to your data, and with = rand () as the formula cell. Backing him completely, and thus generate a random number between 0 and 1 Then you can use a filter automatic filter, for example, about 0.1. This gives you a great majority of the figures. After deleting everything that appears, and remove the filter. They are data on 10% less than you started. To learn more, remove the filter to something less than .05, less than .01.
I am the wizard of Excel and want to help but do not underestimate the question, please contact me with information that is false, and I'll send the solution as quickly as possible.
Post a Comment