im new here. i found here many aswers but now i have problem where i cant find way out :/

I have data:

Day | ID (Number) |

Mon. | 111 |

Mon. | 111 |

Mon. | 222 |

Mon. | 333 |

Mon. | 111 |

Tue. | 222 |

Tue. | 111 |

Tue. | 555 |

Tue. | 666 |

Tue. | 777 |

Tue. | 333 |

Tue. | 222 |

Tue. | 999 |

Tue. | 888 |

Tue. | 888 |

<tbody>

</tbody>

**=SUM(IF(FREQUENCY(B3:B17;B3:B17)>0;1))**and it return value

**8**. What is OK.

Now i would like to know, how many unique value we have in each day:

I have to get:

**Mon. 3**

Tue. 5

Tue. 5

I've tried a lot of functions; combinations with IF statments, And statments, but i cant find right solution

I can get that numbers to use filters and then for each day use forumla above, but its very boring because i have 103 different days.

Tnx for help and stay cool.

N.