• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 251
  • Last Modified:

Excel Formula/Lookup help

I have an xls 2010 that has two tabs:
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
Matt Pinkston
Matt Pinkston
1 Solution
Naresh PatelTraderCommented:
Try this Copy past to Cell M2
=COUNTIF('PPM Assignments'!A:A,'2014q1'!A2)

Open in new window

Matt PinkstonAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now