ExcelBanter - Counts more than one

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Counts more than one (https://www.excelbanter.com/excel-programming/359696-counts-more-than-one.html)

dTHMTLGOD

Counts more than one

I would like to determine if I have more than one occurrence of two criteria

User CN
AA42171 Computer1
AA42171 Laptop1
AB44593 Computer1
AF45945 Computer1
DF86535 Computer1
DF86535 Computer2

I would like to pull if a user has both a Computer1 and Laptop1

Bob Phillips[_6_]

Counts more than one

Use conditional formatting on the first column with a formula of

=COUNTIF(A:A,A1)1

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"dTHMTLGOD" wrote in message
...
I would like to determine if I have more than one occurrence of two
criteria

User CN
AA42171 Computer1
AA42171 Laptop1
AB44593 Computer1
AF45945 Computer1
DF86535 Computer1
DF86535 Computer2

I would like to pull if a user has both a Computer1 and Laptop1

Stefi

Counts more than one

Maybe this can be a solution for you:
Enter in C2
=IF(ISERROR(MATCH(A2,A3:A7,0)),"",INDEX(B3:B7,MATC H(A2,A3:A7,0)))
and fill down as required.

User CN Additional machine
AA42171 Computer1 formula
AA42171 Laptop1 |
AB44593 Computer1 V
AF45945 Computer1
DF86535 Computer1
DF86535 Computer2

Regards,
Stefi

All times are GMT +1. The time now is 02:02 AM.