Dynamic range with INDEX

**esbencito** · 05-18-2018, 04:17 AM

Hi all,

I frequently use INDEX to create dynamic ranges. Though, so far I have only used e.g.

Please Login or Register  to view this content.

Can this be expanded to below, where I basically use two INDEX functions to create a range?

Please Login or Register  to view this content.

The dynamic range should refer to DA$1502:EC$1502 in the above example...

**Pete_UK** · 05-18-2018, 05:09 AM

Yes, have you tried that?

Pete

**Norie** · 05-18-2018, 05:18 AM

That formula will refer to $DA$1502:$EC$1502, not sure how it's dynamic though.

**esbencito** · 05-18-2018, 05:34 AM

ups... had a typo in my formula. Thanks guys! Maybe it's time to get a nap and de-clutter my mind

*it is only dynamic in my case not in the above example

Re: Dynamic range with INDEX