Matt Pinkston
asked on
Excel Formula/Lookup help
I have an xls 2010 that has two tabs:
2014q1
PPM Assignments
In both tabs column A is a record ID. In 2014q1 it is unique and in PPM assignments there could be multiple.
What I would like to do is have column M in 2014q1 equal:
0 - if 2014q1 column A is not found in PPM Assignments column A
## - number of times 2014q1 column A is found in PPM Assignments column A
Thanks Much for Help
2014q1
PPM Assignments
In both tabs column A is a record ID. In 2014q1 it is unique and in PPM assignments there could be multiple.
What I would like to do is have column M in 2014q1 equal:
0 - if 2014q1 column A is not found in PPM Assignments column A
## - number of times 2014q1 column A is found in PPM Assignments column A
Thanks Much for Help
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER