Hi, I seem to have fixed my problem. A macro did the job for me. Thanx Divyanshu
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pranav Lal Sent: Sunday, March 25, 2007 10:18 AM To: accessindia@accessindia.org.in Subject: Re: [AI] help with excel Hi, I am actually not too clear on what your problem is. You seem to want to replace a series of values with another series of values. I suggest you look at the if condition and see whether that helps. Pranav To unsubscribe send a message to [EMAIL PROTECTED] with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.17/732 - Release Date: 3/24/2007 4:36 PM -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.17/732 - Release Date: 3/24/2007 4:36 PM To unsubscribe send a message to [EMAIL PROTECTED] with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in