Does Excel Support Java?

Z

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
 
G

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
 
T

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 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.
 
Top