Extract random data automatically

[@erixon2012]

Thanks for the tutorial mate. I've been looking for this solution for days. There isn't a single text tutorial online that explains such a simple thing. Choosing a random value from a row is so simple yet only here I discovered how to do it thanks to you.

[@gohshuwen5957]

Thank you for such a good video! Helped me save SO MUCH TIME for my college project! Much love from Malaysia❤

[@FredericLEGUEN-Excel]

You're welcome 😊 Where in Malaysia? I'm at Bali

[@babybee9098]

You are so relaxing . This would be what I needed but the names and hospitals in my cell are combined and I need to separate the names from the hospitals

[@OzduSoleilDATA]

Very good, thorough lesson. And thanks for the shout-out!

[@entertainmentgalaxy971]

beautiful video . thanks both of u for sharing amazing trick

[@shubhthorat]

Is there a way to only extract the values for a country without using an ascending or descending before hand. So selecting the country’s example “USA” and only finding the clients from there?

[@FredericLEGUEN-Excel]

You mean Filter?

[@shubhthorat]

@@FredericLEGUEN-Excel yeah a way to extract the values for a country without using filter previously

[@FredericLEGUEN-Excel]

@@shubhthorat Not possible.

[@chrisoli7751]

I'm curious. Can I use a master sheet with data and link that data to go into multiple sheets? I run a 24 team baseball league and use excel for all data. Each team has a tab for it's players and salary. I wanted to use a master sheet with all the players and the players salary and link that to all the 24 team tabs. So if a trade occurs I could just switch the teams in the master sheet and it will then automatically swap those players in the individual team tabs

[@FredericLEGUEN-Excel]

I have no idea. This is a real dashboard project. Impossible to reply to such question

[@repentanceandholines]

very helpful. thanks for sharing

[@stans1317]

Is there any way I can automate extracting recurring monthly bills (I.e utility) on the utility providers website into a spreadsheet?

[@kasunnimsara7371]

Thanks mate❤

[@FredericLEGUEN-Excel]

You're welcome 😉

[@navneetbajpai3601]

Is this method applicable for ms office 2016

[@FredericLEGUEN-Excel]

Sure. This technique works for all versions of Excel

[@imtirafat]

Tried several times, all I get is a 0 (zero). Not helpful at all.

[@usmaniqbal1836]

Share link to download file for practice.

[@akashalfred1]

Not helpful the way it's in the video is not the same when we do it ourselves.

[@FredericLEGUEN-Excel]

Of course because it depends of the random number generated. It's never the same

[@akashalfred1]

@@FredericLEGUEN-Excel when i click on the source and move to the extract sheet it changes and then the command doesn't work.