| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Name lookup
I have a list of all the users in a certain system in column "A". I have a
list of users that have logged in that same system in the past three months in column "C". I would like to compare the two columns and have a function tell me who has not logged in, in the past three months. So basically, if you don't match between a and c you are going to be deleted. Thanks in advance! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Name lookup
One way:
=IF(ISNA(VLOOKUP(A1,C:C,1,FALSE)),"Dormant","") or: =IF(COUNTIF(C:C,A1)=0,"Dormant","") Regards Trevor "wagz" wrote in message ... I have a list of all the users in a certain system in column "A". I have a list of users that have logged in that same system in the past three months in column "C". I would like to compare the two columns and have a function tell me who has not logged in, in the past three months. So basically, if you don't match between a and c you are going to be deleted. Thanks in advance! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Name lookup
Is does not seem to work. I pasted both formulas and the entire group shows
up as dormant. If it helps, both are email address. Thanks again. "Trevor Shuttleworth" wrote: One way: =IF(ISNA(VLOOKUP(A1,C:C,1,FALSE)),"Dormant","") or: =IF(COUNTIF(C:C,A1)=0,"Dormant","") Regards Trevor "wagz" wrote in message ... I have a list of all the users in a certain system in column "A". I have a list of users that have logged in that same system in the past three months in column "C". I would like to compare the two columns and have a function tell me who has not logged in, in the past three months. So basically, if you don't match between a and c you are going to be deleted. Thanks in advance! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Name lookup
Worked for me in a simple test. Perhaps you could post some sample data
Also depends on the source of the data. Could there be spaces at the beginning or end of the data? Regards "wagz" wrote in message ... Is does not seem to work. I pasted both formulas and the entire group shows up as dormant. If it helps, both are email address. Thanks again. "Trevor Shuttleworth" wrote: One way: =IF(ISNA(VLOOKUP(A1,C:C,1,FALSE)),"Dormant","") or: =IF(COUNTIF(C:C,A1)=0,"Dormant","") Regards Trevor "wagz" wrote in message ... I have a list of all the users in a certain system in column "A". I have a list of users that have logged in that same system in the past three months in column "C". I would like to compare the two columns and have a function tell me who has not logged in, in the past three months. So basically, if you don't match between a and c you are going to be deleted. Thanks in advance! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Name lookup
Could be due to absolute reference v/s relative reference
"wagz" wrote in message ... Is does not seem to work. I pasted both formulas and the entire group shows up as dormant. If it helps, both are email address. Thanks again. "Trevor Shuttleworth" wrote: One way: =IF(ISNA(VLOOKUP(A1,C:C,1,FALSE)),"Dormant","") or: =IF(COUNTIF(C:C,A1)=0,"Dormant","") Regards Trevor "wagz" wrote in message ... I have a list of all the users in a certain system in column "A". I have a list of users that have logged in that same system in the past three months in column "C". I would like to compare the two columns and have a function tell me who has not logged in, in the past three months. So basically, if you don't match between a and c you are going to be deleted. Thanks in advance! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Variable Lookup/Double Lookup | Excel Worksheet Functions | |||
| Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
| Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) | |||
| Advanced Lookup (lookup for 2 values) | Excel Worksheet Functions | |||
| Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
Hybrid Mode
