Re: $$Excel-Macros$$ Need Conditioning Format Help

Dear Imran, Try it Change formula as per column. $B5$C5 and $B5$C5 On Mon, Jul 9, 2012 at 12:09 PM, Imran khan ikha...@gmail.com wrote: Hi, I need Conditioning format formula that IF Column BColumn C OR DE, FG etc some color should showed and IF Column CB, or ED etc some different

Re: $$Excel-Macros$$ please add me

Most welcome *Antham *in Excel Macro Groups. You can post your excel macro queries or solve queries of world wide users. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Mon, Jul 9, 2012 at 3:26 PM, An Tham antham...@gmail.com wrote: Dear Sir, I

$$Excel-Macros$$ create a multiple workbook - Reg

dear excel members, I want create a multiple workbooks based on conditions column a , different sheets i want stored nos 1 , 2 ,3 Thanks with -- *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex :Otteri, Vellore-2* -- FORUM RULES (986+ members already BANNED for

Re: $$Excel-Macros$$ create a multiple workbook - Reg

Dear Mothilal, Please explain more, I think you want to create different workbook based on a columns unique No. or other. On Mon, Jul 9, 2012 at 3:48 PM, jmothilal gjmothi...@gmail.com wrote: dear excel members, I want create a multiple workbooks based on conditions column a , different

Re: $$Excel-Macros$$ create a multiple workbook - Reg

yes, nos all 1 is one worksheets, nos 2 all another sheets . .. On Mon, Jul 9, 2012 at 3:51 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Mothilal, Please explain more, I think you want to create different workbook based on a columns unique No. or other. On Mon, Jul

Re: $$Excel-Macros$$ create a multiple workbook - Reg

i want create a based on the column a unique nos only On Mon, Jul 9, 2012 at 3:51 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Mothilal, Please explain more, I think you want to create different workbook based on a columns unique No. or other. On Mon, Jul 9, 2012 at 3:48

Re: $$Excel-Macros$$ create a multiple workbook - Reg

You really should not need to create separate sheets when you can simply use datafilterautofilterfilter col A for the desired. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: jmothilal Sent: Monday, July 09, 2012 5:18 AM To: excel-macros@googlegroups.com

RE: $$Excel-Macros$$ Re: Nokia PC Suit API !!

Thanks Bajrang It works J Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of B Sharma Sent: 09 July 2012 10:35 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Nokia PC Suit API !!

$$Excel-Macros$$ Re: Vlookup or Match formula - regionwise

Hi Sreejit, Please see the attachment i hope this will help you. regards prince 9891472849 On Sunday, 8 July 2012 20:55:24 UTC+5:30, Sreejith K. V wrote: Hi Team, Can someone please help me with the attached excel sheet. Regards Sreejith -- FORUM RULES (986+ members already BANNED

Re: $$Excel-Macros$$ Unique Name Query

Hi Deba, I found your solution working fine. regards prince 9891472849 On Saturday, 7 July 2012 12:00:10 UTC+5:30, Bhaity wrote: Hi Karan, PFA... Use this formula for unique extraction: =IFERROR(INDEX($A$1:$A$11,MATCH(0,COUNTIF($C$2:C2,$A$1:$A$11),0)),) And for counting unique

$$Excel-Macros$$ Re: Rajan Verma - Most helpful Member(June​'12)

Congrats rajan. regards prince dubey On Wednesday, 4 July 2012 21:46:48 UTC+5:30, Ayush Jain wrote: Hello Everyone, Rajan Verma has been selected as 'Most Helpful Member' for the month of June'2012. This is third time in row. :) He has posted 149 posts in June 2012 and helped many people

Re: $$Excel-Macros$$ macros code help

Dear Vijay, Try it Range(A1).Select Set Data = Range(Selection, Selection.End(xlToRight)) Data.Select See attached sheet.. On Mon, Jul 9, 2012 at 10:19 PM, vijayajith VA vijayajith...@gmail.comwrote: Hi All, Set data = Activewkst.Range(Cells(1, 1), Cells(2, data_input_Last_col)) Here

RE: $$Excel-Macros$$ need of free e-book

Thanks boss you r great !! From: rajanverma1...@gmail.com To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ need of free e-book Date: Thu, 28 Jun 2012 18:42:06 +0530 Download from here http://www.2shared.com/complete/CMFN-eEp/Building_Accounting_Systems_Us.html

$$Excel-Macros$$ Re: Unique Name Query

Hello Karan, In C2, with CTRL+SHIFT+ENTER, and copy down. =IFERROR(INDEX(A$2:A$100,MATCH(1,IF(A$2:A$100,IF(ISNA(MATCH(A$2:A$100,C$1:C1,0)),1)),0)),) If you need Unique Names in *Ascending Order*, In C2, with CTRL+SHIFT+ENTER, and copy down.

Re: $$Excel-Macros$$ Re: Unique Name Query

That was a very useful excel function.  Thanks for sharing this.    Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey Co. From: Haseeb A haseeb.avarak...@gmail.com To: excel-macros@googlegroups.com Sent: Tuesday, 10 July

$$Excel-Macros$$ no of sheets in a workbook

Dear Sir, Do we have a shortcut to know the number and name of the sheets in a workbook and also list them in sequence. Amit Kumar -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help,

Re: $$Excel-Macros$$ no of sheets in a workbook

Dear Amit, Please use this shortcut key: - Alt+A+A Regards, Kuldeep Singh Phone.: +91-120-4763789, Extn.: 789 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* On Tue, Jul 10, 2012 at 11:11 AM, amitkmr