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.
@gohshuwen595710 ай бұрын
Thank you for such a good video! Helped me save SO MUCH TIME for my college project! Much love from Malaysia❤
@FredericLEGUEN-Excel10 ай бұрын
You're welcome 😊 Where in Malaysia? I'm at Bali
@babybee90983 жыл бұрын
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
@OzduSoleilDATA6 жыл бұрын
Very good, thorough lesson. And thanks for the shout-out!
@entertainmentgalaxy9716 жыл бұрын
beautiful video . thanks both of u for sharing amazing trick
@shubhthorat3 жыл бұрын
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-Excel3 жыл бұрын
You mean Filter?
@shubhthorat3 жыл бұрын
@@FredericLEGUEN-Excel yeah a way to extract the values for a country without using filter previously
@FredericLEGUEN-Excel3 жыл бұрын
@@shubhthorat Not possible.
@chrisoli77512 жыл бұрын
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-Excel2 жыл бұрын
I have no idea. This is a real dashboard project. Impossible to reply to such question
@repentanceandholines5 жыл бұрын
very helpful. thanks for sharing
@stans13174 жыл бұрын
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 😉
@navneetbajpai36013 жыл бұрын
Is this method applicable for ms office 2016
@FredericLEGUEN-Excel3 жыл бұрын
Sure. This technique works for all versions of Excel
@imtirafat Жыл бұрын
Tried several times, all I get is a 0 (zero). Not helpful at all.
@usmaniqbal18362 жыл бұрын
Share link to download file for practice.
@akashalfred14 жыл бұрын
Not helpful the way it's in the video is not the same when we do it ourselves.
@FredericLEGUEN-Excel4 жыл бұрын
Of course because it depends of the random number generated. It's never the same
@akashalfred14 жыл бұрын
@@FredericLEGUEN-Excel when i click on the source and move to the extract sheet it changes and then the command doesn't work.