LinkBack URL
About LinkBacks
See attached DB. In the "Number of Teams" column it's including blanks and I need it not to.
To refresh just simply re-enter the number in the "Enter # of Entrants" box.
Any help is appreciated!
Thanks,
Andy
See attached DB. In the "Number of Teams" column it's including blanks and I need it not to.
To refresh just simply re-enter the number in the "Enter # of Entrants" box.
Any help is appreciated!
Thanks,
Andy
How aboutFormula:
=LET(f,FILTER(C4:C33,C4:C33<>""),IFERROR(INDEX(SORTBY(f,RANDARRAY(ROWS(f))),SEQUENCE($D$4)),""))
Working great!
Thanks,
Andy
Can you mock up what you EXPECT to see for any given number... and aslo change your profile... you're no longer using Excel 2010.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Glad to help & thanks for the feedback.
What I've now realized is the sheet/workbook is volatile and when I try and copy teams over to my other sheet it reassigns players to the teams. Is there away to prevent the workbook/worksheet to not refresh anytime a change is made?
Furthermore, when I only enter the scores on the other sheet then with each entry it will recompile a new set of teams.
You have two options
1) Copy/paste as values.
2) Turn calculation to manual.
Roger that! Thanks!
I thought i had a nice workaround... but it's being a bit of a pain right now... and I have to leave shortly for the night. i'll look at it again tomorrow.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks