Excel: Can you separate a series of numbers by even and odd


I have a large series of numbers that I need separated by even and odd numbers. Here is what the numbers look like. I have made the odd numbers red on the list below and the even numbers are black

19-11-1
19-11-2
19-11-3
19-11-4
19-12-1
19-12-2
19-12-3
19-12-4
19-13-1
19-13-2
19-13-3
19-13-4
19-14-1
19-14-2
19-14-3
19-14-4
The digit that determines if it is even or odd is the fourth number 19-14-1 When separating these I would like to separate the whole row. Any suggestions would be great. Thanks


This question generated 13 answers. To proceed to the answers, click here.

This thread is current as of May 09, 2018.


For more resources for Microsoft Excel