CODEWITHSUNDEEP
excel
Dan
Dan

Reputation: 343

Index function in Excel not working

I am trying to use the index function in Excel, but seems like I am doing it wrong !

What am I trying to do is:

I have values names in a column, like Name1, Name2, Name 3. Now I want to randomly put those names in a other column, so I have tried like that:

= INDEX(AD2;AD11; RANDBETWEEN(1;10)) // AD is the column and I want to take the value from AD2 to AD11

but it is not working, do anyone knows any answer to that solution !

Upvotes: 0

Views: 667

Answers (1)

Scott Craner
Scott Craner

Reputation: 152450

You have a small typo:

= INDEX(AD2:AD11; RANDBETWEEN(1;10))

There should be a : in the range not a ;

Upvotes: 1

Related Questions