Hello,

But my data are arranged like this:

x1 x2 x3 x4 x5
x6 x7 x8 x9 x10
x11 x12 x13 x14 x15

y1 y2 y3 y4 y5
y6 y7 y8 y9 y10
y11 y12 y13 y14 y15

So it's like I want to extract the y's that are not in the x's.

It's good to know that ADO can be used directly within Excel, but it seems
that it cannot be used in my case, right? At least not very directly. So
I'm wondering if there're any functions out there that can do this
extraction.

Thanks.

Herbert

"Tom Ogilvy" ¦b¶l¥ó
¤¤¼¶¼g...
Excel ranges can be treated like tables in Excel. So you can probably use
ADO to do the same thing.

http://support.microsoft.com/default...b;en-us;278973
SAMPLE: ExcelADO Demonstrates How to Use ADO to Read and Write Data in
Excel
Workbooks

--
Regards,
Tom Ogilvy


"Herbert Chan" wrote in message
...
It is an excel file and the data are in separate rectangular ranges.

Herbert

"Bob Phillips" ¦b¶l¥ó
¤¤¼¶¼g...
What is the definition of a set here?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Herbert Chan" wrote in message
...
Hello,

I've a spreadsheet in Excel and I have some data.

I want to be able to extract the data from set1 that are not in
set2.
In
Access, that will be a nonmatching query. However, in Excel, how do
I
do
it
with VBA function? Any written functions already out there?

Thanks.

Herbert