Solved

Count of deal numbers per member of staff

Posted on 2014-10-17
2
64 Views
Last Modified: 2014-10-17
Hi,

as you can see from the attached workbook, i have deal number in Col A, which can be single or multiple, in column D, there is the name, what i would like returned in Column F is the count of the number of people involved in a deal, i have manually input the numbers on the spreadsheet

Thanks
Book2.xlsx
0
Comment
Question by:Seamus2626
2 Comments
 
LVL 32

Accepted Solution

by:
Rob Henson earned 500 total points
ID: 40386422
In cell F2:

=COUNTIF($A:$A,$A2)

Copy down as far as required

Thanks
Rob H
0
 

Author Closing Comment

by:Seamus2626
ID: 40386435
Thanks!
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

776 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