"The twists and turns" Excel skill hundred example 02. Random Fill Data

First look at the following table:

Requirements Description:

1. In the "Zhang San, John Doe, Harry, Chen six, Liu Qi, Zhao Ba, Mr Michael Suen, Han ten" randomly select a name, fill in the Name column;

2. Randomly select a fraction in 60-100 to populate the fractional column.

I. About randomly populated numbers

This can all be known, using the Randbetween function, just set the value in the second column =randbetween (60,100)

The Choose function can be used for randomly filling Chinese characters.

Set the first column values =choose (Randbetween (1,8), "Zhang San", "John Doe", "Harry", "Chen Liu", "Liu Qi", "Zhao Ba", "Sun Nine", "Korean Ten")

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

"The twists and turns" Excel skill hundred example 02. Random Fill Data