Re: $$Excel-Macros$$ Formula required please

2013-08-26 Thread Rajan sharma
Thanks Premor sir, Fantastic, Hats off to ur UDF.. thanks a ton. With warm regards, Rajan Sharma On Mon, Aug 26, 2013 at 4:40 PM, De Premor wrote: > Try this using UDF > > Function SUMPB(Amount As Range, Unit As Range, RngCriteria As Range, > Criteria As String) > Dim i As Long, F

Re: $$Excel-Macros$$ Formula required please

2013-08-26 Thread Rajan sharma
Dear Premor sir, Can your formula provided be done by Vba Macros. Actually i have many sheets to update your formula, so that it makes effect to all the sheets. With warm regards, Rajan Sharma On Mon, Aug 26, 2013 at 3:10 PM, Rajan sharma wrote: > Dear Premor sir, > > Exactly matching

Re: $$Excel-Macros$$ Formula required please

2013-08-26 Thread Rajan sharma
Dear Premor sir, Exactly matching as per my requirement. Thanks a ton. even the formulas are long it gives my solution. With warm regards, Rajan Sharma On Mon, Aug 26, 2013 at 2:55 PM, De Premor wrote: > Hi Rajan, try this long formula on Cell S2 or Just see at attached > workbo

Re: $$Excel-Macros$$ Formula required please

2013-08-26 Thread Rajan sharma
Some body can help me for creating the formula please With warm regards, Rajan Sharma On Mon, Aug 26, 2013 at 1:58 PM, Rajan sharma wrote: > Dear experts, > > I am struggling in one formula steps, please help me out. please find the > attachment for more information, please. > > Actaully

$$Excel-Macros$$ Formula required please

2013-08-26 Thread Rajan sharma
Dear experts, I am struggling in one formula steps, please help me out. please find the attachment for more information, please. Actaully i want a formula which gives me like R column, please forget about P, Q, R coloumn. P, Q are only helping column for me, so that i can elaborate you all the