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.

[Miguel Zapico]

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.

"b166er" wrote:

>
> 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.
>
>
> --
> b166er
> ------------------------------------------------------------------------
> b166er's Profile: http://www.excelforum.com/member.php...o&userid=34912
> View this thread: http://www.excelforum.com/showthread...hreadid=552776
>
>