A new counting conundrum

B

Biff

Hi!

Try this in cell B2 and copy down:

=SUMPRODUCT((F$2:F$39=A2)/COUNTIF(G$2:G$39,G$2:G$39))

Biff
 
B

Biff

The formula works very well when Angel is differentiated
with Angel E. on one team, Angel F. on another and so on.
Click to expand...

Then why not do that?

The formula works based on unique employee names.

Biff
 
B

Biff

Hi!

I downloaded your Sample.xls file and saw what you had.
When I changed the formula to reference column F on the
DATA sheet everything worked just fine and returned the
same results that you have on the NEW sheet under ACTUAL
COUNT.

Angel and Angel are not unique to each other. Angel E and
Angel F are. When you list the employees you should
include their group as that creates a unique difference.

Biff
 
D

Dr. Vladimir Mindin

Hi!
Simple inelegant but reliable approach (see my previous message) gives
correct answer to this task, and more complicated tasks:
Andrea.......12
Banestiller...1
Beverli......13
Dawn.........14
Elaine........2
Eligio........2
Frantz.......13
Heather.......3
Karlisle......1
Larry........19
Leon.........17
Lorenzo......19
Lucas.........4
Marva.........1
Miriam........1
The only one requirement - data has to be sorted.
Regards
Vladimir Mindin
PS: Follow Don Guillett's remark: "Pls do NOT post a file here." I apologize
for posting file in my previous message.
Rgrds, VM
 
D

Dr. Vladimir Mindin

Thank you for clarification. Last question. There are no "manual
corrections or formatting to the data" in my approach, except sorting. Does
it mean that sorting is excluded too?
 
Top