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

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