comparison

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

b166er - 16 Jun 2006 19:21 GMT

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.

Signature

b166er

Reply to this Message

Miguel Zapico - 16 Jun 2006 19:43 GMT

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 D1:D1000. 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.

> hi members
>
[quoted text clipped - 3 lines]
> to separate that selected workers. is there any function which could
> help me this regard.

Reply to this Message