Re: $$Excel-Macros$$ Dynamic Range for update chart Automatically

any solution? On Wed, Feb 13, 2013 at 5:55 PM, amar takale wrote: > Dear Champs, > > I here want to update chart when I put data in color cell then > automatically update chart with range.Currently I put data & change source > data range every time,it is time consuming work for So I wish to chan

Re: $$Excel-Macros$$ Minimum Value of particular columns to be highlighted

Thanks Pankaj On Wed, Feb 13, 2013 at 5:38 PM, pankaj sangotra wrote: > Hello Amit, > > Please find the aatched solution, please let me know if it works fine for > you.. > > Thanks > Pankaj Sangotra > > On Wed, Feb 13, 2013 at 11:15 AM, Amit Gandhi > wrote: > > Hi Experts > > > > I want to highl

Re: $$Excel-Macros$$ Minimum Value of particular columns to be highlighted

Thank Viper On Wed, Feb 13, 2013 at 5:36 PM, The Viper wrote: > pfa and check formula in conditional formating > > > On Wed, Feb 13, 2013 at 4:45 PM, Amit Gandhi wrote: > >> Hi Experts >> >> I want to highlight minimum value of some particular columns say columns >> D,H,L in attached file throu

$$Excel-Macros$$ out of service till 19 feb.

guys im out of state for a week . pls bear a late for a while. On 2/13/13, amar takale wrote: > Dear Champs, > > I here want to update chart when I put data in color cell then > automatically update chart with range.Currently I put data & change source > data range every time,it is time consumin

Re: $$Excel-Macros$$ Problem in conditional formatting *

Hello Pls see attached HTH On Wed, Feb 13, 2013 at 12:44 PM, Kenil Gala wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (keni...@yahoo.com) Add cleanup > rule

$$Excel-Macros$$ Re: convert Excel into pdf

Some free Excel to PDF converter software are also available on the Internet like freepdfconvert.com, doctopdf.net -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexc

Re: $$Excel-Macros$$ Role for Business Analyst in San Ramon ,CA

Hi Suatha, Please follow Rule no. 5 5) Jobs posting is not allowed On Wed, Feb 13, 2013 at 8:54 PM, sujatha malegaonkar wrote: > Dear Consultant, > Please let me know if you or you know any consultant available for the > below position. > > Role:Business Analyst > Duration :10 months + > Locat

$$Excel-Macros$$ Re: Problem in conditional formatting

Hi Kenil, Please follow the below steps. Select first column, go to conditional formatting. Edit the first rule: Change the formula as =$A1="Orange" Click OK Change applies to as =$A:$A Apply the same changes to the rest all. Hope you will get answer. Thanks and regards, Shekhar -- Are y

$$Excel-Macros$$ Problem in conditional formatting

 sorry forgot to attached the file in previous mail. Hi group, I am facing a small problem in conditional formatting. i am not able to set the same rules for the entire coloum. Pls find the file attached.   Thanks in adv. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna

$$Excel-Macros$$ Problem in conditional formatting

Hi group, I am facing a small problem in conditional formatting. i am not able to set the same rules for the entire coloum. Pls find the file attached.   Thanks in adv. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page

Re: $$Excel-Macros$$ Minimum Value of particular columns to be highlighted

Hello Amit, Please find the aatched solution, please let me know if it works fine for you.. Thanks Pankaj Sangotra On Wed, Feb 13, 2013 at 11:15 AM, Amit Gandhi wrote: > Hi Experts > > I want to highlight minimum value of some particular columns say columns > D,H,L in attached file through Cond

Re: $$Excel-Macros$$ Minimum Value of particular columns to be highlighted

pfa and check formula in conditional formating On Wed, Feb 13, 2013 at 4:45 PM, Amit Gandhi wrote: > Hi Experts > > I want to highlight minimum value of some particular columns say columns > D,H,L in attached file through Conditional Formatting. How it can be > possible? Pls help me here. > > Re

$$Excel-Macros$$ Minimum Value of particular columns to be highlighted

Hi Experts I want to highlight minimum value of some particular columns say columns D,H,L in attached file through Conditional Formatting. How it can be possible? Pls help me here. Regards Amit -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) !

Re: $$Excel-Macros$$ formula required

Dear Ganesh, Pls try it.. *=SUMIF($B$6:$B$17,"*"&F8,$C$6:$C$17)* see attachment, Hope it will help to you. -- With Regards, Noorain Ansari http:// noorainansari.com http:// excelvbaclinic.com

Re: $$Excel-Macros$$ Re: Count Names - Macro

Hi, Please explain your query, what is your exact requirement. -- With Regards, Noorain Ansari http:// noorainansari.com http:// excelvbaclinic.com On

Re: $$Excel-Macros$$ Divide Range into equal batches - Need Macro

Thanks a lot Noorain.. On Wed, Feb 13, 2013 at 4:29 PM, NOORAIN ANSARI wrote: > Dear Rahim, > > Please try it..see attachment. > > Sub Create_Batch() > Dim sh As Worksheet > Dim i As Long > Dim j As Long > Dim k As Long > Set sh = ThisWorkbook.Sheets("Sheet1") > j = sh.Cells(Rows.Count, "A").En

Re: $$Excel-Macros$$ Query: Charts

Dear Pankaj, Please try it.. *=OFFSET($B12,0,COUNTA($C$11:$P$11)-4,1,5)* see attached sheet for more clarity. -- With Regards, Noorain Ansari http:// noorainansari.com http:// excelvbaclinic

$$Excel-Macros$$ Query: Charts

Hi Experts, I have mention the details in the tab itself, Please do the needful.. Thanks Pankaj Sangotra -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM