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...
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...
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...
Thanks for your reply. Unfortunately that doesnt work - well, it does, but its purely referencing the 'Summary' sheet. Ideally, I'd like...
Hi Guys. I have a s/sheet with multiple worksheets, with the 'Summary' containing a list of all stocks (vertically in Columns) grouped by...
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,...
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,...
Separate names with a comma.