|If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.|
||Thread Tools||Display Modes|
Where to Start
I would like some guidance on where it would be best to start. I have a set of data, extracted from a MySQL database into Excel. This data then needs to be randomly assigned to 5 different users based on their ranking.
So as an example I have 100 records all ranked as:
The users are ranked 1 - 5. However you could have two users equally ranked.
So lets assume:
User 1 = Rank 1
User 2 = Rank 2
User 3 = Rank 2
User 4 = Rank 4
User 5 = Rank 5
All the users need to be assigned the same amount of records (20), but User 1 needs to have more Platinum records assigned to them than any of the other users. User 5 needs to have more Bronze records assigned to them than the other users.
So can anyone suggest a way of doing this?
Can I do it with a SQL query?
Would it be easier to do it with a marco?
|Thread||Thread Starter||Forum||Replies||Last Post|
|Calculating monthly start date with a start date||Monique||Excel Worksheet Functions||3||December 20th 08 09:50 AM|
|start:1 and start:2 - how did i get 2 copies?||LuvHaleiwa||Excel Discussion (Misc queries)||1||December 21st 07 09:14 PM|
|start learning Excel/VBA, where to start from? Any online video lectures?||cfman||Excel Programming||8||September 29th 06 10:40 AM|
|OT :Start your own online business today !start making dollars||[email protected]||Excel Discussion (Misc queries)||0||May 6th 06 09:29 PM|
|Start spreadsheet with WinXP start||Gordon Gradwell||Excel Worksheet Functions||1||July 13th 05 11:35 AM|