Comparison of non-numeric arrays

[M Campbell]

Hi there,

Possibly I'm just being particularly dense because we're
coming up on a long weekend here in Canadaland, but I just
can't seem to find an answer for this. We've run some
reports on our network, and have two columns of results:
one listing all workstations in our organisation, and one
listing those who have completed a specific update.
Without manually going through these two lists to
eliminate the compliant machines, is there a function
whereby one can return the (non-numeric) values of the
unique cells in one column? Thanks very much,

M

 

[Frank Kabel]

Hi
use 'Data - Filter - Advanced Filter' and check 'unique Entries'