Hello,
Column C have repeated times 9 alphabets A to I, and In the cell D6 I have a Array formula {=$B$3-IF(MAX((C6=C$6:C$5006)*(ROW(C$6:C$5006)))=0,,MAX((C6=C$6:C$5006)*(ROW(C$6:C$5006))))} copied down to D60 which is counting unique alphabets delay of each A to I as it appears once.
Please I need a help can this formula to be changed so it gives the result as shown in the column E. Delay 1 to 9
Thank you all
I am using Excel 2000
Regards,
Moti
Column C have repeated times 9 alphabets A to I, and In the cell D6 I have a Array formula {=$B$3-IF(MAX((C6=C$6:C$5006)*(ROW(C$6:C$5006)))=0,,MAX((C6=C$6:C$5006)*(ROW(C$6:C$5006))))} copied down to D60 which is counting unique alphabets delay of each A to I as it appears once.
Please I need a help can this formula to be changed so it gives the result as shown in the column E. Delay 1 to 9
* | A | B | C | D | E | F | G |
1 | |||||||
2 | |||||||
3 | 60 | ||||||
4 | A To I | Getting these | But require this | ||||
5 | A To I | Delay (A To I) Result | Delay result | ||||
6 | A | 1 | |||||
7 | A | 2 | |||||
8 | C | 11 | |||||
9 | A | 2 | |||||
10 | E | 3 | |||||
11 | I | 49 | 9 | ||||
12 | B | 4 | |||||
13 | G | 1 | |||||
14 | B | 4 | |||||
15 | A | 2 | |||||
16 | G | 1 | |||||
17 | D | 0 | |||||
18 | C | 11 | |||||
19 | D | 0 | |||||
20 | H | 24 | |||||
21 | B | 4 | |||||
22 | D | 0 | |||||
23 | B | 4 | |||||
24 | B | 4 | |||||
25 | C | 11 | |||||
26 | D | 0 | |||||
27 | H | 24 | |||||
28 | F | 32 | 8 | ||||
29 | B | 4 | |||||
30 | E | 3 | |||||
31 | A | 2 | |||||
32 | E | 3 | |||||
33 | A | 2 | |||||
34 | A | 2 | |||||
35 | A | 2 | |||||
36 | H | 24 | 7 | ||||
37 | B | 4 | |||||
38 | A | 2 | |||||
39 | D | 0 | |||||
40 | A | 2 | |||||
41 | C | 11 | |||||
42 | A | 2 | |||||
43 | C | 11 | |||||
44 | A | 2 | |||||
45 | G | 1 | |||||
46 | A | 2 | |||||
47 | A | 2 | |||||
48 | C | 11 | |||||
49 | C | 11 | 6 | ||||
50 | A | 2 | |||||
51 | A | 2 | |||||
52 | B | 4 | |||||
53 | D | 0 | |||||
54 | A | 2 | |||||
55 | A | 2 | |||||
56 | B | 4 | 5 | ||||
57 | E | 3 | 4 | ||||
58 | A | 2 | 3 | ||||
59 | G | 1 | 2 | ||||
60 | D | 0 | 1 | ||||
Thank you all
I am using Excel 2000
Regards,
Moti