Hi List,
I have a column of 20 names in A
A column of numbers, 1 - 20 in B
A column of 20 RAND() in C
I then sort B on C results
I want to display the name that now corresponds to 1 in D1
I hope someone can help. I have read and tried but..!
TIA,
John
Bookmarks