Which excel are you using, (i.e. 2003, 2007, 2010)? Depending on your version, I may have a solution... Jo Quoting Patrick Wiggins <paw@wirelessbeehive.com>:
On 18 Nov 2011, at 21:00, Chuck Hards wrote:
I'm just giving you good natured grief.
Understood. :)
I work with Excel every day, from accounting spreadsheets to Solidworks 3D design tables. A good time saving tool.
For those who might be interested I've posted a sample Excel file here: http://users.wirelessbeehive.com/~paw/temp/sample01.xls
Column A has numbers from the first run and column B has numbers from the second run.
The challenge is to design the spreadsheet so that the numbers that appear in both A and B be listed in C and the numbers that appear only in B be listed in D.
Cheers,
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