ExcelBanter - Counting data

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Counting data (https://www.excelbanter.com/excel-programming/396336-counting-data.html)

Hi All,

I am working in analysis company and I need help in this regard

B1 Startup
B2 Excess Idle
B3 Excess Idle
B4 Harsh Braking
B5 Speed
B6 Harsh Braking
B7 Ignition off
B8 Startup
B9 Harsh Braking
B10 Speed
B11 Speed
B12 Harsh Braking
B13 Excess Idle
B14 Ignition Off
I need that count of Excess Idle in C1 between B2 to B7, Count of Harsh
Braking in D1 between B2 to B7 and speed in E1 between B2 to B7 and move B7
to F1 and then remove all the status from B2 to B6 and then so on

Thanks & Regards

=COUNTIF($B$2:$B$7,"Excess Idle")

etc. but I didn't understand this bit ... and then remove all the status
from B2 to B6 and then so on

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Hassan" wrote in message
...
Hi All,

I am working in analysis company and I need help in this regard

B1 Startup
B2 Excess Idle
B3 Excess Idle
B4 Harsh Braking
B5 Speed
B6 Harsh Braking
B7 Ignition off
B8 Startup
B9 Harsh Braking
B10 Speed
B11 Speed
B12 Harsh Braking
B13 Excess Idle
B14 Ignition Off
I need that count of Excess Idle in C1 between B2 to B7, Count of Harsh
Braking in D1 between B2 to B7 and speed in E1 between B2 to B7 and move
B7
to F1 and then remove all the status from B2 to B6 and then so on

Thanks & Regards