Quote:
Originally Posted by BobBridges
Swooshy, you may or may not thank me for this, but before I could understand what you were doing, I had to break it down into pieces and then simplify it. The attached workbook is not the answer to your question; I just added a sheet "Simple" which shows how "Sample" might look, doing the same thing yet being easier to follow. All your logic is in there, it's just that by adding some helping columns and using a few absolute references, the formulae are a lot shorter.
|
Hi BobBridges
Your example seems to tie out with what is required alright but unfortunately my excel is not strong enough to understand what is going on there.
would you mind updating your example with some comments so that I can follow what is going on there? The thing is there is in excess of 10K rows in the report that I am using with numerous opportunity numbers so the formula would need to flexible to allow the drag down functionality to work across those. this may be a given but i just need to make sure!