=Rand()
=RANK(A1,$A$1:$A$100,1)
=VLOOKUP(D1,$B$1:$C$100,2,FALSE)
Excel Workbook | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | 0,34854766 | 7 | Name1 | ||
2 | 0,3861992 | 8 | Name1 | ||
3 | 0,80548474 | 14 | Name1 | ||
4 | 0,01671174 | 1 | Name1 | ||
5 | 0,19795543 | 4 | Name2 | ||
6 | 0,6221247 | 11 | Name2 | ||
7 | 0,82802012 | 15 | Name2 | ||
8 | 0,22098747 | 5 | Name2 | ||
9 | 0,90162079 | 16 | Name3 | ||
10 | 0,0864949 | 3 | Name3 | ||
11 | 0,46578547 | 9 | Name3 | ||
12 | 0,32193655 | 6 | Name3 | ||
13 | 0,73208343 | 13 | Name4 | ||
14 | 0,06335104 | 2 | Name4 | ||
15 | 0,67316803 | 12 | Name4 | ||
16 | 0,5126781 | 10 | Name4 | ||
The source Data |
Excel Workbook | ||||||
---|---|---|---|---|---|---|
D | E | F | G | |||
1 | 1 | 5 | 9 | 13 | ||
2 | 2 | 6 | 10 | 14 | ||
3 | 3 | 7 | 11 | 15 | ||
4 | 4 | 8 | 12 | 16 | ||
The numbered field |
Excel Workbook | ||||||
---|---|---|---|---|---|---|
D | E | F | G | |||
5 | ||||||
6 | Name1 | Name2 | Name3 | Name4 | ||
7 | Name4 | Name3 | Name4 | Name1 | ||
8 | Name3 | Name1 | Name2 | Name2 | ||
9 | Name2 | Name1 | Name4 | Name3 | ||
Sheet |
=RAND()
Okay, a couple of questions. First of all, I'm not certain I am doing the step: Fill 10 rows down and 10 columns to right. correctly. I copied, by dragging the corner of the D12 cell down 10 rows. Then I copied, by dragging the corner of the D12 cell 10 columns to the right. This only populated that row and that column. How should I fill the rest of the table?
I tried a few things, and although I'm not certain my information is correct, or that I did it correctly, I moved on to get the counts, but I was getting zero's in my count column and no names in my name column.
my formula was:
=COUNTIF($D$12:$M$21,P11)
any suggestions?