$$Excel-Macros$$ Formula required

Hello Group Members Will you help me to put formula in column E & F in the attached file as mentioned in column H. I will be very thankful to you for the same. -- 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

$$Excel-Macros$$ formula required query

Dear Sir Formula required as per the attachment in sheet "2". Thanks in advance for your help. Regards -- *Rajesh Kumar Agarwal* *9811063001* -- 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:/

Re: $$Excel-Macros$$ formula required

According to the condition the formula is perfect but if you have few more minutes can you please explain this formula thank you very much for this -- 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 @ ht

Re: $$Excel-Macros$$ formula required

try enclosed one -- Thanks & Regards, Sunny Chauhan E-Mail :- sunnyc...@gmail.com , 9540025528, On Sun, Jul 10, 2016 at 2:17 PM, Izhar wrote: > I need formula in cell C10:C14 > Please check the conditions > Thanks in advance > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do yo

$$Excel-Macros$$ formula required

I need formula in cell C10:C14 Please check the conditions Thanks in advance -- 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 RULES 1) Use concise, accurat

Re: $$Excel-Macros$$ Formula required

Its working fine. Thanks for the help. Regards Rajesh Agarwal On Thursday, June 23, 2016 at 9:50:57 AM UTC+5:30, a.gowri wrote: > > ​you can try this, > > 1 > =SUM(IF(RANK($A$2:$A$21,$A$2:$A$21,1)=(RANK($B$21,$A$2:$A$21,1)-1),$A$2:$A$21)) > 2 > =SUM(IF(RANK($A$2:$A$21,$A$2:$A$21,1)=(RANK($B$21

Re: $$Excel-Macros$$ Formula required

​you can try this, 1 =SUM(IF(RANK($A$2:$A$21,$A$2:$A$21,1)=(RANK($B$21,$A$2:$A$21,1)-1),$A$2:$A$21)) 2 =SUM(IF(RANK($A$2:$A$21,$A$2:$A$21,1)=(RANK($B$21,$A$2:$A$21,1)-2),$A$2:$A$21)) 3 =SUM(IF(RANK($A$2:$A$21,$A$2:$A$21,1)=(RANK($B$21,$A$2:$A$21,1)+1),$A$2:$A$21)) 4 =SUM(IF(RANK($A$2:$A$21,$A$2:$A

Re: $$Excel-Macros$$ Formula required

IF YOU SORT YOUR DATAthen you can use the MATCH() function to find the row number that matches the value in cell B21.Using this value, you can then use the index() function to return the values 1 and 2 rows from that cell.Like: C21: =INDEX(A2:A21,MATCH(B21,A2:A21)-1) D21: =INDEX(A2:A21,MATCH(B21

Re: $$Excel-Macros$$ Formula required

formula required as mentioned in column D19. On Friday, June 17, 2016 at 6:28:10 PM UTC+5:30, Vikas Verma wrote: > > plz provide more clearity?? about your query > > Thanks & regards, > > www.MrExcel4U.com > > On Fri, Jun 17, 2016 at 5:26 AM, Rajesh Agarwal >

Re: $$Excel-Macros$$ Formula required

plz provide more clearity?? about your query Thanks & regards, www.MrExcel4U.com On Fri, Jun 17, 2016 at 5:26 AM, Rajesh Agarwal wrote: > Dear Sir > > please help me by resolving the issue. > > -- > *Rajesh Kumar Agarwal* > *9811063001* > > -- > Are you =EX

Re: $$Excel-Macros$$ Formula required

Hi, PFA On 17 June 2016 at 17:56, Rajesh Agarwal wrote: > Dear Sir > > please help me by resolving the issue. > > -- > *Rajesh Kumar Agarwal* > *9811063001 <9811063001>* > > -- > 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 Face

$$Excel-Macros$$ Formula required

Dear Sir please help me by resolving the issue. -- *Rajesh Kumar Agarwal* *9811063001* -- 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 RULES 1) Use con

Re: $$Excel-Macros$$ FORMULA REQUIRED

ou can, As long as ever you can.” - John Wesley - From: Izhar To: excel-macros@googlegroups.com Sent: Friday, October 23, 2015 11:37 AM Subject: $$Excel-Macros$$ FORMULA REQUIRED As you may see I have already used different cell reference for

$$Excel-Macros$$ FORMULA REQUIRED

As you may see I have already used different cell reference for summing up the UNIT and COST but I need a formula from which when I type and take the reference of all the cell i.e. A3:H3 under the heading of UNIT and same under the heading of COST, there must be a sum of the respective field in th

Re: $$Excel-Macros$$ FORMULA REQUIRED

Thank you very much for your quick response, I really appreciate it. once again thank you for your help On Thursday, 30 July 2015 20:43:01 UTC+5, Pankaj Sharma wrote: > > use this > > =INDEX($L$2:$R$87,MATCH($B2,$K$2:$K$87,0),MATCH($C2,$L$1:$R$1,0)) > > or > > if you don't want to see #N/A error

Re: $$Excel-Macros$$ FORMULA REQUIRED

use this =INDEX($L$2:$R$87,MATCH($B2,$K$2:$K$87,0),MATCH($C2,$L$1:$R$1,0)) or if you don't want to see #N/A error so use this one =IFERROR(INDEX($L$2:$R$87,MATCH($B2,$K$2:$K$87,0),MATCH($C2,$L$1:$R$1,0)),"-") *Regards,* *PJ* On Thu, Jul 30, 2015 at 8:01 PM, Izhar wrote: > I need fig

$$Excel-Macros$$ FORMULA REQUIRED

I need figure in color column, the figure must be taken from column L to column R into the column G on the bases of article number, color and size. As an example I have put some figures in column G manually, these figures may be find in column L to R, I understand that the function we may use over

Re: $$Excel-Macros$$ formula required

Author need formula & i guess this is already answered for similar question.. On Sun, May 3, 2015 at 7:37 PM, Rajesh Agarwal wrote: > please provide me the formula. > > -- > *Rajesh Kumar Agarwal* > *9811063001* > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >

$$Excel-Macros$$ formula required

please provide me the formula. -- *Rajesh Kumar Agarwal* *9811063001* -- 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 RULES 1) Use concise, accurate thr

$$Excel-Macros$$ formula required in column D & E

Hello Sir formula required in both the column matching. -- *Rajesh Kumar Agarwal* *9811063001* -- 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 RULES 1)

$$Excel-Macros$$ formula required in column c excluding Zero

Hello Sir formula required -- *Rajesh Kumar Agarwal* *9811063001* -- 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 RULES 1) Use concise, accurate thread

$$Excel-Macros$$ formula required in both the sheets

dear sir formula required in both the sheets as per mentioned in sheet 1. -- *Rajesh Kumar Agarwal* *9811063001* -- 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

Re: $$Excel-Macros$$ formula required

PFA... On Fri, Apr 3, 2015 at 12:06 PM, Rajesh Agarwal wrote: > Hi > Required formula in B1 > > -- > Rajesh Kumar Agarwal > 9811063001 > > -- > 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 @ > h

$$Excel-Macros$$ formula required

Hi Required formula in B1 -- *Rajesh Kumar Agarwal* *9811063001* -- 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 RULES 1) Use concise, accurate thread t

Re: $$Excel-Macros$$ Formula required

Check this... On Tue, Mar 31, 2015 at 12:43 PM, Dhaval Shah wrote: > PFA > > Warm Regards, > > Dhaval Shah > M) 98240 35253 > *E-mail : todhavals...@gmail.com * > > > -- > 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 pa

$$Excel-Macros$$ Formula required

PFA Warm Regards, Dhaval Shah M) 98240 35253 *E-mail : todhavals...@gmail.com * -- 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 RULES 1) Use concise, ac

Re: $$Excel-Macros$$ Formula Required

Cheers!! On Thu, Jul 10, 2014 at 12:17 PM, amar takale wrote: > thanks vabs brother > > On Tue, Jul 8, 2014 at 10:33 PM, Vaibhav Joshi wrote: > > Hi > > > > Check this.. cell in green is what you want.. > > > > Cheers!! > > > > > > On Tue, Jul 8, 2014 at 7:14 PM, amar takale > wrote: > >> > >

Re: $$Excel-Macros$$ Formula Required

thanks vabs brother On Tue, Jul 8, 2014 at 10:33 PM, Vaibhav Joshi wrote: > Hi > > Check this.. cell in green is what you want.. > > Cheers!! > > > On Tue, Jul 8, 2014 at 7:14 PM, amar takale wrote: >> >> Dear experts >> >> I want date formula.I try it but with 2 cell help but I think it is >> n

Re: $$Excel-Macros$$ Formula Required

r you can.” - John Wesley - > > From: amar takale >To: excel-macros@googlegroups.com >Sent: Tuesday, July 8, 2014 9:44 AM >Subject: $$Excel-Macros$$ Formula Required > > >Dear experts > >I wa

Re: $$Excel-Macros$$ formula required in D column

Hi Rajesh Please find the attachment. Is this what you are looking for? On Tue, Dec 3, 2013 at 3:53 AM, Rajesh Agarwal wrote: > > > -- > *Rajesh Kumar Agarwal* > *9811063001* > > -- > 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 officia

$$Excel-Macros$$ formula required in D column

-- *Rajesh Kumar Agarwal* *9811063001* -- 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 RULES 1) Use concise, accurate thread titles. Poor thread titles,

Re: $$Excel-Macros$$ Formula Required

another way :) =UPPER(LEFT(A2,1)&LEFT(TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",99)),99)))&TEXT(B2,"DDMM")&LEFT(C2,1)&RIGHT(C2,1)) On 22-10-2013 17:51, Anoop K Sharma wrote: PFA updated with little change as described above. On Tue, Oct 22, 2013 at 4:18 PM, Anoop K Sharma mailto:aks.sharm.

Re: $$Excel-Macros$$ Formula Required

PFA updated with little change as described above. On Tue, Oct 22, 2013 at 4:18 PM, Anoop K Sharma wrote: > As Requested, PFB the solved one. > > Regards, > Anoop > Sr. Developer > > > On Tue, Oct 22, 2013 at 3:36 PM, xlstime wrote: > >> please share the example >> >> .

Re: $$Excel-Macros$$ Formula Required

As Requested, PFB the solved one. Regards, Anoop Sr. Developer On Tue, Oct 22, 2013 at 3:36 PM, xlstime wrote: > please share the example > > . > > Enjoy > Team XLS > > > > On Tue, Oct 22, 2013 at 10:28 AM, Prabhakar Thakur < > prabhakarthak...@gmail.com> wrote: > >> D

Re: $$Excel-Macros$$ Formula Required

Hi, Example like this Name Dob Town Ex Ram Kumar 15-Oct Kota RK15102013KA Ram kumar Mishra 18-Sep Patna RM18091988PA Ram rajat kumar Mishra 20-Jul Delhi RM20072013DI Thanks, Prabhakar Thakur New Delhi +919953736776 On Tue, Oct 22, 2013 at 3:36 PM, xlstime wrote: > please share

Re: $$Excel-Macros$$ Formula Required

please share the example . Enjoy Team XLS On Tue, Oct 22, 2013 at 10:28 AM, Prabhakar Thakur < prabhakarthak...@gmail.com> wrote: > Dear Team, > > > > > > I need a formula for create unique ID. > > > > Unique ID=first character of first Name + last name first character

$$Excel-Macros$$ Formula Required

Dear Team, I need a formula for create unique ID. Unique ID=first character of first Name + last name first character + dob + first & character of Home Town. Name Dob Town Ram Kumar 15-Oct Kota Ram kumar Mishra 18-Sep Patna Ram rajat kumar Mishra 20-Jul Delhi Thanks, Prabh

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

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

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

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

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

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

Fwd: $$Excel-Macros$$ formula required to update values form one sheet to another sheet with date criteria

Dear Lerner Not Understood.. Because it's getting updated in the file sent by me. Regards Pravin Gunjal. -- Forwarded message -- From: excel lerner Date: Sat, Jul 20, 2013 at 10:15 AM Subject: Re: $$Excel-Macros$$ formula required to update values form one sheet to an

Re: $$Excel-Macros$$ formula required to update values form one sheet to another sheet with date criteria

-- > From: excel lerner > Date: Fri, Jul 19, 2013 at 2:43 PM > Subject: Re: $$Excel-Macros$$ formula required to update values form one > sheet to another sheet with date criteria > To: excel-macros > > > thanks for suggestion.can u explain > > > On

Re: $$Excel-Macros$$ formula required to update values form one sheet to another sheet with date criteria

thanks for suggestion.can u explain On Fri, Jul 19, 2013 at 2:38 PM, Pravin Gunjal wrote: > Pl use v-lookup. > > -- Forwarded message -- > From: excel lerner > Date: Fri, Jul 19, 2013 at 10:20 AM > Subject: $$Excel-Macros$$ formula required to update values f

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

Abhi, Thx for quick reply. Thanks again. Rgds, IQbal On 1 April 2013 12:29, Abhishek Jain wrote: > =IF(AND(D2>=C2,L2=1),"Winner","Looser") > > Drag down. > > > > On Mon, Apr 1, 2013 at 12:21 PM, Shaikh Iqbal wrote: > >> Dear Export , >> >> Please find attached file & help on formula. >>

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

=IF(AND(D2>=C2,L2=1),"Winner","Looser") Drag down. On Mon, Apr 1, 2013 at 12:21 PM, Shaikh Iqbal wrote: > Dear Export , > > Please find attached file & help on formula. > > > > > > > > > Iqbal > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N

$$Excel-Macros$$ Formula required help

Dear Export , Please find attached file & help on formula. Iqbal -- 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 RULES 1) Use concise, accurate t

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$$ formula required

Hi Prashant, Please receive the file with solution, please revert back if you want something else. Thanks --- On Mon, 1/14/13, Prashant Pawle wrote: From: Prashant Pawle Subject: $$Excel-Macros$$ formula required To: excel-macros@googlegroups.com Date: Monday, January 14, 2013, 12:19 PM Dear

Re: $$Excel-Macros$$ formula required

Dear Prashant, Please use this.. SUMPRODUCT(($D$2:$D$5=A7)*($G$2:$M$5)) Regard Manoj On Mon, Jan 14, 2013 at 12:19 PM, Prashant Pawle wrote: > Dear Team, > > Need a formula to look up a filed & give sum of figure , sample file > attached > > Regards, > > Prashant > > -- > Join official Faceboo

$$Excel-Macros$$ formula required

Dear Team, Need a formula to look up a filed & give sum of figure , sample file attached Regards, Prashant -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent,

Re: $$Excel-Macros$$ formula required for addition of amount for duplicate entry

can you show us how do you want to see output On Tue, Oct 9, 2012 at 1:16 PM, ashish damor wrote: > Dear All, > > I have an excel sheet wherein commission is generated for each > business placed by our intermediary. I need to have a formula for > monthly consolidated amount for Gross Amount (Col

$$Excel-Macros$$ formula required for addition of amount for duplicate entry

Dear All, I have an excel sheet wherein commission is generated for each business placed by our intermediary. I need to have a formula for monthly consolidated amount for Gross Amount (Column E) and TDS Deduction (Column I) of each intermediary without first sorting and subsequently adding each en

RE: $$Excel-Macros$$ Formula required for finding Consumption value for giving cons. Qty.

ime. BS From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Maries Sent: Sun, 06-May-2012 12:53 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Formula required for finding Consumption value for giving cons. Qty. Revised... O

Re: $$Excel-Macros$$ Formula required for finding Consumption value for giving cons. Qty.

t;> The closing value of stock will be calculated on the Balance Quantity (@ >> of last purchase rate) >> >> ** ** >> >> Thanks & Regards, >> >> BS >> >> ** ** >> >> ** ** >> >> ** ** >> >> ** ** >

Re: $$Excel-Macros$$ Formula required for finding Consumption value for giving cons. Qty.

From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Maries > *Sent:* Sun, 06-May-2012 11:46 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Formula required for finding Consumption > value for giving con

RE: $$Excel-Macros$$ Formula required for finding Consumption value for giving cons. Qty.

: Re: $$Excel-Macros$$ Formula required for finding Consumption value for giving cons. Qty. Can you explain more about FIFO calculation. On Fri, May 4, 2012 at 8:19 PM, B Sharma wrote: Dear Friends and excel experts,, I have a sheet in which there are columns like "Qty"

Re: $$Excel-Macros$$ Formula required for finding Consumption value for giving cons. Qty.

*Can you explain more about FIFO calculation.* On Fri, May 4, 2012 at 8:19 PM, B Sharma wrote: > Dear Friends and excel experts,, > > I have a sheet in which there are columns like "Qty""Rate" of purchase > of items, > In Another sheet I need a formula for auto calculation of consumption

$$Excel-Macros$$ Formula required for finding Consumption value for giving cons. Qty.

Dear Friends and excel experts,, I have a sheet in which there are columns like "Qty""Rate" of purchase of items, In Another sheet I need a formula for auto calculation of consumption value of goods for the given quantity in FIFO method (First In First Out) I have tried all my known tricks,

Re: $$Excel-Macros$$ formula required for count or count if

Hi Sara, PFA Regards Lalit Mohan https://www.facebook.com/buzinesstransformation On 4/27/2012 10:00 AM, Sara Lee wrote: hi i have data as in the attached data. i need count of unique values of column A i.e i need output as in column AB, AC... pls advise a formula thanks -- FORUM RULES

Re: $$Excel-Macros$$ formula required for count or count if

no but this takes duplicates into consideration.. I would need count of only unique values for every load no On Fri, Apr 27, 2012 at 7:39 AM, Shaik Waheed wrote: > Hi Sara, > > PFA, Hope this is what you are looking for... > > On Fri, Apr 27, 2012 at 4:33 PM, Sara Lee wrote: > >> Anil >

Re: $$Excel-Macros$$ formula required for count or count if

Anil it s not the count of loads.. i need the count of distinct values for every load no ie Load 0241 7151865O 7154687O 7175843O 7202990O 7212856O 7253406O has 6 values both from top row and bottom row.. so 6 should be the output for load 0241 in some case as u see, some loads have 3 ro

Re: $$Excel-Macros$$ formula required for count or count if

Dear Sara, Its Working Fine please find the attached file. Thanks & Regards Anil Kumar 113784 On Fri, Apr 27, 2012 at 2:52 PM, Darwin Chan wrote: > See if you understand array formula. > > http://www.excelfunctions.net/Excel-Array-Formulas.html > > > 2012/4/27 Sara Lee > >> thee are two si

Re: $$Excel-Macros$$ formula required for count or count if

See if you understand array formula. http://www.excelfunctions.net/Excel-Array-Formulas.html 2012/4/27 Sara Lee > thee are two similar rows with same load no---this is not working > > On Fri, Apr 27, 2012 at 4:06 AM, anil panchal wrote: > >> you can use >> >> =SUMPRODUCT(--($A$2:$A$23=AB2)) >>

Re: $$Excel-Macros$$ formula required for count or count if

thee are two similar rows with same load no---this is not working On Fri, Apr 27, 2012 at 4:06 AM, anil panchal wrote: > you can use > > =SUMPRODUCT(--($A$2:$A$23=AB2)) > > > > > On Fri, Apr 27, 2012 at 1:26 PM, Sara Lee wrote: > >> yes i need count of distinct records for each load no-- sample

Re: $$Excel-Macros$$ formula required for count or count if

should i paste in AB2? On Fri, Apr 27, 2012 at 4:52 AM, Darwin Chan wrote: > sara, > > the formula should workfirst highlight the range you want to implement > this formula, then you should try Ctrl + Shift + Enter. > > > 2012/4/27 Sara Lee > >> it is not working-- anybody else can help here

Re: $$Excel-Macros$$ formula required for count or count if

sara, the formula should workfirst highlight the range you want to implement this formula, then you should try Ctrl + Shift + Enter. 2012/4/27 Sara Lee > it is not working-- anybody else can help here > > > On Fri, Apr 27, 2012 at 4:06 AM, anil panchal wrote: > >> you can use >> >> =SUMPROD

Re: $$Excel-Macros$$ formula required for count or count if

it is not working-- anybody else can help here On Fri, Apr 27, 2012 at 4:06 AM, anil panchal wrote: > you can use > > =SUMPRODUCT(--($A$2:$A$23=AB2)) > > > > > On Fri, Apr 27, 2012 at 1:26 PM, Sara Lee wrote: > >> yes i need count of distinct records for each load no-- sample output >> >> load

Re: $$Excel-Macros$$ formula required for count or count if

you can use =SUMPRODUCT(--($A$2:$A$23=AB2)) On Fri, Apr 27, 2012 at 1:26 PM, Sara Lee wrote: > yes i need count of distinct records for each load no-- sample output > > load 02416 > load 02423 > load 02452 > load 02462 > > > On Fri, Apr 27, 2012 at 3:45 AM, Ab

Re: $$Excel-Macros$$ formula required for count or count if

yes i need count of distinct records for each load no-- sample output load 02416 load 02423 load 02452 load 02462 On Fri, Apr 27, 2012 at 3:45 AM, Abhishek Jain wrote: > Actually count of values stored in adjacent columns of each load number is > required. For Loa

Re: $$Excel-Macros$$ formula required for count or count if

Actually count of values stored in adjacent columns of each load number is required. For Load 0241 - there are 6 values so the formula should return 6. On Fri, Apr 27, 2012 at 1:09 PM, Darwin Chan wrote: > Hi Sara, > > Seems formula COUNTIF can solve your problem simply. > > 2012/4/27 Sara Lee

Re: $$Excel-Macros$$ formula required for count or count if

Hi Sara, Seems formula COUNTIF can solve your problem simply. 2012/4/27 Sara Lee > hi > > i have data as in the attached data. i need count of unique values of > column A i.e i need output as in column AB, AC... pls advise a formula > thanks > > -- > FORUM RULES (986+ members already BANNED

$$Excel-Macros$$ formula required for count or count if

hi i have data as in the attached data. i need count of unique values of column A i.e i need output as in column AB, AC... pls advise a formula thanks -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Ur

Re: $$Excel-Macros$$ Formula required

try > > =IF(COUNTIF($C$12:$C$15,F9),0,IF(AND(COUNTIF($B9:$B$9,B6)=1,COUNTIF($E$12:$E$15,F9)),1,0)) > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > *From:* Aamir Shahzad > *Sent:* Saturday, March 24, 2012 5:50 AM > *To:* excel-m

Re: $$Excel-Macros$$ Formula required

try =IF(COUNTIF($C$12:$C$15,F9),0,IF(AND(COUNTIF($B9:$B$9,B6)=1,COUNTIF($E$12:$E$15,F9)),1,0)) Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Aamir Shahzad Sent: Saturday, March 24, 2012 5:50 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros

Re: $$Excel-Macros$$ Formula required

ok I added the criteria in attached file, only need is if showing more than 1 then it should show as zero only one 1 should remain because this customer is one. Regards, Aamir Shahzad On Sat, Mar 24, 2012 at 12:58 PM, Abhishek Jain wrote: > How are we supposed to work out a formula if we don't

Re: $$Excel-Macros$$ Formula required

How are we supposed to work out a formula if we don't know the criteria ?? On Sat, Mar 24, 2012 at 1:20 PM, Maries wrote: > *Can You Please Explain More...* > > > >> Dear Group, >> >> I am generating the attached series by some criteria but required further >> formula. Please review attached sh

Re: $$Excel-Macros$$ Formula required

*Can You Please Explain More...* > Dear Group, > > I am generating the attached series by some criteria but required further > formula. Please review attached sheet. > > Regards, > > Aamir Shahzad > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thre

$$Excel-Macros$$ Formula required

Dear Group, I am generating the attached series by some criteria but required further formula. Please review attached sheet. Regards, Aamir Shahzad -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent,

Re: $$Excel-Macros$$ Formula required

Ravi Kumar, The solution provided was for the previous attachment you sent. Not this attachment. For your new requirement, you should be ideally starting a new post. Now, can you please show example of more than 2, columns. Multiple columns. That will help the volunteers here understand what you

Re: $$Excel-Macros$$ Formula required

Sent: Jan/Mon/2012 06:45 > To: excel-macros@googlegroups.com > Subject: Re: $$Excel-Macros$$ Formula required > > Dear NoorainAnsari, > > Thanks for interest in helping me ,My requirement is still pending, I had > made some changes , updated the required result manually from

RE: $$Excel-Macros$$ Formula required

on/2012 06:45 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Formula required Dear NoorainAnsari, Thanks for interest in helping me ,My requirement is still pending, I had made some changes , updated the required result manually from the "OWM Machinery" Sheet to "Sheet

Re: $$Excel-Macros$$ Formula required

Hi Vikram, Find the sheet enclosed Regards Umesh Dev On Mon, May 16, 2011 at 11:07 PM, vikram wrote: > Hi, > > > > Please help regarding formula for validation: > > > > If we enter any numeric value in particular column it does not allow a > duplicate entry and shows error message. > > > > F

Re: $$Excel-Macros$$ Formula required

Try this Formula in Custom Validation.. =COUNTIF($A$1:A1,A1)=1 On Mon, May 16, 2011 at 11:07 PM, vikram wrote: > Hi, > > > > Please help regarding formula for validation: > > > > If we enter any numeric value in particular column it does not allow a > duplicate entry and shows error message.

Re: $$Excel-Macros$$ Formula required

Hi Vikarm check this link http://www.exceltip.com/st/Preventing_Duplicates_When_Entering_Data/886.html Thanks Mahesh On Mon, May 16, 2011 at 11:07 PM, vikram wrote: > Hi, > > > > Please help regarding formula for validation: > > > > If we enter any numeric value in particular column it does n

Re: $$Excel-Macros$$ Formula required

try this link http://www.ozgrid.com/Excel/prevent-duplicates.htm http://www.mrexcel.com/articles/prevent-excel-duplicates.php On Mon, May 16, 2011 at 11:07 PM, vikram wrote: > Hi, > > > > Please help regarding formula for validation: > > > > If we enter any numeric value in particular column

Re: $$Excel-Macros$$ Formula required to find the highest & lowest values in each month

Hi Thank You Regards Rajesh Kainikkara On 12/27/10, Ms-Exl-Learner . wrote: > Hi, > > In addition to the above post I would like to remove the helper column and > we make the formula to do the work. > > Have a look in the attached file. > > --- > Ms.Exl.Learner > ---

Re: $$Excel-Macros$$ Formula required to find the highest & lowest values in each month

Hi, In addition to the above post I would like to remove the helper column and we make the formula to do the work. Have a look in the attached file. --- Ms.Exl.Learner --- On Sun, Dec 26, 2010 at 6:29 PM, ashish koul wrote: > > check the attachment > On

Re: $$Excel-Macros$$ Formula required to find the highest & lowest values in each month

Hi Ashish Thank u very much, for ur fast & perfect answer Regards Rajesh Kainikkara On 12/26/10, ashish koul wrote: > check the attachment > On Sun, Dec 26, 2010 at 3:15 PM, Rajesh K R > wrote: > >> Hi experts >> >> Wish you happy new year >> >> I have worksheet like this >> Column A - Date >>

Re: $$Excel-Macros$$ Formula required to find the highest & lowest values in each month

check the attachment On Sun, Dec 26, 2010 at 3:15 PM, Rajesh K R wrote: > Hi experts > > Wish you happy new year > > I have worksheet like this > Column A - Date > Column B - Amt > Column C - Name of Month > Column D - For highest value of each month > Column E - For lowest value of each month > P

$$Excel-Macros$$ Formula required to find the highest & lowest values in each month

Hi experts Wish you happy new year I have worksheet like this Column A - Date Column B - Amt Column C - Name of Month Column D - For highest value of each month Column E - For lowest value of each month Pls check the attached file & tell me what is the formula for finding the highest & lowest val

Re: $$Excel-Macros$$ Formula required

Hi Priya, Please find attachement with solution. Thanks, Noorain Ansari On Mon, Oct 18, 2010 at 1:38 AM, Priya Jose wrote: > Dear All, > > Thanks for your prompt reply, as i mentioned in my query what is that i am > looking for is a formula but not Pivot table which i now very well this can >

Re: $$Excel-Macros$$ Formula required

Dear All, Thanks for your prompt reply, as i mentioned in my query what is that i am looking for is a formula but not Pivot table which i now very well this can be acheived. If you guys look at the data it has something like pulling the data with respect to a value from left and right. thats the

Re: $$Excel-Macros$$ Formula required

Hi Priya, Please find attachment. Let me know if you need anything else. Thanks & Regrds, Kaushik Savla -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitte

Re: $$Excel-Macros$$ Formula required

* Priya Jose > *Sender: * excel-macros@googlegroups.com > *Date: *Sun, 17 Oct 2010 15:52:52 +0300 > *To: * > *ReplyTo: * excel-macros@googlegroups.com > *Subject: *$$Excel-Macros$$ Formula required > > Dear All, > > Please find attach the file I need solution, requesting

Re: $$Excel-Macros$$ Formula required

Subject: $$Excel-Macros$$ Formula required Dear All, Please find attach the file I need solution, requesting you guys to be kind enough to share your knowledge. If possible i think please provide using the Index match or offset Waiting in anticipation..!! Regards Priya

Re: $$Excel-Macros$$ Formula required

: $$Excel-Macros$$ Formula required Dear All, Please find attach the file I need solution, requesting you guys to be kind enough to share your knowledge. If possible i think please provide using the Index match or offset Waiting in anticipation..!! Regards Priya Asst. HR

$$Excel-Macros$$ Formula required

Dear All, Please find attach the file I need solution, requesting you guys to be kind enough to share your knowledge. If possible i think please provide using the Index match or offset Waiting in anticipation..!! Regards Priya Asst. HR -- -

Re: $$Excel-Macros$$ Formula required

Thanks for your reply but can you solve my query with formulas. Because I don't know any thing about Macros how to use it or where to insert macro code. Your reply will highly appriaciated. Regards, Aamir Shahzad On Sun, May 30, 2010 at 10:20 PM, Mahesh parab wrote: > Hi Aamir > i herewith att

  1   2   >