LinkBack URL
About LinkBacks
You don't specify the complete range you require but in basic terms you can use an Array
=STDEVA(IF(ISNUMBER(S7:DY7)*MOD(COLUMNS(S7:DY7),2),S7:DY7)) confirmed with CTRL + SHIFT + ENTER
You don't specify the complete range you require but in basic terms you can use an Array
=STDEVA(IF(ISNUMBER(S7:DY7)*MOD(COLUMNS(S7:DY7),2),S7:DY7)) confirmed with CTRL + SHIFT + ENTER
Last edited by DonkeyOte; 12-15-2009 at 05:44 PM. Reason: revised to STDEVA... not sure if req. or not by OP
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks