ststern45
Well-known Member
- Joined
- Sep 17, 2005
- Messages
- 974
- Office Version
- 365
- 2010
- Platform
- Windows
Hi everyone,
I would like to find a formula that will calculate how may cells back when a digit appeared.
For example,
A1 = 2
B1 = 2
C1 = 2
2-2-2
9-7-0
8-1-3
1-4-3
7-3-5
9-2-9
6-6-8
2-0-7
1-4-8
7-7-2
Step1: Count how many cells back until the 1st digit 2. In this example the 1st 2 is 5 cells back (9-2-9)
Step2: Count how many cells back until the 2nd digit 2. In this example the 2nd 2 is 7 cells back (2-0-7)
Step3: Count how many cells back until the 3rd digit 2. In this example the 3rd 2 is 9 cells back (7-7-2)
So cell
D1 = 5 cells back
E1 = 7 cells back
F1 = 9 cells back
Thanks in advance!!
I would like to find a formula that will calculate how may cells back when a digit appeared.
For example,
A1 = 2
B1 = 2
C1 = 2
2-2-2
9-7-0
8-1-3
1-4-3
7-3-5
9-2-9
6-6-8
2-0-7
1-4-8
7-7-2
Step1: Count how many cells back until the 1st digit 2. In this example the 1st 2 is 5 cells back (9-2-9)
Step2: Count how many cells back until the 2nd digit 2. In this example the 2nd 2 is 7 cells back (2-0-7)
Step3: Count how many cells back until the 3rd digit 2. In this example the 3rd 2 is 9 cells back (7-7-2)
So cell
D1 = 5 cells back
E1 = 7 cells back
F1 = 9 cells back
Thanks in advance!!
Last edited: