$$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 by

$$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 by

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 vijayajith...@gmail.com Sender: excel-macros@googlegroups.com Date: Fri, 15 Feb 2013 15:08:39 To: excel-macros@googlegroups.com Reply-To:

$$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 you

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

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 koul.ash...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 14 Feb 2013 21:40:48 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com

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

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 koul.ash...@gmail.com Sender: excel-macros@googlegroups.com Date: Fri, 1 Jul 2011 21:24:01 To: excel-macros@googlegroups.com Reply-To: