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