LinkBack URL
About LinkBacks
I am trying to randomly select 10 data from a table by using index formula. But there are some blank cell in the table so It kept returning 0 in the cell. Do need some help with this plz!problem.xlsx
Thank you so much!
I am trying to randomly select 10 data from a table by using index formula. But there are some blank cell in the table so It kept returning 0 in the cell. Do need some help with this plz!problem.xlsx
Thank you so much!
Last edited by mdyy1399; 10-31-2013 at 01:25 AM.
Hi,
to be confirmed with control + shift + enter
Please Login or Register to view this content.
A better alternative is VBA, but my knowledge is far lower than basic.
Regards
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
Hi,
in order to avoid repeated random numbers, in J2
again to be confirmed with control+shift+enterPlease Login or Register to view this content.
Regards
EDIT: formula to be corrected in order to control not only j1, but also j1 j2...
Last edited by canapone; 10-31-2013 at 03:17 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks