Dynamic Table Range, Dynamic Columns

**bimo** · 06-24-2013, 05:30 AM

Hello

I have just been introduced to the wonders of Dynamic ranges, while I can define a range with a dynamic Row,

I cannot get the one for Dynamic Columns working, ( see attached )..basically when report is refreshed, table can contain more or less columns.

Can you please help ? if you could reload the sheet with a rectified working formulae that would be perfect

Thanks

**Ace_XL** · 06-24-2013, 05:35 AM

In the dynamic range use

=OFFSET(Sheet1!$A$5,0,0,COUNTA(Sheet1!$A:$A),COUNTA(Sheet1!$5:$5))

Does this give you desired results?

**XOR LX** · 06-24-2013, 05:35 AM

Hi,

For which column(s) precisely are you trying to create a dynamic range?

Regards

**:) Sixthsense :)** · 06-24-2013, 05:38 AM

May be this

Formula:

Please Login or Register  to view this content.

**:) Sixthsense :)** · 06-24-2013, 05:50 AM

Remove CountA from my earlier suggested formula since I just used it for testing purpose

Formula:

Please Login or Register  to view this content.

**bimo** · 06-24-2013, 08:15 AM

Originally Posted by Ace_XL

In the dynamic range use

=OFFSET(Sheet1!$A$5,0,0,COUNTA(Sheet1!$A:$A),COUNTA(Sheet1!$5:$5))

Does this give you desired results?

Thank you! it worked!

**bimo** · 06-24-2013, 08:16 AM

Thank you all! problem solved!

Dynamic Table Range, Dynamic Columns

LinkBack

Thread Tools

Rate This Thread

Display

Dynamic Table Range, Dynamic Columns

Re: Dynamic Table Range, Dynamic Columns

Re: Dynamic Table Range, Dynamic Columns

Re: Dynamic Table Range, Dynamic Columns

Re: Dynamic Table Range, Dynamic Columns

Re: Dynamic Table Range, Dynamic Columns

Re: Dynamic Table Range, Dynamic Columns

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions