Does Excel Support Java?

[ZOCOR]

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

 

[GJones]

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

 

[Tom Ogilvy]

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 C1200

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.

 

[Keith Willshaw]

Hi

Two Questions:

1. Does Excel Support Java?

Not directly but you can automate it from Java
via COM

http://support.microsoft.com/default.aspx?scid=kb;EN-US;169796

Keith