Recent content by sargie

Thanks Fader - works perfectly! Is there a way I can apply the formula to all relevant rows, i.e stop at the last non-blank row, without having to drag manually? Cheers.

Hi guys. I have a large s/sheet containing imported trade data - however, its full of gumph with only a few rows containing data I need (example attached). The info I need i pretty much anything within the 5 or 6 rows under 'SUB-TOTAL Currency'. Unfortunately, I cant sort by 'FX...

Yes - thought about that. However, its a very informal s/sheet and if anything, the numbers running off the back of the tickers are the main priority - ie, stats/charts etc. Thanks.

Thanks for your reply. Unfortunately that doesnt work - well, it does, but its purely referencing the 'Summary' sheet. Ideally, I'd like some form of Vb code so that if I inserted a new stock on 'Summary' it automatically updates in the other two worksheets? And its not restricted to...

Hi Guys. I have a s/sheet with multiple worksheets, with the 'Summary' containing a list of all stocks (vertically in Columns) grouped by industry . I have other worksheets tracking data about the stock (horizontally in Rows). However, I'd like to dynamically be able to Add a new stock to...

yes - both are good. thanks guys, much appreciated. I didnt realise Excel had BLANK functionality to be honest ! cheers, S.

Thanks. Here's a screenshot. As you can see, its a fairly straightforward formula, however, I need an override in D4 so that if D1 is NOT blank, use it, otherwise continue with the Cap/Floor IF statement. Thanks again. Much appreciated.

Hi. I have a s/sheet which applies a margin above a swap rate. However, its based on multiple criteria of if the loan rate is above the Cap rate, use the Cap, and if its below the Floor, use the floor etc. However, I need to include another Cell, which if 'not blank' overrides any other value...