Answer the question
In order to leave comments, you need to log in
How to randomize a cell from a list?
For example, in column A there are several cells: buy, order, purchase.
What formula should be written so that one of the cells from the range A1-A3 is randomly displayed in another cell?
Answer the question
In order to leave comments, you need to log in
Alexander , thank you very much! Tell me, how can I make friends with CONNECT this formula?
As in the example below, only to link not to specific cells, but from a range:
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question