Patrick, Are you wanting to duplicate the number or put a formula in there that combines numbers? Sorry, just woke up and still foggy. On Fri, Nov 18, 2011 at 3:17 AM, Patrick Wiggins <paw@wirelessbeehive.com>wrote:

I'd like to be able to open an Excel spread sheet and put a list of numbers in the first column and another list of numbers in the second column and Excel would then have any numbers that are in both columns appear in the 3rd column and the numbers that appear only in the 2nd column appear in the 4th column.

Anyone here know how to make Excel do that?

Or barring that, some other way to get the same result?

Many thanks,

patrick _______________________________________________ Utah-Astronomy mailing list Utah-Astronomy@mailman.xmission.com http://mailman.xmission.com/cgi-bin/mailman/listinfo/utah-astronomy Visit the Photo Gallery: http://www.slas.us/gallery2/main.php

-- Jay Eads

In column 3 use the concatenate function.  You can see how to use it in help. ________________________________ From: Patrick Wiggins <paw@wirelessbeehive.com> To: utah astronomy utah astronomy listserve <utah-astronomy@mailman.xmission.com> Sent: Friday, November 18, 2011 3:17 AM Subject: [Utah-astronomy] Numbers question I'd like to be able to open an Excel spread sheet and put a list of numbers in the first column and another list of numbers in the second column and Excel would then have any numbers that are in both columns appear in the 3rd column and the numbers that appear only in the 2nd column appear in the 4th column. Anyone here know how to make Excel do that? Or barring that, some other way to get the same result? Many thanks, patrick _______________________________________________ Utah-Astronomy mailing list Utah-Astronomy@mailman.xmission.com http://mailman.xmission.com/cgi-bin/mailman/listinfo/utah-astronomy Visit the Photo Gallery: http://www.slas.us/gallery2/main.php