Re: $$Excel-Macros$$ Extract Names which are not common

2013-08-22 Thread ravinder negi
try this formula or attached file =IFERROR(INDIRECT("d"&SMALL(IF(IF(COUNTIF($E$3:$E$5,$D$3:$D$8)=0,1,0)*ROW($D$3:$D$8)>0,ROW($D$3:$D$8)),ROW(A1))),"") From: santosh subudhi To: excel-macros Sent: Thursday, August 22, 2013 4:55 AM Subject: $$Excel-Macros$$ Ex

Re: $$Excel-Macros$$ Sum if array for cut dates

2013-08-22 Thread Ali Abbas
dear sir formula not work plz help. On Aug 22, 2013 5:34 PM, "Ali Abbas" wrote: > thanks brother > On Aug 22, 2013 4:14 PM, wrote: > >> ** >> You can use sumproduct also >> >> =sumproduct(--(and((a:a)>=c1,(a:a)<=c2),b:b) >> >> Assuming dates are in a row , amount are in b row. C1=smaller cutoff

Re: $$Excel-Macros$$ Behind code of Sum function in VBA

2013-08-22 Thread Pavan Chowdary
De Promor, Could you please check that code by giving hadcoded values in the fomula? like xsum ( 1,2,3). it is not working. i want to have a function which works eighther for range and for range and for both. Thanks for your work on this. -Pavan On Thu, Aug 22, 2013 at 6:15 PM, De Premor wrote

Re: $$Excel-Macros$$ define sort range

2013-08-22 Thread Peter Konijn
Thank a lot Your code works fine Kind regards Peter 2013/8/22 De Premor > try this code > > Sub sort() > Dim Str() As String > Str = Split([G4], ":") > With ActiveSheet.sort > .SortFields.Add Key:=Range(Str(0)) > .SetRange Range([G4]) > .Apply > End W

Re: $$Excel-Macros$$

2013-08-22 Thread xlstime
Hi Ali, We can use Sumifs or Sumproduct =SUMPRODUCT(($B$1:$B$27>=41317)*($B$1:$B$27<=41325),$A$1:$A$27) =SUMIFS($A$1:$A$27,$B$1:$B$27,">="&41317,$B$1:$B$27,"<="&41325) . Enjoy Team XLS On Thu, Aug 22, 2013 at 8:33 PM, Ali Abbas wrote: > Dear all. How can we calcula

Re: $$Excel-Macros$$ Sum if array for cut dates

2013-08-22 Thread Ali Abbas
thanks brother On Aug 22, 2013 4:14 PM, wrote: > ** > You can use sumproduct also > > =sumproduct(--(and((a:a)>=c1,(a:a)<=c2),b:b) > > Assuming dates are in a row , amount are in b row. C1=smaller cutoff date > and c2=latest date . > > Hope it works for you! :) > Sandeep > Sent on my BlackBerry®

Re: $$Excel-Macros$$ Sum if array for cut dates

2013-08-22 Thread chhajersandeep
You can use sumproduct also =sumproduct(--(and((a:a)>=c1,(a:a)<=c2),b:b) Assuming dates are in a row , amount are in b row. C1=smaller cutoff date and c2=latest date . Hope it works for you! :) Sandeep Sent on my BlackBerry® from Vodafone -Original Message- From: Ali Abbas Sender:

$$Excel-Macros$$ Sum if array for cut dates

2013-08-22 Thread Ali Abbas
Date: 1 2 3 4 Amount: 100 200 300 400 Now formula working. We can calculate value with array sum amount if date 1 to 3 then answer is 600 but if we change date scenario and mention date in cut day like sum amount if date is 2 to 4 then its answer will be 900 but how can I make th

$$Excel-Macros$$

2013-08-22 Thread Ali Abbas
Dear all. How can we calculate a array function for sum amount or any figure for cut dates like sum if( 12 feb to 20 feb) -- 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/discu

Re: $$Excel-Macros$$ Behind code of Sum function in VBA

2013-08-22 Thread De Premor
Try this and explore it Function xSum(ParamArray Numbers()) As Variant Dim BlockRange, SingleRange, Buffer For Each BlockRange In Numbers For Each SingleRange In BlockRange Buffer = Buffer + SingleRange Next Next xSum = Buffer End Function Pada 22/08/

Re: $$Excel-Macros$$ define sort range

2013-08-22 Thread De Premor
try this code Sub sort() Dim Str() As String Str = Split([G4], ":") With ActiveSheet.sort .SortFields.Add Key:=Range(Str(0)) .SetRange Range([G4]) .Apply End With End Sub Pada 22/08/2013 18:39, Pekon menulis: Dear experts I hope that you can help me. I

$$Excel-Macros$$ Behind code of Sum function in VBA

2013-08-22 Thread Pavan Valluru
Hi Guys, Hope all are doing well. Here comes the subject. I am trying to get the code behing sum function. I searched for the but all went vain. I tried using Paramarray but it is not working when we are refering to a paraticular range. i want to write a function which really works like sum fu

Re: $$Excel-Macros$$ Extract Names which are not common

2013-08-22 Thread Deepak Barnwal
Dear Santosh, PFA solution of your problem. Regards Deepak On Thu, Aug 22, 2013 at 2:16 PM, santosh subudhi < santoshkumar.subu...@gmail.com> wrote: > Hi Anil, > > Thanks for your prompt reply. > > However the solution did't solve my problem. > > I have attached the solution sheet with desire

$$Excel-Macros$$ define sort range

2013-08-22 Thread Pekon
Dear experts I hope that you can help me. In the attachment you will find an example file. I try to to sort a part of the worksheet with a macro. For some reason I cannot use a refer to cell G4 (with the range of the table to be sorted) in the macro. Who can give me the right code? Kind Re

RE: $$Excel-Macros$$ Extract Names which are not common

2013-08-22 Thread santosh subudhi
Hi Anil, Thanks for your prompt reply. However the solution did't solve my problem. I have attached the solution sheet with desired result. -- Regards Santosh santoshkumar.subu...@gmail.com Date: Thu, 22 Aug 2013 09:58:48 +0530 > Subject: Re: $$Excel-Macros$$ Extract Names which are not commo

Re: $$Excel-Macros$$ Which cell color and font color combination is suitable to show negative value.

2013-08-22 Thread Waseem Saifi
thanx Anil :) On Thu, Aug 22, 2013 at 12:05 PM, अनिल नारायण गवली wrote: > Dear Waseem, > > Mostly font color should be black and cell color should be red for > negative. > positive:- font color should be black and cell color should be gree. > > > Warm Regards, > Gawli Anil. > Thanks & Regards,