However, the INDIRECT function enables you to switch these around. This inverted order is known as the R1C1 reference style, where the "R" refers to a row, and the "C" refers to a column.

Enter where you want to place the result; the formula is =INDIRECT (“R7C”&COUNTA (7:7), FALSE). The formula R represents the Row, which is Row 7, and the C represents the column.

TL;DR Key Takeaways : The INDIRECT function in Excel is volatile, error-prone, and negatively impacts performance, making it less suitable for modern, data-intensive workflows.