Solved

Count of deal numbers per member of staff

Posted on 2014-10-17
2
60 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 31

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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

746 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now