Hi
I want to generate random words from my list in cell M3 through M6 with different value in each cell,this is my formula
=IF(DATEDIF(C4,L4,"m")=1,INDEX($O$3:$O$25,RANDBETWEEN(1,ROWS($O$3:$O$25))),"Wrong")
can anyone help me?
Regards
Ulum
Hi
I want to generate random words from my list in cell M3 through M6 with different value in each cell,this is my formula
=IF(DATEDIF(C4,L4,"m")=1,INDEX($O$3:$O$25,RANDBETWEEN(1,ROWS($O$3:$O$25))),"Wrong")
can anyone help me?
Regards
Ulum
Instead of Randbetween() try to go for some other appraoch since Randbetween() may have chances to produce duplicates
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Check gray cells
@sixthsense : could you name that function?
thx :
@xx7 : thanks for the help, but i need something more simple than nested if cause i have more than 50 word in my list
thx
Try the lookup function in the gray cells!
@xx7 : thank you so much for your help :D
now i can finally done my work
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks