Presuming that there's no duplicate account numbers in either Sheet1's data
or in Sheet2's data, you could try this easy formulas option to carve out the
expected results

In Sheet3,
In A2 down, do a copy n paste of the data from Sheet1/2, one below the other
(the pastes can be in any sequence). Done in 5 secs flat.

Put in B2:
=IF(AND(COUNTIF(A:A,A2)=2,COUNTIF(A$2:A2,A2)<2),R OW(),"")

Put in C2:
=IF(ROWS($1:1)COUNT(B:B),"",INDEX(A:A,SMALL(B:B,R OWS($1:1))))
Copy B2:C2 down to the last row of data in col A. Hide/minimize col B. Col A
will return the expected results all neatly packed at the top. Success? hit
the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Roadtripper902902V3V" wrote:
Or if it would be easier to have all the info on one sheet,
I could put info on Sheet 2 into some columns on Sheet 1. And I do not mind
having the Sheet3 data (the "pairs") onto some colum(s) on sheet 1, as well.