G
G
gleb-batishev2019-02-26 06:49:33
excel
gleb-batishev, 2019-02-26 06:49:33

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?
5c74b74587f99661313617.jpeg

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
Alexander, 2019-02-26
@NeiroNx

=INDEX(A1:A6,RANDBETWEEN(1,6),1)

G
gleb-batishev @, 2019-02-26
gleb

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:
5c74c266c8119818484083.jpeg

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question