Re: $$Excel-Macros$$ Query collation of data ignoring #n/a

Hi Vijay and Dhaval, This is not giving the right solution. Regards Pooja Sent from BlackBerry® on Airtel -Original Message- From: vijayajith VA Sender: excel-macros@googlegroups.com Date: Fri, 15 Feb 2013 15:08:39 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macro

$$Excel-Macros$$ Query collation of data ignoring #n/a

Hi All, I seek your guidance in the attached sheet, wherein, currently I am updating manually the column: I "Correct Cost Centre & Contracts".I am updating this from the data available in corresponding columns: D,E,F &G. Therefore, please guide with a formula which can extract the required data

$$Excel-Macros$$ Query collation of data ignoring #n/a

Hi All, I seek your guidance in the attached sheet, wherein, currently I am updating manually the column: I "Correct Cost Centre & Contracts".I am updating this from the data available in corresponding columns: D,E,F &G. Therefore, please guide with a formula which can extract the required data

Re: $$Excel-Macros$$ Condition with concatenate function

Thanks a lot Ashish for the support. Regards Pooja Sent from BlackBerry® on Airtel -Original Message- From: ashish koul Sender: excel-macros@googlegroups.com Date: Thu, 14 Feb 2013 21:40:48 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Condition with concate

Re: $$Excel-Macros$$ Condition with concatenate function

Thanks for this. One more query, if there are some blank cells in the range of cells on which this formula is applied, then is it possible, if an additional condition could be applied which can reflect N/A or 0 if the base cell is empty? Regards, Pooja Sharma Sent from BlackBerry® on Airtel -

$$Excel-Macros$$ Condition with concatenate function

Hi There, I seek for experts guidance on how I can apply a formula, wherein a condition is, when a second letter of an alphanumeric code is "M", then concatenate the cell with "6012" otherwise concatenate the cell with "6004". Regards, Pooja Sharma Sent from BlackBerry® on Airtel -- Are y

Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!

Congratulations to both of u. Regards, Pooja Sharma Sent from BlackBerry® on Airtel -Original Message- From: Ashish Bhalara Sender: excel-macros@googlegroups.com Date: Mon, 2 Jul 2012 14:35:19 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ MVP AwardCongra

Re: $$Excel-Macros$$ Introduce Yourself !!

Hi Excel Buddies! My name is Pooja Sharma, I'm from New Delhi. Working as Lead into Financial Closing and Reporting with a Gurgaon based MNC. Apart from my work, I like to travel, enjoy most forms of music, playing Table Tennis, Gardening. Excel plays major supportive role in accounting and repo

Re: $$Excel-Macros$$ I want to learn VBA

Hi All, Thanks for the prompt support. Regards Pooja Sharma Sent from BlackBerry® on Airtel -Original Message- From: ashish koul Sender: excel-macros@googlegroups.com Date: Fri, 1 Jul 2011 21:24:01 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ I want to lea