I know everyone is different but vba is my goto for virtually everything. There’s almost nothing I can’t build in an hour or two.
It wasn't largest or smallest required, it was 2nd to last, 3rd to last, 4th to last in a row (not column) series, etc and ignoring blank cells. Actually I no longer require though, because, typical of my algo creation, I discovered a different route to go down and my original concept has been binned. While I'm here though, another different query popped up..... Does anyone know the formula for any stock code using sparkline googlefinance 'barchart'. Must be barchart. I can get 'linechart', but the 'barchart' formulas I attempted numerous times brings up an error.
In Excel, how do you create and change multiple cell formulas from a reference in another cell? eg, I have the following cells formulas in columns G to M: How, by inputting numbers into column F will automatically change the rows cell formulas into for example G2 & G3? Is it something like using a concatenate formula or similar?