Double-check Data In Excel
- Sean O'Shea
- Sep 9, 2015
- 1 min read
If you need to randomly check the accuracy of data in an index created in Excel against the original data source, use the RAND formula. Add a new column to the left; type in =RAND() and press CTRL + D to pull down the formula for each row in your index. Random numbers will be generated automatically. Sort the entire spreadsheet by the new column, and review a representative sample.

Recent Posts
See AllHow is data generated by aiR utilized by Relativity? Relativity has published a white paper addressing its AI security policies assuring...