Recently I found this question and was unable too solve it by myself. I tried Vlookup and different other options, but this is above my current skill set. Example: I have column alphabet value matrix, for each letter in alphabet like this. Letter Location Value=1/location A 1 1,00000 B 2 0,50000 C 3 0,33333 D 4 0,25000 E 5 0,20000 F 6 0,16667 G 7 0,14286 H 8 0,12500 <SNIP> X 24 0,04167 Y 25 0,04000 Z 26 0,03846 Now, how would I be able to calculate which 7 letters represent value 0,867100 ? Both numbers are fixed, multiple solutions/ combinations might be possible. Thanks, all feedback, appreciated!
Not solved, but will investigate into Knapsack or Rucksack as possible solution. Thanks!