Comments for Excel Tools, Models, Tips, and Tricks http://briancohenconsulting.com/blog intermediate-level Sat, 05 Jan 2013 02:31:15 +0000 hourly 1 http://wordpress.org/?v=3.5.1 Comment on Dynamic Pivot Table Range by Nathan http://briancohenconsulting.com/blog/?p=280#comment-174 Nathan Sat, 05 Jan 2013 02:31:15 +0000 http://briancohenconsulting.com/blog/?p=280#comment-174 pivot tables really go well with tables of data which are dynamic by themselves, no need for named range going this route. nice article though, and useful in other areas

]]> Comment on Dynamic Pivot Table Range by moody http://briancohenconsulting.com/blog/?p=280#comment-161 moody Thu, 13 Dec 2012 10:05:51 +0000 http://briancohenconsulting.com/blog/?p=280#comment-161 Can this be done across sheets? As in, the pivot table can by dynamic in its look up based off of the month?

]]> Comment on Dynamic Pivot Table Range by Brian Cohen http://briancohenconsulting.com/blog/?p=280#comment-96 Brian Cohen Tue, 20 Nov 2012 22:11:32 +0000 http://briancohenconsulting.com/blog/?p=280#comment-96 Send me your workbook and I’ll take a look.

]]> Comment on Dynamic Pivot Table Range by Brian Cohen http://briancohenconsulting.com/blog/?p=280#comment-95 Brian Cohen Tue, 20 Nov 2012 22:10:10 +0000 http://briancohenconsulting.com/blog/?p=280#comment-95 Yes, just change the number 2 to the number of columns to span. You could also nest another formula to dynamically count the number of columns. I can explain further if you’d like.

]]> Comment on Dynamic Pivot Table Range by Brian Cohen http://briancohenconsulting.com/blog/?p=280#comment-94 Brian Cohen Tue, 20 Nov 2012 22:08:23 +0000 http://briancohenconsulting.com/blog/?p=280#comment-94 The COUNTA function shouldn’t affect anything — COUNTA just counts the number of non blank cells…duplicates are not a problem. Send me your workbook and I’ll take a look.

]]> Comment on Dynamic Pivot Table Range by Kiran http://briancohenconsulting.com/blog/?p=280#comment-91 Kiran Wed, 03 Oct 2012 06:35:22 +0000 http://briancohenconsulting.com/blog/?p=280#comment-91 hi All,

When i tried doing creating a dynamic range , its giving error saying Reference is not valid.

please help.

With Regards
Kiran

]]> Comment on Dynamic Pivot Table Range by Paul http://briancohenconsulting.com/blog/?p=280#comment-90 Paul Thu, 06 Sep 2012 14:25:29 +0000 http://briancohenconsulting.com/blog/?p=280#comment-90 Also does this work with more than 2 columns ?? Changing the last “2″ of the formula by the number of columns does not work…

]]> Comment on Dynamic Pivot Table Range by Paul http://briancohenconsulting.com/blog/?p=280#comment-89 Paul Thu, 06 Sep 2012 09:26:05 +0000 http://briancohenconsulting.com/blog/?p=280#comment-89 Very well explained ! However this did not work for me: I get “Reference is not valid”. I am 99% sure that this comes from the fact I have duplicates in my Data source table. I have 1250 rows of companies in the data table but the pivot table shows only 885 (when I select the range manually….). The COUNTA function is thus messed up right ?

If you have any idea how to fix this your help would be greatly appreciated !

]]> Comment on Dynamic Pivot Table Range by Kyle http://briancohenconsulting.com/blog/?p=280#comment-8 Kyle Mon, 27 Feb 2012 02:21:06 +0000 http://briancohenconsulting.com/blog/?p=280#comment-8 Great explanation! That’s always confused me a bit but I think I get it now, the way you described. Cheers!

]]> Comment on Market Penetration by Vera http://briancohenconsulting.com/blog/?p=8#comment-4 Vera Wed, 01 Feb 2012 18:16:52 +0000 http://briancohenconsulting.com/?p=8#comment-4 Nice to read your blog

]]>