Running X8. I have two columns with names in the cells. Is there a way to compare the two columns and have the same names highlighted, moved, or identified?
Your question got me thinking about the nature of spreadsheets. You are asking about comparing two one-dimensional columns (lists). A very complex macro might do this. However, generally a spreadsheet is in two dimensions. (And a Cross-Tab report aims for three dimensions.) You commonly would want the names to occupy the rows, and be placed in the left-most column, col A. The groups those people belong to would be placed in columns B and C, in the uppermost row, row 1. It would then be very easy to mark which individuals belong to the first group (col B), the second group (col C), or both (cols B and C). You could put a "1" in the relevant cells where the name intersects with the group. There would be multiple simple ways of presenting a table of the names that belong to both groups. For example, you could make a separate table that only picks up the relevant rows.
You could ask this over at WPUniverse.com. There are a few QP gurus that hang out there. Charles Cork is one and he sometimes checks in here as well. Some others find this OfficeCommunity forum too hard to navigate. I find that, too, but do pop in at times to try to help. Try posting at http://www.wpuniverse.com/vb/forumdisplay.php?51-Other-WordPerfect-Office-Programs - you have to register, but it's free.
Tom-tk said:I should not use this form but WordPerfect Universe instead?
You can use whichever you want. I prefer WPU as it seems busier and has several knowledgeable posters there to help. Again, the choice is yours as to the forum you use.