Forum Discussion
Formula that output values of all possible permutations
Hi all - I have a spreadsheet with raw data in the first tab. All the other tabs work as engines as in they get data from a pair (two rows only) apply some arithmetic formulas and output values. How...
Hi Peter - Thank you for helping with this. This is much appreciated.
Will look into the spreadsheet you revised asap and revert with comments.
This is a stab at producing a workbook that uses (named) relative references rather than dynamic array formulae (it pains me to do it and I cannot guarantee that I have got it right but it seems to be working on my computer).
By the way, if you are targeting all possible combinations any value1 that equals a value2 will give rise to a row of zeros.