Forum Discussion

rgrann12's avatar
rgrann12
Copper Contributor
May 22, 2020

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 ...
excel
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
May 22, 2020

rgrann12 

You may use dynamic ranges like

=IFNA(INDEX($A$4:INDEX($A$4:$A$3000,COUNTA(A:A)-1),RANK(B4,$B$4:INDEX($B$4:$B$3000,COUNTA(A:A)-1)),1),"")

in C4

and drag it down

Resources