Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Excel Formula/Lookup help

Posted on 2014-02-21
2
Medium Priority
?
250 Views
Last Modified: 2014-02-21
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
0
Comment
Question by:Matt Pinkston
2 Comments
 
LVL 8

Accepted Solution

by:
Naresh Patel earned 2000 total points
ID: 39876182
Try this Copy past to Cell M2
=COUNTIF('PPM Assignments'!A:A,'2014q1'!A2)

Open in new window



Thanks
0
 

Author Closing Comment

by:Matt Pinkston
ID: 39876198
awesome
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question