When you want to apply a small tweak to the document, it must not take long to Fill formula paper. This type of basic action does not have to require additional training or running through guides to understand it. With the proper document modifying resource, you will not spend more time than is necessary for such a swift edit. Use DocHub to simplify your modifying process whether you are an experienced user or if it is your first time making use of an online editor service. This instrument will take minutes or so to learn to Fill formula paper. The sole thing needed to get more effective with editing is a DocHub profile.
A plain document editor like DocHub can help you optimize the time you need to spend on document modifying no matter your prior experience with this kind of instruments. Create an account now and enhance your productivity immediately with DocHub!
here im going to show you how to instantly fill text and formulas numbers whatever you want for tens of thousands of rows hundreds of thousands of rows instantly and ill show you this trick for older versions of excel as well as newer versions of excel so lets say that you are building a list of data i use this a lot for random data to choose function it is great first argument let us skip that for now but the next series of arguments is what you want to output so i want to output how about the days of the week so monday tuesday wednesday thursday and friday and each time this formula runs i want to get a different value for this for a very large list so i go up here to the first argument for the index number which says which value to return and i put the rand between function a great function for bottom one and for top the number of values that you have here so i have 5 close that up hit enter and now when i hit f9 and refresh it im going to get a different value and i want that