LinkBack URL
About LinkBacks
ur solution works , but i could not able to understand the calculation method.
Pls explain
and how about the way i was doing it with offset.. why it was not working.
Thanx and regards
kreshnr
ur solution works , but i could not able to understand the calculation method.
Pls explain
and how about the way i was doing it with offset.. why it was not working.
Thanx and regards
kreshnr
See: http://www.xldynamic.com/source/xld....html#last_text
I confess I didn't look at your formula, note however OFFSET is Volatile so best avoided when possible (for info. on Volatility see link in my sig.)
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