comparison  
Author Message
stringbean





PostPosted: Fri Jun 16 13:43:02 CDT 2006 Top

worksheet functions >> comparison

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.hide-link.com/ ;userid=34912
View this thread: http://www.hide-link.com/

Excel306  
 
 
MiguelZapico





PostPosted: Fri Jun 16 13:43:02 CDT 2006 Top

worksheet functions >> comparison 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
>
> 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?action=getinfo&userid=34912
> View this thread: http://www.excelforum.com/showthread.php?threadid=552776
>
>