2. Next, we will create 4 different series, one for each band defined above. Band 1 will be for values below 9. Band 2 for values between 9 and 14. Band 3 for values between 14 and 19. And Band 4 for values above 19. For that, add the following formulas into the respective cells:
F4 --> = IF(D4 <= $M$4,C4,NA())
G4 --> = IF(AND(D4 <= $M$5,D4 > $M$4),C4,NA())
H4 --> = IF(AND(D4 <= $M$6,D4 > $M$5),C4,NA())
I4 --> = IF(D4 > $M$6,C4,NA())
3. Select the range F4:I4, press Ctrl + C to copy the cells, then select cells F5:I54 and click Home > Paste and pick the Formulas paste option.
4. Select range F4:I54 and then click on the Align Right icon in the Alignment group on the Home tab. The traffic fatalities are now segregated into the 4 different bands and the worksheet should look like this: