I am trying to create what has been called a progression table in excel.
For example: I have two columns of data, one starting with letters
the other with a double progression of numbers. Column one has the
letters A,B...J. Column two has the numbers 1,000, 2,000, 4,000,
8,000....512,000. So the letter A corresponds to the number 1,000,
letter B corresponds to 2,000 and so on with J corresponding to
512,000. Now here is the challenge. I want to create a table that
tells me which combination of letters will add up to a particular
value. For example if I wanted a total of 7,000, I would add A, B, and
C together. I realize that not all desired numbers can be created
exactly by adding up the letters but they will all be within 1,000 of
my desired total. I am told that with these variables there are over
1,000 non-repeating numbers that can be created. I have looked at data
tables and pivot tables but am not sure which if either of these
functions are capable making this table. Does anyone have any ideas?

Thank you,

DB


---
Message posted from http://www.ExcelForum.com/