Require the modification delay formula result as shown in the column E

motilulla

Well-known Member
Joined
Feb 13, 2008
Messages
2,353
Office Version
  1. 2010
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

*ABCDEFG
1
2
360
4A To IGetting theseBut require this
5A To IDelay (A To I) ResultDelay result
6A1
7A2
8C11
9A2
10E3
11I499
12B4
13G1
14B4
15A2
16G1
17D0
18C11
19D0
20H24
21B4
22D0
23B4
24B4
25C11
26D0
27H24
28F328
29B4
30E3
31A2
32E3
33A2
34A2
35A2
36H247
37B4
38A2
39D0
40A2
41C11
42A2
43C11
44A2
45G1
46A2
47A2
48C11
49C116
50A2
51A2
52B4
53D0
54A2
55A2
56B45
57E34
58A23
59G12
60D01

Thank you all

I am using Excel 2000

Regards,
Moti
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
How about
+Fluff v2.xlsm
ABCDE
1
2
360
4A To IGetting theseBut require this
5A To IDelay (A To I) ResultDelay result
6A2 
7A2 
8C11 
9A2 
10E3 
11I499
12B4 
13G1 
14B4 
15A2 
16G1 
17D0 
18C11 
19D0 
20H24 
21B4 
22D0 
23B4 
24B4 
25C11 
26D0 
27H24 
28F328
29B4 
30E3 
31A2 
32E3 
33A2 
34A2 
35A2 
36H247
37B4 
38A2 
39D0 
40A2 
41C11 
42A2 
43C11 
44A2 
45G1 
46A2 
47A2 
48C11 
49C116
50A2 
51A2 
52B4 
53D0 
54A2 
55A2 
56B45
57E34
58A23
59G12
60D01
Main
Cell Formulas
RangeFormula
D6:D60D6=$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))))
E6:E60E6=IF(MAX((C6=C$6:C$5006)*(ROW(C$6:C$5006)))=ROW(),9-COUNTIF(E$5:E5,">0"),"")
Press CTRL+SHIFT+ENTER to enter array formulas.
 
Upvote 0
Solution
Wow! Fluff, it is resulting, as I wanted. I appreciate your kind help

Have a good week ahead.

Kind Regards,
Moti :)
 
Upvote 0

Forum statistics

Threads
1,213,506
Messages
6,114,025
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top