Excel Tips & Tricks – Random Numbers Generator

September 14, 2022 by Billie D. Hardison

Have you ever needed to generate a list of random numbers? I do a lot of team-building events, and sometimes we want to do a random drawing. The random number generator is a helpful tool in Excel to perform this action.

If you want to generate a column of random numbers between 1 and 1000, enter the RAND formula and copy it down the column for each line item. The formula is =RAND()*(1-1000)+1000.

Note: The formula will change each time you make an update to your spreadsheet. If you want to keep the numbers you have generated, copy the numbers, then "paste special" the values.

We love feedback from our customers and implement suggestions often. What shortcut do you use the most? If you have a question or idea for a Microsoft Windows or an Excel tip that you would like to see, contact me, and I might feature it!

Billie Hardison
Director of Education & Training
BHardison@advocatecapital.com

About Billie D. Hardison

Billie Hardison is the Director of Operations at Advocate Capital, Inc. She joined Advocate Capital, Inc. in 2012 and has served many roles in finance, technology, and training. Over the years, Ms. Hardison has developed a deep understanding of the company’s proprietary software, AdvoTrac®. She is also proficient in QuickBooks, Intacct, Microsoft products, and many other software programs. Ms. Hardison is dedicated to assisting Advocate Capital clients in all areas of technology and training resources. She has recently joined the AdvoCap Insurance Solutions team, as well.

* In most jurisdictions, a law firm can recover finance charges related to funding case expenses from case awards, but the compliance requirements can be too expensive to implement. Only Advocate Capital, Inc. has the proprietary AdvoTrac^® expense tracking system and service team that allows firms to easily comply with allocation and reporting requirements. So, for example, if a firm recovers at least 90% of its advanced case expenses, like most of our clients, the annual net cost of funds is very small-typically less than 1%. Contact us to discuss how our program can work for your firm. All loans are subject to credit approval, and terms and conditions may vary.

Financial Services provided through Pinnacle Bank, a Tennessee Bank, which is a Member FDIC and Equal Housing Lender. Loans may be subject to credit approval.

About Billie D. Hardison

Are You an Existing Client?