Showing related tags and posts accross the entire site.
-
I've attached an example using match, countif and offset to achieve your goal, and also created a named range to demonstrate how this can be used too. You could also do the same thing in VBA code, though I'll leave that to someone else for now. Also, this assumes that your 'sections'...
-
Hi Steve, Rather than use VBA, I've developed a worksheet only solution, using dynamic named ranges, LINEST linear regression function, datatables, index/match to pick out the best results, and finally solving the simultaneous equations and plotting!! Sorry I don't have time to explain the whole...
-
Hey Joe, I've done something like this before, it was a while ago and I don't remember if this is the way I did it but... You don't necessarily need to use VBA to achieve the functionality to describe I would use the "INDIRECT" function, which interprets a string as a cell reference...