comparison

[b166er]

hi members

i want to compare 5000 rows of data with 1000 rows of data.
you may say i have got a list of 1000 selected workers for
training out of 5000. how can i compare that 1000 rows with 5000 rows
to separate that selected workers. is there any function which could
help me this regard.

 

[Guest]

You can use an additional column beside the 5000 rows with a formula like:
=COUNTIF($D$1:$D$1000,A1)
Supposing that the 1000 rows to compare are in D11000. That will be 0 if
the row is not in the group, more than 0 if it is. Then you can sort by this
column and you will have the desired group.

Hope this helps,
Miguel.