| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| average daily counts to weekly counts | Excel Discussion (Misc queries) | |||
| counts | Excel Discussion (Misc queries) | |||
| Counts | Excel Discussion (Misc queries) | |||
| Counts | Excel Programming | |||
| Filtered counts | Excel Programming | |||
Linear Mode
