Select Random Sample Values and Rows using Excel

No video

Select Random Sample Values and Rows using Excel

Рет қаралды 87,416

Күн бұрын

In this video you'll learn how to pull random values and random rows from your Excel data using a simple but effective combination of functions. We'll specifically touch upon the ROWS, RANDBETWEEN, INDEX and RAND functions.
★☆★ Join this channel to get access to perks: ★☆★
/ @anthonysmoak
★☆★ SUPPORT THIS CHANNEL: ★☆★
shop.spreadshi...
★☆★ FOLLOW ME BELOW: ★☆★
Blog ► anthonysmoak.com/
Twitter ► / anthonysmoak
Facebook ► / anthonybsmoak
Tableau Public ► public.tableau...
#Excel #data #analytics #data #dataanalyst #education #onlinelearning

Пікірлер: 19

@LocoCioco 4 жыл бұрын

thank you for sharing your knowledge in such a simple and elegant way

@AnthonySmoak 4 жыл бұрын

Thanks for the great feedback!

@ccat0014 4 жыл бұрын

thanks a lot. I was frustrating on how to choose random data for my assignment.

@TracyBondBird 4 жыл бұрын

This is really helpful!

@nsanerydah 2 жыл бұрын

Man that is amazing stuff! Great job!

@AnthonySmoak 2 жыл бұрын

Thank you!!

@keys4words 3 жыл бұрын

Thanks!

@AnthonySmoak 3 жыл бұрын

Glad you found the video useful!

@WaterBuffaloTM 3 жыл бұрын

Hey brother thanks so much! We would love to have you on our podcast!

@antonrinaldo971 4 жыл бұрын

Lifesaver!

@taradavis2120 4 жыл бұрын

Is there a way to do this to keep the array dynamic? My list of data will have more or less values added to it so I can't have a specified array like in the formula you use but I still need to randomly select values from my specified data :INDEX(Calculations!$F$53:$F58,RANDBETWEEN(1, ROWS(Calculations!$F$53:$F58)),1)

@joeyjarina 3 жыл бұрын

Is it possible that instead of the specific random number, it will show a specific data corresponds to that random number. For example, I want 3 sample calls per agent to listen for my audit from a raw data. In that data, there are master IDs which I can use to pull up the call. In a day, there’s a lot and different master ID per call and chat. Now, instead of a random number, I want the master ID to show on my file.

@AnthonySmoak 3 жыл бұрын

Try to use a VLOOKUP with RANDBETWEEN as your first argument. The assumption is that your master ID is a number that can be generated with RANDBETWEEN and is associated with the data values you need to lookup.