Hey guys

so im wondering, if i have ten records listed like this

1

2.2

2.45

3.4

3.67

4

5

5.2

5.3

5.7

6.1

each number represents a defect on a road somewhere..i need a formula that will count up how many miles have defects on them. Defective miles being any mile that has a defect on it, whether its got 5 defects or just 1.

ideally the answer i get in excel will be that there are 6 defective miles in that chart above ; mile 1, mile 2 (2 records but still one mile) mile 3 ( 2 records still one defective mile), mile 4, mile 5 (with 4 records) and mile 6.

how do i do it, can i do it??

Advertisement