Hi

Two Questions:

1. Does Excel Support Java?

2. I have a spreadsheet as follows:

id name id address
01 bob 02 12 street...
02 sam 03 14 street...

want it to be

id name address
01 bob null
02 sam 12 street

So, is there a way for Excel to compare id in column 1 with id in column 3,
and for every match extract the address, if no match put a null for address.


Thanks in advance
ZOCOR



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.737 / Virus Database: 491 - Release Date: 11/08/2004

Hi Zocor;

I'm not for sure about the java. For the ID's you can use
something like this;



Sub try()

Range("A2").select
While Not activecell = ""

If activecell = activecell.offset(0,2) then

'copy the address
MyAddress = activecell.offset(0,3)
'right here go put it where you want it
' and then return to the active cell

end if

activecell.offset(1,0).select



End Sub


Thanks,

Greg



-----Original Message-----
Hi

Two Questions:

1. Does Excel Support Java?

2. I have a spreadsheet as follows:

id name id address
01 bob 02 12 street...
02 sam 03 14 street...

want it to be

id name address
01 bob null
02 sam 12 street

So, is there a way for Excel to compare id in column 1
with id in column 3,
and for every match extract the address, if no match put
a null for address.


Thanks in advance
ZOCOR



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.737 / Virus Database: 491 - Release Date:
11/08/2004


.

It doesn't support JAVA specifically. I would assume Java could automate it
as a COM application.

for you second question.

you can copy your first list and then use vlookup with it for the second

assume you put ID and Name on Sheet2 starting in A1 and ID and address are
on Sheet1 in C1:D200

in C1 of Sheet2
=if(iserror(match(A1,Sheet1!$C$1:$C$200,0)),"Null" ,Vlookup(A1,Sheet1!$C$1:$D
$200,2,false))

then drag fill this down the column.

--
Regards,
Tom Ogilvy

"ZOCOR" wrote in message
...
Hi

Two Questions:

1. Does Excel Support Java?

2. I have a spreadsheet as follows:

id name id address
01 bob 02 12 street...
02 sam 03 14 street...

want it to be

id name address
01 bob null
02 sam 12 street

So, is there a way for Excel to compare id in column 1 with id in column
3,
and for every match extract the address, if no match put a null for
address.


Thanks in advance
ZOCOR



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.737 / Virus Database: 491 - Release Date: 11/08/2004

"ZOCOR" wrote in message
...
Hi

Two Questions:

1. Does Excel Support Java?


Not directly but you can automate it from Java
via COM

http://support.microsoft.com/default...b;EN-US;169796

Keith




----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---