Tag Archive: INDIRECT

Articles sur le thème : INDIRECT

Function INDIRECT

How to use the cell's contain in a reference

The INDIRECT function provides you to create dynamique references by using the cells’ contain as part of your references.

Permanent link to this article: https://www.excel-exercise.com/function-indirect/

Dynamic Dropdown List

How to create a dynamic dropdown list

You can easily create a dynamic dropdown list when you insert your data in a Table. But also, you must write the reference of the table in the function INDIRECT.

Permanent link to this article: https://www.excel-exercise.com/dynamic-drop-down-list/

Extract random data of your database

List of email extract randomly

To extract random data from a huge list, the copy-paste method is not the best one ⛔. In fact, with the functions RANDBETWEEN and INDIRECT it’s easier 😉

Permanent link to this article: https://www.excel-exercise.com/extract-random-data-of-your-database/

Reorder your data from one column to many

Unstack 1 column to many with TRANSPOSE and INDIRECT

You can unstack data from 1 column to many with the function TRANSPOSE and INDIRECT. Explanation is this article.

Permanent link to this article: https://www.excel-exercise.com/reorder-your-data-from-one-column-to-many/