M
MartiC
Here is my sample data:
A B C D
1 Date Name Rec VP
2 2/1 Jane Doe EM F. Charles
3 2/1 Don Duck LJ R. Lee
3 2/2 Minnie Lou SH F. Charles
4 2/2 Angel Wing EM R. Lee
5 2/5 Chris Carol LJ R. Lee
6 2/7 Holly Bugge LJ F. Charles
What I would like to be able to do is input a formula that will be able to
calculate the number of times an value in column C & column D occur (ie: LJ +
R. Lee = 2, LJ + F. Charles = 1).
I am able to get a total of how many times LJ occurs in column C or how many
times R. Lee occurs in column D but not how many times LJ & R. Lee occur at
the same time.
Does this make sense & can anyone help?
Thanks,
Marti
A B C D
1 Date Name Rec VP
2 2/1 Jane Doe EM F. Charles
3 2/1 Don Duck LJ R. Lee
3 2/2 Minnie Lou SH F. Charles
4 2/2 Angel Wing EM R. Lee
5 2/5 Chris Carol LJ R. Lee
6 2/7 Holly Bugge LJ F. Charles
What I would like to be able to do is input a formula that will be able to
calculate the number of times an value in column C & column D occur (ie: LJ +
R. Lee = 2, LJ + F. Charles = 1).
I am able to get a total of how many times LJ occurs in column C or how many
times R. Lee occurs in column D but not how many times LJ & R. Lee occur at
the same time.
Does this make sense & can anyone help?
Thanks,
Marti