Need help with Index Function

I've created a file to pull a random list from column A, utilizing Rand() in column B and the following Index Function in Column C: =INDEX($A$4:$A30,RANK(B4,$B$4:$B$30),1)   Example- Last names of ...