Shortest Formula Challenge!! (Game 8: Plates & Rand. Char.)

Originally Posted by Hawkeye16

@speshul or someone, can you explain why you aren't using something like

=CHAR(LARGE(ISNUMBER(FIND(CHAR(ROW(A:A)),G2))*ROW(A:A),INT(RAND()*COUNT(FIND(CHAR(ROW(A:A)),G2))+1))

(changed row references)

instead? It seems to return the same and is shorter but I am sure there is a reason. It seems odd to use it in the second part but not the first part to me.

Perhaps he just forgot. Have you looked at all the previous posts in this thread? You'll see that that construction has been used if you do...

Regards