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!
|