In Excel mobile, I simply need cell B1 to be a random cell's text from B2 down if the cell left from 'x picked cell' (column A2 down) is less than equal to 100 every time I hit the calculate button.
I am new to excel mobile (I have it on a new tablet). I was using the full version on my laptop. Apparently excel mobile is not compatible with the following:
=INDEX(B:B,SMALL(IF(A2:A1000<1, ROW(A2:A1000)),RANDBETWEEN(1, COUNTIF(A2:A1000,"<1"))))
this works when you hit Ctrl+Shift+Enter right after typing it in the full version, but excel mobile does not have the ability for CSE, and apparently doesn't support array formulas anyway.
Any ideas for a work around? Thanks
I am new to excel mobile (I have it on a new tablet). I was using the full version on my laptop. Apparently excel mobile is not compatible with the following:
=INDEX(B:B,SMALL(IF(A2:A1000<1, ROW(A2:A1000)),RANDBETWEEN(1, COUNTIF(A2:A1000,"<1"))))
this works when you hit Ctrl+Shift+Enter right after typing it in the full version, but excel mobile does not have the ability for CSE, and apparently doesn't support array formulas anyway.
Any ideas for a work around? Thanks
