Rayne

asked on

# Dynamic This!

Hello All,

Assuming there is a a table from column C to Z starting from row row 10, then this is the dynamic range formula for it

=mySource!$C$10:INDEX(mySource!$Z:$Z,MATCH(REPT("z",20),mySource!$C:$C))

Now what if I only had one column at column C and want to make it dynamic, how the same approach formula can be used in that case (using index match)

so I am looking for a dynamic named range formula for a range that's just one column, using the same approach as discussed?

thanks

Assuming there is a a table from column C to Z starting from row row 10, then this is the dynamic range formula for it

=mySource!$C$10:INDEX(mySo

Now what if I only had one column at column C and want to make it dynamic, how the same approach formula can be used in that case (using index match)

so I am looking for a dynamic named range formula for a range that's just one column, using the same approach as discussed?

thanks

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Thanks MDS for the help.

Thank you Patrick - that’s perfect, then I doesn’t have to worry about expanding column set, HUGE lifesaver, right there!!!