|Unless you use VBA programming (Macros) you can't enter one value in a cell and have a different value show up. |
How would I set it up usin Visual Basic? Is it possible?
Note: You didn't say what you wanted to show if the number wasn't 1 - 20, so I assumed the cell should be empty.
There will never be a number greater than 20 inputted.
re: Then have the sum of all columns appear as follows:
Column E Row 1: 6,5,3,2
I have no clue what you are saying here. None of the columns of original numbers or results sum to the values given. Please clarify.
Column A Row 1: 6 (value=3)
Column A Row 2: 3 (value=3)
Column A Row 3: 6 (value=3)
Column A Row 4: 2 (value=3)
Column B Row 1: 5 (value=2)
Column B Row 2: 5 (value=2)
Column B Row 3: 5 (value=2)
Column B Row 4: 6 (value=2)
Column C Row 1: 6 (value=1)
Column C Row 2: 3 (value=1)
Column C Row 3: 6 (value=1)
Column C Row 4: 4 (value=1)
Column D Row 1: 5 (value=0)
Column D Row 2: 5 (value=0)
Column D Row 3: 5 (value=0)
Column D Row 4: 6 (value=0)
Because 6=10, 5=6, 3=4, 2=3
All of the 6's (using their associated value) add to 10.
Make any more sense?
Thanks for the quick response. Sorry this is so confusing. Hopefully I am getting my point across.
Let me try it this way. I am trying to input a multiple numbers in into a 4 row by 4 column section of Excel and have the spread sheet automatically tell me which number is most common, 2nd most common and 3rd most common to that group appear in another single cell using X,X,X format. Does that make sense?
So it would look something like this:
ColumnA ColumnB ColumnC ColumnD ColumnE
Row1: 4 4 3 5 4,3,7
Row2: 4 3 7 8
Row3: 4 3 7 2
Row4: 4 3 7 8
Again, sorry for any headache that may come of this and thanks for helping.