"This basically produces a cost centre report for the Cost Centre Choice by account code by month"
wouldn't a pivot table be a more natural approach?
anyway, you need to describe you data set up in more detail - a worked example would help, as would a view of the data (you can post up a representative snapshot of your data with the html maker addin available by following the link below this post)
Tue May 18, 2004 10:45 pm
Aladin Akyurek .
Joined: 15 Feb 2002
Location: The Hague
Re: If statements within Array formulas
Care to post the IF formula that you tried? Are HYP, date, and CC names that refer to particular ranges?
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
All contents Copyright 1998-2004 by MrExcel.com
If you believe information posted here is from your copyrighted source, notify us per the
Excel is a registered trademark of the Microsoft Corporation. MrExcel is a registered trademark of Tickling Keys, Inc.