Hello
i have a error in my formula
when i have a blank cell (D3 in example)
it should report the (last value-1) writed in line 3
please see example
Hello
i have a error in my formula
when i have a blank cell (D3 in example)
it should report the (last value-1) writed in line 3
please see example
Last edited by j_r_m_c; 02-14-2011 at 04:30 PM.
Perhaps:
for B7 & B8 simply add a result vector ($B$2:$E$2) to the above![]()
Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
it does´t work
please can you write in the example??
the blank cell between numbers can 1,2 or more
"it does not work" is helpful a post as you can imagine.
The formula does work so I suspect the issue is down either to delimiters, function translation and/or other inaccuracies.
sorry about last post
i´m going to test the formula
it works well
![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks