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

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/

One column to many columns with Excel

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/one-column-to-many-columns-with-excel/