subtotals maybe

[Sheila]

Hello,

How can I get Excel to tell me number of users when using
the subtotal command, in the following example:

Company User Name Function
A Rogers Input
A Miller Input
A Miller Update
A Adams Input
A Adams Update
A Adams Delete
B Johnson Input
B Jones Input
B Jones Update
B Smith Input
B Smith Update
B Smith Delete

I need to know how many and what users have 2 functions
like Input and Update. I already have an excel list and
have the data filtered and sorted properly. I filtered
the function to display those records with Input and
Update. Then I sorted by User. Now What??? Subtotals
isn't giving me the data I want. I would like to have
Miller and Adams for Company A and Jones and Smith for
Company B.

Thanks.

 

[Frank Kabel]

Hi
try the following formula in D2
=IF(B2<>B1,IF(SUMPRODUCT(($A$1:$A$100=A1)*($B$1:$B$100=B1)*($C$1:$C$100
="Update"))>=1,"User with both functions",""),"")
and copy down. This will flag all entries in column D which met your
criteria. After this you may filter with this column