L
LiAD
I have seen similar answers below but for some reason i can't get the other
approaches to work for my problem. I have a list of data in coumns A and B
which I need to count how many times certain combinations occur. For example:
6 M
6 M
7 M
8 E
9 M
Results: 6 and M - 2, 7 and M - 1, 8 and M - 0, 8 and M - 1 etc
I need excel to count the number of times that the cells have a combination
of say 6 and M or 8 and E for example. I have tried an AND with a countif
but without any success.
What is the simplest way to do this?
As a slight extension of this the numbers 6,7,8 etc come from a =month(a52)
formula for example. Ideally I would like a formula that looks does exactly
the same thing but counts the number of matches in June and M etc
1-Jun-07 M
2-Jun-07 M
10-Jun-07 M
12-Jun-07 E
2-Jul-07 M
12-Jul-07 M
12-Jul-07 M
In this case results would be-
June and M - 3, June and E - 1, July and M - 3
Is this getting to fancy or I am best to stick to extracting the month
sequence number and matching with that?
Thanks
LD
approaches to work for my problem. I have a list of data in coumns A and B
which I need to count how many times certain combinations occur. For example:
6 M
6 M
7 M
8 E
9 M
Results: 6 and M - 2, 7 and M - 1, 8 and M - 0, 8 and M - 1 etc
I need excel to count the number of times that the cells have a combination
of say 6 and M or 8 and E for example. I have tried an AND with a countif
but without any success.
What is the simplest way to do this?
As a slight extension of this the numbers 6,7,8 etc come from a =month(a52)
formula for example. Ideally I would like a formula that looks does exactly
the same thing but counts the number of matches in June and M etc
1-Jun-07 M
2-Jun-07 M
10-Jun-07 M
12-Jun-07 E
2-Jul-07 M
12-Jul-07 M
12-Jul-07 M
In this case results would be-
June and M - 3, June and E - 1, July and M - 3
Is this getting to fancy or I am best to stick to extracting the month
sequence number and matching with that?
Thanks
LD