Hello,
I have two columns in my workbook
Column A - lists dates
Column B - lists route numbers
There are several duplicates since there is a row for each shipment done by the route each day.
I need a formula to tell me how many unique days the route operated. See below - BCG1A operated 1 day and BCG2A operated 1 day.
<colgroup><col><col></colgroup><tbody>
</tbody>
I have two columns in my workbook
Column A - lists dates
Column B - lists route numbers
There are several duplicates since there is a row for each shipment done by the route each day.
I need a formula to tell me how many unique days the route operated. See below - BCG1A operated 1 day and BCG2A operated 1 day.
<colgroup><col><col></colgroup><tbody> </tbody> | |||||||||||||||||||||||
<colgroup><col><col></colgroup><tbody>
</tbody>