Thread: [Solved] Named Ranges Help
View Single Post
 
Old 04-28-2017, 12:47 PM
SavGDK SavGDK is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Apr 2016
Location: Savannah Ga
Posts: 20
SavGDK is on a distinguished road
Default Named Ranges Help

I have a bunch of named ranges with this formula to change the range length when the data changes. Occasionally at the end of the data I will get a rows of #N/A if the data query does not pull any data for the entire data range.

How can I change this formula =OFFSET('Misc Calculations'!$T$9,0,0,COUNTA('Misc Calculations'!$T:$T)-1) to exclude the #N/A in the rows? When it includes it my graphs get all messed up because it includes this data on the graph.


Thank you,
Reply With Quote