so im wondering, if i have ten records listed like this
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??