Hi there,
im new here. i found here many aswers but now i have problem where i cant find way out :/
I have data:
<tbody>
</tbody>I would like to count how many unique values we have i typed function: =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
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.
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>
Now i would like to know, how many unique value we have in each day:
I have to get:
Mon. 3
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.