Here are formulas that will work for the problem as defined. There are also unique values in column A wich are not included in cols C & D C =IFERROR(INDEX($A$2:$A$55,MATCH(B3,$A$2:$A$55,0)),"") D =IF(C2="",INDEX($B$2:$B$55,MATCH(A2,$B$2:$B$55,0)),"") Copy the formulas to match Col B On Fri, Nov 18, 2011 at 11:53 PM, Josephine Grahn <bsi@xmission.com> wrote:
Ignore that question, I sent you something that may work for you, no matter which Excel you have. Jo
Quoting Josephine Grahn <bsi@xmission.com>:
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<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<Utah-Astronomy@mailman.xmission.com> http://mailman.xmission.com/**cgi-bin/mailman/listinfo/utah-**astronomy<http://mailman.xmission.com/cgi-bin/mailman/listinfo/utah-astronomy> Visit the Photo Gallery: http://www.slas.us/gallery2/**main.php<http://www.slas.us/gallery2/main.php>
______________________________**_________________ Utah-Astronomy mailing list Utah-Astronomy@mailman.**xmission.com<Utah-Astronomy@mailman.xmission.com> http://mailman.xmission.com/**cgi-bin/mailman/listinfo/utah-**astronomy<http://mailman.xmission.com/cgi-bin/mailman/listinfo/utah-astronomy> Visit the Photo Gallery: http://www.slas.us/gallery2/**main.php<http://www.slas.us/gallery2/main.php>
______________________________**_________________ Utah-Astronomy mailing list Utah-Astronomy@mailman.**xmission.com<Utah-Astronomy@mailman.xmission.com> http://mailman.xmission.com/**cgi-bin/mailman/listinfo/utah-**astronomy<http://mailman.xmission.com/cgi-bin/mailman/listinfo/utah-astronomy> Visit the Photo Gallery: http://www.slas.us/gallery2/**main.php<http://www.slas.us/gallery2/main.php>
-- Siegfried