Hi Excel Guru's
Attached is a sample worksheet of the issue I am having.
There are comments on the worksheet that explain what I am trying to achieve.
It's basically an issue with filters, averages and error values...
To make matters a little more complex, I am working in Excel 97-2003..
Any help is gratefully received.
Last edited by mungel; 03-25-2013 at 01:00 PM. Reason: Adding prefix
see if the following ARRAY formula in D21 does what you desire:
if it does, then just drag-fill towards right...
Please Login or Register to view this content.
Last edited by icestationzbra; 03-24-2013 at 09:48 PM.
- i.s.z -
CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
All good ideas are courtesy resources from this forum as well as others around the web.
- e.o.m -
use this in d2 and drag.
Please Login or Register to view this content.
That's just about what I need. Your formula works a treat. I have gotten around the 'disappearing with the filter' issue with a couple of buttons and macros..Originally Posted by icestationzbra
see if the following ARRAY formula in D21 does what you desire:
if it does, then just drag-fill towards right...Please Login or Register to view this content.
Many thanks..
Last edited by mungel; 03-25-2013 at 01:53 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks