Hi friends,
I have been trying to figure out the solution to find a formula to return a value if a letter or word is repeated 2 times in range.
For example :
Sheet1
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"></colgroup><tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
As shown above, the letter "S" is repeated 2 times in Row 1. What I am trying to do is to make a formula to put "H" in Row 2 below the second "S" (found in F1).
I have tried countif, count, rept and so on. But couldn't make one.
Can anyone please help me?
Hope someone would help me.
Thanks in advance.
I have been trying to figure out the solution to find a formula to return a value if a letter or word is repeated 2 times in range.
For example :
Sheet1
A | B | C | D | E | F | |
1 | S | B | N | U | I | S |
2 | H |
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"></colgroup><tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
As shown above, the letter "S" is repeated 2 times in Row 1. What I am trying to do is to make a formula to put "H" in Row 2 below the second "S" (found in F1).
I have tried countif, count, rept and so on. But couldn't make one.
Can anyone please help me?
Hope someone would help me.
Thanks in advance.