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