booleanboolean
New Member
- Joined
- Feb 25, 2017
- Messages
- 37
Hello all,
I want to know if there is a VBA or Formula that will let me know how many unique values are in a certain column AND how many times that value appears in each column:
<colgroup><col span="7"></colgroup><tbody>
</tbody>
My project is to count how many times different shifts (5A-1P, 10P-6A, etc) occur EACH DAY. For example, 5A - 1P occurs occurs ONCE on Monday and ONCE on Tuesday, but 0 on Wednesday.
I have been doing this manually and it's such a pain on my eyes. I want to know if there is an easier way to do this via Macro or Formula.
THANKS!
I want to know if there is a VBA or Formula that will let me know how many unique values are in a certain column AND how many times that value appears in each column:
MON | TUE | WED | THU | FRI | SAT | SUN |
5a-1p | 5a-1p | OFF | OFF | 5a-1p | 5a-1p | 5a-1p |
OFF | 6a-2p | 6a-2p | 6a-2p | 6a-2p | 6a-2p | OFF |
OFF | OFF | 6a-2p | 6a-2p | 6a-2p | 6a-2p | 6a-2p |
8p-4a | 8p-4a | 8p-4a | OFF | OFF | 8p-4a | 8p-4a |
6a-2p | 6a-2p | 6a-2p | 6a-2p | OFF | OFF | 6a-2p |
6a-2p | 6a-2p | 6a-2p | 6a-2p | OFF | OFF | 6a-2p |
12p-8p | 12p-8p | OFF | OFF | 12p-8p | 12p-8p | 12p-8p |
6a-2p | OFF | OFF | 6a-2p | 6a-2p | 6a-2p | 6a-2p |
2p-10p | OFF | OFF | 2p-10p | 2p-10p | 2p-10p | 2p-10p |
2p-10p | 2p-10p | 2p-10p | 2p-10p | OFF | OFF | 2p-10p |
OFF | OFF | 2p-10p | 2p-10p | 2p-10p | 2p-10p | 2p-10p |
OFF | 2p-10p | 1215p-815p | 12p-8p | 2p-10p | 2p-10p | OFF |
OFF | 10p-6a | 10p-6a | 10p-6a | 10p-6a | 10p-6a | OFF |
10p-6a | OFF | OFF | 10p-6a | 10p-6a | 10p-6a | 10p-6a |
OFF | 2p-10p | 2p-10p | 2p-10p | 8p-4a | 8p-4a | OFF |
OFF | 9p-5a | 9p-5a | 9p-5a | 9p-5a | 9p-5a | OFF |
8p-4a | OFF | OFF | 8p-4a | 8p-4a | 8p-4a | 8p-4a |
OFF | 8p-4a | 8p-4a | 8p-4a | 8p-4a | 8p-4a | OFF |
8p-4a | 8p-4a | 8p-4a | 8p-4a | OFF | OFF | 8p-4a |
9p-5a | 9p-5a | 9p-5a | OFF | OFF | 9p-5a | 9p-5a |
10p-6a | 10p-6a | 10p-6a | OFF | OFF | 10p-6a | 10p-6a |
9p-5a | OFF | OFF | 9p-5a | 9p-5a | 9p-5a | 9p-5a |
<colgroup><col span="7"></colgroup><tbody>
</tbody>
My project is to count how many times different shifts (5A-1P, 10P-6A, etc) occur EACH DAY. For example, 5A - 1P occurs occurs ONCE on Monday and ONCE on Tuesday, but 0 on Wednesday.
I have been doing this manually and it's such a pain on my eyes. I want to know if there is an easier way to do this via Macro or Formula.
THANKS!