Fill Inheritor Formula with airSlate SignNow

Fill successor formula

here i'm 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 i'll show you this trick for older versions of excel as well as newer versions of excel so let's 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 i'm going to get a different value and i want that 10 000 rows now that's a simple formula but it can be as complex as you want it to be and so now how do we get ten thousand rows well for new versions of excel just go equal and then sequence ten one two three close it up whatever number you want here that's what you put enter over here double click the bottom or right corner and now we have ten thousand values hit control down and there you go row ten thousand all the way down there now what if you want this on older versions of excel it is almost as easy go over here anywhere type one then on the home tab go all the way to the right this little guy over here phil and click series here we select columns for series in that means our list will go up and down inside of a column and then for step value set that at whatever increment you want for each cell one is fine for me and stop value how many values do you want well if we have a step value of one in order to get ten thousand rows i just type ten thousand hit ok and now i have a list of 10 000 over here so whatever formula i have i can just put right next to here and double click the bottom right of the cell and there we go 10 000 values now this is a very simple example with the choose function you can make things especially with dates amazingly complex and then at the end you say okay i want to make 120 000 randomly generated dates that are distributed evenly but within certain time periods which is something that i did...