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
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
Patrick, This is very easy to do in excel by using an "if" statement in a formula. I have sent under separate email instructions how to do this because I can't put attachments to this email. Thanks Rodger -----Original Message----- From: utah-astronomy-bounces@mailman.xmission.com [mailto:utah-astronomy-bounces@mailman.xmission.com] On Behalf Of Jay Eads Sent: Friday, November 18, 2011 6:21 AM To: Utah Astronomy Subject: Re: [Utah-astronomy] Numbers question 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 _______________________________________________ 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
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
Thanks to all who provided input and special thanks to Josephine Grahn who just emailed me a spreadsheet that works perfectly. I'm still working on understanding how it works but the important thing for me is that "it just works" and it's going to save me a bunch of very tedious, boring work in the future. Now if the skies will just clear so I can give it a try for real. Thanks again! patrick
participants (4)
-
Brent Watson -
Jay Eads -
Patrick Wiggins -
Rodger C. Fry