Thread: Name lookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
wagz wagz is offline
external usenet poster
 
Posts: 21
Default 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!