the one video that worked correctly, thank you so much!!
@AjayAnandXLnCAD2 ай бұрын
My pleasure 😀
@andrewsegawa72212 жыл бұрын
Thanks brother for this!! I was scratching my head for this tool. And it’s been helpful.
@venukalav Жыл бұрын
Thanks. Great video. So lets say i have 5 team leads, to which group members need to be assigned randomly. Can we do this while not letting it assign group members to specific team leads, as I want team leads to interact with those that they don't normally supervise? Thanks
@sarahmarsh78403 жыл бұрын
Thank you so much, this is the best video I've seen on randomised samples. 😃
@AjayAnandXLnCAD3 жыл бұрын
Wow, thanks!
@saajkhan4248 Жыл бұрын
@@AjayAnandXLnCAD how to make team size column.. I'm having plane list of students but how to make team size colum
@kyothinks3 жыл бұрын
Thank you! This video helped me so much. You are very good at explaining things!
@kimbyfield24783 жыл бұрын
Wow! Super Easy and super useful! Plus I picked up so many other excel tricks from this video! Thanks a bunch!
@Liviawesterhout2 жыл бұрын
For the formatting of the cells (7:09) what do you use after the ? I tried different operands but it does not work. Thanks!
@sanjaysfr3 жыл бұрын
This is fantastic, u solved a big headache for me.. I have 300+ members in my team, and this is super useful.. thank u
@Munchman12 ай бұрын
This is amazing thank you but for some reason it shows #Calc! When i try to list names by team. Any advice or coupd i please download a spreadsheet ?
@joedlafferty2 жыл бұрын
this is great! I have to make random groups for assignment and this is very helpful. thanks!
@suxellim99002 жыл бұрын
Thanks for the video! Any idea, what if certain users can only go into a specific team?
@m.fonseca3537 Жыл бұрын
Thank you so much. It was very helpful and it is very well done!! See you!
@jeromgerald3 жыл бұрын
That's a very good info... thank you Ajay... 👍👏
@AjayAnandXLnCAD3 жыл бұрын
My pleasure, Gerald :)
@nurlydiarosli18553 жыл бұрын
This is so helpful! Thanks a million.
@10degreerule6 ай бұрын
Hi Ajay I have a group of Golfers 28 to 36 max in an Excel sheet I would like to have every week each player from the foursome cannot meet any one that he already played with for nine consecutive weeks wondering if it is easy way thanks
@jonathanschmidt4175 ай бұрын
Can you add this to a button in a macro?
@tikisahuofficial444 Жыл бұрын
Sir es procedure se dream 11 team v bana sakte hen kya
@navalfluff Жыл бұрын
Thank you so much. Saved me.
@rpremaza2 жыл бұрын
Ajay... This is great! Can you help me take this a little further.... After the "teams" are created, scores will be manually entering a score under each team. When the scores are entered, the teams are going to shuffle again. The people that I work for are not computer people. Showing them the CUT AND PASTE VALUES option (or setting calc options to manual) will confuse them. Is there a way to create a "Shuffle" Button (control) that will shuffle the teams, but keep the teams as is when I start entering the scores? (The teams will be shuffled each week) thanks very much for your help.
@halamadrid9174 Жыл бұрын
That is a great video! thank you. I do have one question: how do I assign people to teams based on rank? Let's say each person gets a rank between 1-5. now, I want the teams to be balanced - no more than 1 player which ranked as '5' and no more than 1 player ranked as 1 per team. any ideas?
@igoruzon285 Жыл бұрын
Could you do something similar in Access?
@sriramsri7955 Жыл бұрын
How to create possibilities auto create
@zeenatkhan424910 ай бұрын
How to do this sampling when we have multiple criterias for creating a team
@ankushgadhave15823 жыл бұрын
Sir, Nice information.Thanks. I want multiple sheets recording in same workbook.Need for VBA code recording video automatically with the time.i want to record 4 types of data in single worksheets but some errors are coming i.e ambiguous runtimer . Made 4 seperate worksheet.then problem solved.but I have to open 4 worksheet for recording. Please make video on this topic.
@bhorton29873 жыл бұрын
This is awesome and exactly what I was after - thank you for making this video!
@gurpreetsinghh4902 жыл бұрын
All is Ok but the only problem is that FILTER command is not available in older version of Excel like 2019, 2016 etc...Is it any other command alternative to FILTER?
@rajmuhammad17873 жыл бұрын
Love this formula
@thiyakup73332 жыл бұрын
This is awesome, thank you
@kamalesh773 жыл бұрын
Sir I think we can make fantasy cricket team in this formula,,pls I want to learn this..reply me 🙏
@pradeepkumargumpina75762 жыл бұрын
IS FILTER OPTION AVAILABLE IN OFFICE 2007
@mirrrvelll51643 жыл бұрын
Smooth, very good
@micheleriva27752 жыл бұрын
hi, cool trik. I have one more question. do you have tried to create teams based on two different variables? I mean people from the same business unit has not to be on the same team. so a way to mix team with member from different business unit. thanks Michele
@BoredomIsTheKey1 Жыл бұрын
I thought I did it the same but my team column is giving me numbers past 5 even though my team size is 5
@achintswaroop3 жыл бұрын
Thanks much help
@colleennikstenas49213 жыл бұрын
so much simpler!!
@jagtapnil248 ай бұрын
Video is helpful but I need some extra addings in this.
@alphayoonesmo80239 ай бұрын
I have question?
@kmcdification Жыл бұрын
How to assign students to non-repeating teams when they've already been in several different teams? No repeats.
@harish70412 жыл бұрын
Share this sheet please
@kelseyj62362 жыл бұрын
How can we do this so the groups are never repeated? For example, I need to pair 150 students with each other randomly so that they have a new partner every week (no repeat pairs)
@kevinjloder2 жыл бұрын
I'm looking for this too! Did you find anything yet?
@Liviawesterhout2 жыл бұрын
Same!!
@sanjayyadav-dz9py3 жыл бұрын
22.33 in R/off=22.50(means below .50 =.50) 22.52 in R/Off =23(means above .50 =1) how can i convert it plse tell me the formula for it )