Ride The Lightning
Board Regular
- Joined
- Jul 14, 2005
- Messages
- 238
Hi
I have a text string in Cell A1, for example "inthebeginninggodcreatedtheheavenandtheearth."
I have calculations in cells B1, C1, D1 calculating the number of times a letter appears in the text string. For example, in another part of the worksheet I enter "g" in a particular cell and cell B1 returns the value "3", I enter "o" in another cell and C1 returns "1" and I enter "d" in another cell and D1 returns "3".
I want to be able to calculate the number of times an anagram of the letters entered appears so in the above example it would be 1.
If the results were B1=5, C1=2, D1=4, the answer would be 2
If the results were B1=0, C1=2, D1=4, the answer would be 0
If the results were B1=4, C1=6, D1=4, the answer would be 4
I am struggling to workout what functions to use for this problem, but I presume a combination of IF and MIN may do the trick, but would appreciate any help.
Kind Regards
RTL
I have a text string in Cell A1, for example "inthebeginninggodcreatedtheheavenandtheearth."
I have calculations in cells B1, C1, D1 calculating the number of times a letter appears in the text string. For example, in another part of the worksheet I enter "g" in a particular cell and cell B1 returns the value "3", I enter "o" in another cell and C1 returns "1" and I enter "d" in another cell and D1 returns "3".
I want to be able to calculate the number of times an anagram of the letters entered appears so in the above example it would be 1.
If the results were B1=5, C1=2, D1=4, the answer would be 2
If the results were B1=0, C1=2, D1=4, the answer would be 0
If the results were B1=4, C1=6, D1=4, the answer would be 4
I am struggling to workout what functions to use for this problem, but I presume a combination of IF and MIN may do the trick, but would appreciate any help.
Kind Regards
RTL