Re: $$Excel-Macros$$ Need formula for 2 criterias

On Sat, 2/3/18, Rabindra Thapa wrote: Subject: Re: $$Excel-Macros$$ Need formula for 2 criterias To: excel-macros@googlegroups.com Date: Saturday, February 3, 2018, 2:31 PM Regards, For quick responds click here for Message On

Re: $$Excel-Macros$$ Need formula for 2 criterias

*Regards,* *For quick responds click here for Message * On Sat, Feb 3, 2018 at 2:13 PM, Kenil Gala wrote: > Hi > Pls Find the file attached. > > I have written my Query in the excel sheet. > > Please help me find the solution for this query > > Thanks > Kenil > > -- > Are you =EXP(E:RT) or =N

Re: $$Excel-Macros$$ Need - Formula weekly bonus

Thanks Abhishek, Its working fine ! Regards, Iqbal On 24 May 2016 at 14:00, Abhishek Jain wrote: > In Q2, try this: > > =IF(AND(P2=600,(SUM(J2:O2)<900)),(SUM(J2:O2)-600)*1.5,IF(P2=600,450,0)) > > and drag down. Change values to test it. > > > On Tue, May 24, 2016 at 12:39 PM, Shaikh Iqb

Re: $$Excel-Macros$$ Need - Formula weekly bonus

In Q2, try this: =IF(AND(P2=600,(SUM(J2:O2)<900)),(SUM(J2:O2)-600)*1.5,IF(P2=600,450,0)) and drag down. Change values to test it. On Tue, May 24, 2016 at 12:39 PM, Shaikh Iqbal wrote: > I need weekly bouns calculation, if Till Date Amount Earned = 600 then > total daywise points from J to O c

Re: $$Excel-Macros$$ Need - Formula weekly bonus

I need weekly bouns calculation, if Till Date Amount Earned = 600 then total daywise points from J to O column 600><900 then 300 incremental point 300*1.5=450 Max i.g. if any one got 600, but his total daywise calculate 1000, then 900-600=300 ( 300*1.5=450 ) if any one got 600, but his total

Re: $$Excel-Macros$$ Need - Formula weekly bonus

Please explain a bit more what exactly do you need. On Tue, May 24, 2016 at 12:09 PM, Shaikh Iqbal wrote: > Hi, > > Anybody help me ! > > > > -- Forwarded message -- > From: Shaikh Iqbal > Date: 23 May 2016 at 19:55 > Subject: $$Excel-Macros$$ Need - Formula weekly bonus > To: e

Re: $$Excel-Macros$$ NEED FORMULA FOR TEXT TO NUMBER CONVERTING

thanks to both of your for prompt support. On 29 August 2015 at 01:03, Haroon Rasheed wrote: > *There are many methods and ways to convert text into numbers try below on > the whole column will help you in a sec.* > > > > Use the Paste Special Command > > To use the *Paste Special* command, foll

RE: $$Excel-Macros$$ NEED FORMULA FOR TEXT TO NUMBER CONVERTING

There are many methods and ways to convert text into numbers try below on the whole column will help you in a sec. Use the Paste Special Command To use the Paste Special command, follow these steps: 1. In any blank cell, type the value 1. 2. Make sure the cell you typed 1 in is form

Re: $$Excel-Macros$$ NEED FORMULA FOR TEXT TO NUMBER CONVERTING

​select that column -Text to Column ( in Data Tab) -Click Finish ​ Regards, Prafull Jadhav 9920553518 On 27 August 2015 at 18:49, SUDHIR VERMA wrote: > Dear Friends, > Please help me as per attached sheet. I have data of 25k row. there are > some code formatting as text. So you are request to

Re: $$Excel-Macros$$ Need Formula

Hi you can do using combination of Index & Match function. Thanks On Tue, Mar 25, 2014 at 5:42 PM, Deepak Rawat wrote: > Hi, > > is there any solution in someproduct formula to get intersect text value > in 2D range: > > Below is the data; > >Bran Model - 1 Model - 2 Model - 3 Model - 4 A

Re: $$Excel-Macros$$ Need Formula

i think you want =VLOOKUP(B7,$A$1:$E$4,MATCH(C7,$A$1:$E$1,0)) On Tue, Mar 25, 2014 at 5:42 PM, Deepak Rawat wrote: > Hi, > > is there any solution in someproduct formula to get intersect text value > in 2D range: > > Below is the data; > >Bran Model - 1 Model - 2 Model - 3 Model - 4 Audi

RE: $$Excel-Macros$$ NEED FORMULA HELP

Thanks J From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kartik Dale Sent: Tuesday, December 24, 2013 12:56 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ NEED FORMULA HELP Hi Dhaval, Please find attachment Regards

RE: $$Excel-Macros$$ Need - formula help

YES From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shaikh Iqbal Sent: Friday, December 13, 2013 4:38 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need - formula help Ravinder, is it correct =IF(B2="Platinum&qu

Re: $$Excel-Macros$$ Need - formula help

Ravinder, is it correct =IF(B2="Platinum",INT(C2/3)*1200,IF(B2="Gold",INT(C2/12000)*480,IF(B2="Silver",INT(C2/6000)*240))) On 13 December 2013 16:25, Ravinder wrote: > I think u r looking for this. > =IF(B2="Platinum",INT(C2/3),IF(B2="Gold",INT(C2/12000),IF(B2="Silver",INT(C2/6000

Re: $$Excel-Macros$$ Need - formula help

Ravinder, Ya its fine but slab multiply with card Platinum*1200 / Gold*480 & Silver*240 On 13 December 2013 16:25, Ravinder wrote: > I think u r looking for this. > =IF(B2="Platinum",INT(C2/3),IF(B2="Gold",INT(C2/12000),IF(B2="Silver",INT(C2/6000 > > > > *From:* excel-macros@googlegrou

RE: $$Excel-Macros$$ Need - formula help

I think u r looking for this. =IF(B2="Platinum",INT(C2/3),IF(B2="Gold",INT(C2/12000),IF(B2="Silver",IN T(C2/6000 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shaikh Iqbal Sent: Friday, December 13, 2013 4:07 PM To: excel-macros@googlegroups.com

RE: $$Excel-Macros$$ Need formula help

Thanks a lot Ravinder J From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ravinder Sent: Thursday, November 28, 2013 5:48 PM To: excel-macros@googlegroups.com Cc: Soum Subject: RE: $$Excel-Macros$$ Need formula help =DAY(B2) From: excel-macros

RE: $$Excel-Macros$$ Need formula help

=DAY(B2) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Dhaval Shah ( Ahd ) Sent: Thursday, November 28, 2013 5:44 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need formula help Want to choss Day only from date pls refer attachme

Re: $$Excel-Macros$$ Need Formula

try d3 = =LEFT(B3,3) e3 = =LEFT(RIGHT(B3,LEN(B3)-FIND(",",B3)-1),3) see if it helps On Tue, Sep 17, 2013 at 10:22 AM, Prabhu Pinky wrote: > Hi Experts, > > Please find the attached file, please revert with appropriate formula for > my requirement > > Thanks & Regards, > Prabhu R > > -- >

Re: $$Excel-Macros$$ Need Formula

Dear Prabhu, Pl see the attached sheet. Warm Regards, Gawli Anil Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Tue, Sep 17, 2013 at 10:22 AM, Prabhu Pinky wrote: > Hi Experts, > > Please find the attached file, please revert with appropriate form

Re: $$Excel-Macros$$ need formula please

Hi pfa From: raghunandan rallapalli To: excel-macros@googlegroups.com Sent: Tuesday, 11 December 2012 5:59 PM Subject: $$Excel-Macros$$ need formula please sir, I need a formula for total sum of each account no wise as given in excel sheet.  Thanks in ad

Re: $$Excel-Macros$$ Need Formula

Hi Prabhakar find the solution as per your requirement On Fri, Jul 5, 2013 at 12:32 PM, Prafull Jadhav wrote: > Dear Prabhakar, > > find the same ...It is alternate use... > Our expert can give you better solution on it. > > Regards, > Prafull Jadhav. > MIS-executive. > > > > On Fri, Jul 5, 2013

Re: $$Excel-Macros$$ Need Formula

Dear Prabhakar, find the same ...It is alternate use... Our expert can give you better solution on it. Regards, Prafull Jadhav. MIS-executive. On Fri, Jul 5, 2013 at 11:27 AM, Prabhakar S H wrote: > Hi Team, > > I need your help to get details with formula in attached file. > > Rgds, > Prabha

Re: $$Excel-Macros$$ Need formula for sum

Use this formula with Ctrl+Shift+enter =SUM(IF($D$2:$AB$2=AC$2,$D$3:$AB$3)) On Thu, Feb 28, 2013 at 10:25 AM, Anoop K Sharma wrote: > Use attached one. This'll take care of text values also. > > > On Thu, Feb 28, 2013 at 10:41 AM, Deepak Rawat wrote: > >> But if some in some place text exists t

Re: $$Excel-Macros$$ Need formula for sum

Use attached one. This'll take care of text values also. On Thu, Feb 28, 2013 at 10:41 AM, Deepak Rawat wrote: > But if some in some place text exists then what to do > > Regards, > Deepak > > > On Wed, Feb 27, 2013 at 8:47 PM, Maries wrote: > >> Hi, >> >> Try it, >> >> =SUMIF($D$2:$AB$2,AC2,D$

Re: $$Excel-Macros$$ Need formula for sum

Hi, Try it, =SUMIF($D$2:$AB$2,AC2,D$3:AB$3) On Wed, Feb 27, 2013 at 6:26 PM, Deepak Rawat wrote: > Sorry attached wrong one > now attached the correct one. > > Regards, > Deepak > > > On Wed, Feb 27, 2013 at 5:41 PM, David Grugeon wrote: > >> We need more information. What do you want the sum

Re: $$Excel-Macros$$ Need formula for sum

We need more information. What do you want the sum of? There does not seem to be anything in the worksheet provided that you could possibly want to add up. On Wednesday, 27 February 2013, Deepak Rawat wrote: > Hi, > > need formula for sum in attach > > Regards, > Deepak > > -- > Are you =EXP(E:

Re: $$Excel-Macros$$ Need formula to retrieve value

This might help - http://chandoo.org/wp/2009/11/10/excel-sumproduct-formula/ On Tue, Feb 19, 2013 at 1:16 PM, Rakesh Kumar Sharma wrote: > Dear Abhishek, > > Working fine > > Will yo please explain this how it works? > > > > > On Tue, Feb 19, 2013 at 12:55 PM, Abhishek Jain wrote: > >> Check at

Re: $$Excel-Macros$$ Need formula to retrieve value

Dear Abhishek, Working fine Will yo please explain this how it works? On Tue, Feb 19, 2013 at 12:55 PM, Abhishek Jain wrote: > Check attached. Let us know if there is any further query. > > HTH > Abhi > > > On Tue, Feb 19, 2013 at 12:31 PM, Rakesh Kumar Sharma < > rakeshks@gmail.com> wrot

Re: $$Excel-Macros$$ Need formula to retrieve value

Check attached. Let us know if there is any further query. HTH Abhi On Tue, Feb 19, 2013 at 12:31 PM, Rakesh Kumar Sharma < rakeshks@gmail.com> wrote: > Dear Experts, > > I need a formula/function which can give required value. Sample file > attached. > > Thanks in Advance > > -- > Regar

Re: $$Excel-Macros$$ Need formula Solution

Thanks Dear On Tue, Feb 12, 2013 at 10:04 PM, >>Excel Beginner<< < excelbegin...@gmail.com> wrote: > Hi Dhaval, > > Find the attachment. > > > > > > > -- > *Regards,* > * > * > *Excel Beginner* > On Tue, Feb 12, 2013 at 1:42 PM, Dhaval Shah wrote: > >> Dear Friends >> >> pls refer my

Re: $$Excel-Macros$$ Need formula Solution

Hi Dhaval, Find the attachment. -- *Regards,* * * *Excel Beginner* On Tue, Feb 12, 2013 at 1:42 PM, Dhaval Shah wrote: > Dear Friends > > pls refer my sheet i want a formula solution > > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(

Re: $$Excel-Macros$$ Need formula Solution

dear frnd. Use Pivot get the solution. On 2/12/13, Dhaval Shah wrote: > Dear Friends > > pls refer my sheet i want a formula solution > > -- > 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$$ Need formula

> > ** ** > > Regards > > ** ** > > Kailash > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *>>Excel Beginner<< > *Sent:* Friday, January 18, 2013 12:00 AM > *To:* excel-macros@google

RE: $$Excel-Macros$$ Need formula

Hi Please remove my id from the group .. Regards Kailash From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of >>Excel Beginner<< Sent: Friday, January 18, 2013 12:00 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-M

Re: $$Excel-Macros$$ Need Formula

Dear Deepak Pl see the attached sheet. Warm Regards, Gawli Anil On Mon, Jan 28, 2013 at 9:15 PM, ashish koul wrote: > HI > > try this =SUMPRODUCT((1/COUNTIF(C3:C20,C3:C20&""))) > > > visit > > http://www.exceltip.com/st/Counting_number_of_unique_entries_in_a_specified_range./785.html > or > >

Re: $$Excel-Macros$$ Need Formula

HI try this =SUMPRODUCT((1/COUNTIF(C3:C20,C3:C20&""))) visit http://www.exceltip.com/st/Counting_number_of_unique_entries_in_a_specified_range./785.html or http://office.microsoft.com/en-in/excel-help/count-occurrences-of-values-or-unique-values-in-a-data-range-HP003056118.aspx or http://www.yo

Re: $$Excel-Macros$$ Need Formula

=SUM(IF($C$3:$C$10=G3,IF($D$3:$D$10<>"",1,0))) Press *CTRL+SHIFT+ENTER* * * *Regards* *Ashish* On Mon, Jan 28, 2013 at 6:27 PM, Deepak Rawat wrote: > Dear All, > > Pls provide proper formula for attached problem. > > Regards, > Deepak > > -- > Join official Facebook page of this forum @ > https:

Re: $$Excel-Macros$$ Need formula

Hi Deepak, Below mentioned formula used of worksheet cell "B2" or find the attachment. =ROUNDUP(SUM(IF(Data! B2:B12=Summary!A2,1/COUNTIF(Data!E2:E12,Data!E2:E12),0)),0) -- *Regards,* * * *Excel Beginner* On Thu, Jan 17, 2013 at 11:16 AM, Deepak Rawat wrote: > HI, > > Could u s

Re: $$Excel-Macros$$ Need formula

Deepak Watch this video you will be able to solve your problem on your *OWN* http://www.youtube.com/watch?v=27qh1i_kgCY Regards Ashish Koul On Thu, Jan 17, 2013 at 5:18 PM, Deepak Rawat wrote: > Hi, > thax for reply > but still unsolved in panchayat it should come 2 rather than 5 > > Regards,

Re: $$Excel-Macros$$ Need formula

Hi, thax for reply but still unsolved in panchayat it should come 2 rather than 5 Regards, Deepak Rawat On Thu, Jan 17, 2013 at 12:27 PM, Amresh Maurya wrote: > On Thu, Jan 17, 2013 at 12:21 PM, Deepak Rawat > wrote: > > Dear Anoop, > > > > I need as i given table. > > > > regards, > > Deepak

Re: $$Excel-Macros$$ need formula Highlight

Dear Manjunath, Pl find attached herewith. Is it OK? Warm Regards, Gawli Anil On Thu, Jan 17, 2013 at 2:17 PM, Manjunath Narayanappa < manjunath.narayana...@aon.co.uk> wrote: > Dear Expert, > > > > Good afternoon have a nice day :) > > > > I have a data in the attached spreadsheet, automatic

Re: $$Excel-Macros$$ Need formula

On Thu, Jan 17, 2013 at 12:21 PM, Deepak Rawat wrote: > Dear Anoop, > > I need as i given table. > > regards, > Deepak rawat > > > On Thu, Jan 17, 2013 at 11:43 AM, Anoop K Sharma > wrote: >> >> Hi Deepak, >> >> PFA. You need to refresh the pivot on first sheet. >> >> Regards, >> Anoop >> Sr. Dev

Re: $$Excel-Macros$$ Need formula

Use the updated file. You can move pivot anywhere in the workbook. There is no change in your table formatting. On Thu, Jan 17, 2013 at 12:21 PM, Deepak Rawat wrote: > Dear Anoop, > > I need as i given table. > > regards, > Deepak rawat > > > On Thu, Jan 17, 2013 at 11:43 AM, Anoop K Sharma >

Re: $$Excel-Macros$$ Need formula

Dear Anoop, I need as i given table. regards, Deepak rawat On Thu, Jan 17, 2013 at 11:43 AM, Anoop K Sharma wrote: > Hi Deepak, > > PFA. You need to refresh the pivot on first sheet. > > Regards, > Anoop > Sr. Developer > > > On Thu, Jan 17, 2013 at 11:16 AM, Deepak Rawat wrote: > >> HI, >> >>

Re: $$Excel-Macros$$ Need formula

Hi Deepak, PFA. You need to refresh the pivot on first sheet. Regards, Anoop Sr. Developer On Thu, Jan 17, 2013 at 11:16 AM, Deepak Rawat wrote: > HI, > > Could u suggest any formula to get summary from the data attached in > summary sheet. > > -- > Join official Facebook page of this forum @

Re: $$Excel-Macros$$ Need Formula

plz revert me how to use filter in column. On Wednesday, January 16, 2013 9:46:56 AM UTC+5:30, अनिल नारायण गवली wrote: > > Pl Find attached herewith with two formulae 1) Sumifs and 2) sumproduct. > > > Warm Regards, > Gawli Anil > > On Tue, Jan 15, 2013 at 8:39 PM, ashish koul > > wrote: > >

Re: $$Excel-Macros$$ Need Formula

try this =SUMIFS(C:C,A:A,"Fax",B:B,"Brown") On Tue, Jan 15, 2013 at 12:40 PM, Prabhakar S H wrote: > Dear Team, > > I need to get formula for attached file. Pls help. > > Rgds, > Prabhakar > > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RU

Re: $$Excel-Macros$$ need formula

In A2 cell *=INDIRECT("'"&$D$1&"'!"&ADDRESS(ROW(),COLUMN()+1))* Drag it down and right... On 10-01-2013 1:14 PM, Rajesh Agarwal wrote: Dear Sir If I change the sheet name in column D1 all the rows of column A & B change accordingly need formula not macro -- *Rajesh Kumar Agarwal* *981106300

Re: $$Excel-Macros$$ need formula please

Hi Raghu, please find the attachment. -- *Regards,* * * *Excel Beginner* * * On Tue, Dec 11, 2012 at 5:59 PM, raghunandan rallapalli < raghunandan.rallapa...@gmail.com> wrote: > sir, > I need a formula for total sum of each account no wise as given in excel > sheet. > > Thanks

Re: $$Excel-Macros$$ need formula please

your file (it's working only on one condition, that you account_no column is SORTED!!!) I didn't want to advice you to do pivot table as per request function.   awel From: raghunandan rallapalli To: excel-macros@googlegroups.com Sent: Tuesday, December 11, 2012

Re: $$Excel-Macros$$ need formula please

Hi, find below & use this =SUMIF($A$2:$A$23,A2,$C$2:$C$23) thankx satendra On Tue, Dec 11, 2012 at 5:59 PM, raghunandan rallapalli < raghunandan.rallapa...@gmail.com> wrote: > sir, > I need a formula for total sum of each account no wise as given in excel > sheet. > > Thanks in advance please

Re: $$Excel-Macros$$ need formula help

Dear Excel lerner, use SUMPRODUCT formula to get desired result see the attached file -- *Kalyan Chattopadhyay* *Executive Sales Coordinator* *R. S. H. Pvt. Ltd.* -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thre

Re: $$Excel-Macros$$ need formula help

Dear excellerner, Use $ sign to make constant row or column . for eg if u select A1 A10 then write $A$1 $A$10. first $ is for column and second $ is for row. you can use only one $ for only one column like $A1 or you can use only one row like a$1 . Regards, Gawli On Mon, Dec 10, 2012 at 12:31 PM,

Re: $$Excel-Macros$$ need formula

Hi Rajesh, Try this one. For Max: =MAX(IF(ISERROR(A2:A40),0,A2:A40)) For Min: =MIN(IF(ISERROR(A2:A40),40,A2:A40)) With Ctrl+Shift+Enter. Regards, Kuldeep Singh On Fri, Oct 19, 2012 at 1:05 PM, NOORAIN ANSARI wrote: > Dear Rajesh, > > Please try it.. > =MAX(IF(ISERROR(A2:A40),0,A2:A40)) > > =M

Re: $$Excel-Macros$$ need formula

Dear Rajesh, Please try it.. =MAX(IF(ISERROR(A2:A40),0,A2:A40)) =MIN(IF(ISERROR(A2:A40),0,A2:A40)) On Fri, Oct 19, 2012 at 12:54 PM, Rajesh Agarwal wrote: > Dear Sir > I need formula in b2 and c2 max and minimum value of a2:a40 excluding > other than numbers. > rgds > > -- > *Rajesh Kumar Aga

Re: $$Excel-Macros$$ need formula

Following formulas for Max & Min with C+S+E =MAX(IF(ISNUMBER(A2:A40),A2:A40)) =MIN(IF(ISNUMBER(A2:A40),A2:A40)) Regards, Aamir Shahzad On Fri, Oct 19, 2012 at 12:24 PM, Rajesh Agarwal wrote: > Dear Sir > I need formula in b2 and c2 max and minimum value of a2:a40 excluding > other than numbe

RE: $$Excel-Macros$$ need formula

=AVERAGE(IF($A$2:A2>0,$A$2:A2)) =MIN(IF($A$2:A2>0,$A$2:A2)) With CSE Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of rajeyssh Sent: 25 September 2012 3:17 To: excel-macros@googlegroups.com Subjec

Re: $$Excel-Macros$$ need formula

You need averageif()   Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley

Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl

2012 12:47 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Need formula to take out total number of > boy and girl > > Dear all > Can you please help me to find out Boys & girls Rank (Regarding Marks) If > they failed then can not count their rank.

Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl

Your file did NOT show any pass/fail or grades so how can we help? Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: amar takale Sent: Thursday, July 19, 2012 12:47 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need formula to take out

Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl

product formulas in attached. > > Don Guillett > Microsoft Excel Developer > SalesAid Software > dguille...@gmail.com > > *From:* group birle > *Sent:* Wednesday, July 18, 2012 7:47 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Need formula

Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl

See sumproduct formulas in attached. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: group birle Sent: Wednesday, July 18, 2012 7:47 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl

Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl

check this On Thu, Jul 12, 2012 at 2:54 PM, सुनिता पौडेल wrote: > Dear all, > > Can you please help me to find out the total number of boy and girl ? I > used countif for their grade and it worked. However, for girl and boy > seggregation it isnot working. > > Thank you very much for the suppo

Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl

Hi Noorain, Its working perfectly. I have tried this formulae for other sheets too. Thanx alot...I need it for my report... Have a wonderful weekend. Sunita On Fri, Jul 13, 2012 at 3:02 PM, NOORAIN ANSARI wrote: > Hi Sunita, > > Please confirm.. > > Is it not working.. > > paste in Cell *E2*

Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl

Hi Sunita, Please confirm.. Is it not working.. paste in Cell *E2* *=SUMPRODUCT(--($E$10:$E$46=$E$1)*($D$10:$D$46=C2))* On Fri, Jul 13, 2012 at 1:22 PM, सुनिता पौडेल wrote: > Hi, > > Still not working :( > its 2010 > > On Fri, Jul 13, 2012 at 12:04 PM, NOORAIN ANSARI > wrote: > >> Incase of

Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl

Thank you so muck Krishnaraddi ji. Still wondering where it went wrong. Anyway thanks heaps. Sunita On Fri, Jul 13, 2012 at 1:53 PM, Krishnaraddi V. Madolli < krishnaraddi.mado...@asia.xchanging.com> wrote: > "CONFIDENTIALITY NOTICE: This message and any attachment are confidential > and may al

Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl

Hi, Still not working :( its 2010 On Fri, Jul 13, 2012 at 12:04 PM, NOORAIN ANSARI wrote: > Incase of 2003 > > You can also use.. > > *=SUMPRODUCT(--($E$10:$E$46=$E$1)*($D$10:$D$46=C2))* > > > On Fri, Jul 13, 2012 at 11:48 AM, NOORAIN ANSARI > wrote: > >> Hi Sunita, >> >> Please Try it.. >> =CO

Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl

Incase of 2003 You can also use.. *=SUMPRODUCT(--($E$10:$E$46=$E$1)*($D$10:$D$46=C2))* On Fri, Jul 13, 2012 at 11:48 AM, NOORAIN ANSARI wrote: > Hi Sunita, > > Please Try it.. > =COUNTIFS($E$10:$E$46,$E$1,$D$10:$D$46,C2) > > > > > On Fri, Jul 13, 2012 at 11:31 AM, सुनिता पौडेल wrote: > >> Dear

Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl

Hi Sunita, Please Try it.. =COUNTIFS($E$10:$E$46,$E$1,$D$10:$D$46,C2) On Fri, Jul 13, 2012 at 11:31 AM, सुनिता पौडेल wrote: > Dear all, > > however this is not working out , can you please solve this where i went > wrong/ > thnx > > On Thu, Jul 12, 2012 at 3:36 PM, सुनिता पौडेल wrote: > >> w

Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl

Dear all, however this is not working out , can you please solve this where i went wrong/ thnx On Thu, Jul 12, 2012 at 3:36 PM, सुनिता पौडेल wrote: > wohoo so may options thnx guys ..it really worked out > > thank you so much > > Sunita > > On Thu, Jul 12, 2012 at 3:25 PM, NOORAIN ANSARI >

RE: $$Excel-Macros$$ Need formula

On Behalf Of NOORAIN ANSARI Sent: 12 July 2012 5:15 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need formula Dear Prashant, You can try.. =OFFSET($A$1,COUNTIF($A$2:$A$4,"<>"&""),0) On Thu, Jul 12, 2012 at 5:04 PM, Prashant Pawle wrote:

Re: $$Excel-Macros$$ Need formula

Dear Prashant, You can try.. *=OFFSET($A$1,COUNTIF($A$2:$A$4,"<>"&""),0)* On Thu, Jul 12, 2012 at 5:04 PM, Prashant Pawle wrote: > Dear noor, > > Please let me know the formula if first cell is empty Then it shd take > next cell in array > > Regards, > > Prashant > > > On Thu, Jul 12, 2012 at 3

Re: $$Excel-Macros$$ Need formula

Dear noor, Please let me know the formula if first cell is empty Then it shd take next cell in array Regards, Prashant On Thu, Jul 12, 2012 at 3:23 PM, NOORAIN ANSARI wrote: > Dear Prashant, > > Please use > > =INDEX($A$2:$A$4,1) > > or > > =OFFSET($A$1,1,0) > > see attached sheet. > > > On Th

Re: $$Excel-Macros$$ Need formula

Dear Prashant, Please use =INDEX($A$2:$A$4,1) or =OFFSET($A$1,1,0) see attached sheet. On Thu, Jul 12, 2012 at 4:50 PM, Prashant Pawle wrote: > Dear All, > > Need a formula for getting first text in the Range, in particular cell , > sample file attached > > Regards, > > Prashant > > > -- >

Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl

wohoo so may options thnx guys ..it really worked out thank you so much Sunita On Thu, Jul 12, 2012 at 3:25 PM, NOORAIN ANSARI wrote: > You Can also use.. > > *=DCOUNTA($E$9:$E$49,E9,G1:G2)* > See attached sheet. > > > On Thu, Jul 12, 2012 at 3:04 PM, NOORAIN ANSARI > wrote: > >> Hi Sunita

Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl

You Can also use.. *=DCOUNTA($E$9:$E$49,E9,G1:G2)* See attached sheet. On Thu, Jul 12, 2012 at 3:04 PM, NOORAIN ANSARI wrote: > Hi Sunita, > > You can also *try.. > > =SUMPRODUCT(--($E$10:E49="GIRL"))* > > On Thu, Jul 12, 2012 at 2:54 PM, सुनिता पौडेल wrote: > >> Dear all, >> >> Can you please

Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl

Hi Sunita, You can also *try.. =SUMPRODUCT(--($E$10:E49="GIRL"))* On Thu, Jul 12, 2012 at 2:54 PM, सुनिता पौडेल wrote: > Dear all, > > Can you please help me to find out the total number of boy and girl ? I > used countif for their grade and it worked. However, for girl and boy > seggregation

RE: $$Excel-Macros$$ Need formula to take out total number of boy and girl

ease consider the environment before printing this message From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ?? ? Sent: Thursday, July 12, 2012 2:59 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need formula to take out total number of

Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl

Dear Sunita, Find the attached sheet. Regards, Kuldeep Singh naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* On Thu, Jul 12, 2012 at 2:59 PM, सुनिता पौडेल wrote: > wow thnx... > is there any way to find ou

Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl

wow thnx... is there any way to find out like in certain grade how many girl or boy studies?? Thank you On Thu, Jul 12, 2012 at 3:11 PM, Rohan Young wrote: > just correct your answer > > =COUNTIF($E$10:E49,"GIRL") > > On Thu, Jul 12, 2012 at 2:54 PM, सुनिता पौडेल wrote: > > Dear all, > > > > Ca

Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl

just correct your answer =COUNTIF($E$10:E49,"GIRL") On Thu, Jul 12, 2012 at 2:54 PM, सुनिता पौडेल wrote: > Dear all, > > Can you please help me to find out the total number of boy and girl ? I used > countif for their grade and it worked. However, for girl and boy > seggregation it isnot working

Re: $$Excel-Macros$$ Need Formula !!

Dear ALL, Thanks to all, all are working fine. Once again thanks, Iqbal Shaikh On 27 June 2012 19:04, Swapnil Palande wrote: > Hi, > > use following formula > > =IF(E2="Not-Qualify", C2-D2, "-") > > Regards, > > Swapnil > > On Wed, Jun 27, 2012 at 6:46 PM, Shaikh Iqbal wrote: > >> Dear Expo

Re: $$Excel-Macros$$ Need Formula !!

PFA Deepak Rawat On Wed, Jun 27, 2012 at 6:46 PM, Shaikh Iqbal wrote: > Dear Exports, > > Please find attached a file and help for formula as per required. > > > > > > Regards, > > Iqbal Shaikh > > -- > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate t

RE: $$Excel-Macros$$ Need Formula !!

See the attached File : Formula Used =MAX(0,C2-D2) Use this Format _(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_) Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shaikh Iqbal Sent: 27 Ju

Re: $$Excel-Macros$$ Need Formula !!

Hi Iqbal, Try this *=IF(E2="Qualify","-",C2-D2)* -- *Best Regards,* *Venkat * *Chennai* On Wed, Jun 27, 2012 at 6:46 PM, Shaikh Iqbal wrote: > Dear Exports, > > Please find attached a file and help for formula as per required. > > > > > > Regards, > > Iqbal Shaikh > > -- > -- > FORUM RULES

Re: $$Excel-Macros$$ Need Formula for Lookup Based on a Matrix of Data

Noorain, it is no wonder you are honored as most helpful so often. Congratulations and thank you for your help. John On Thu, Jan 26, 2012 at 11:22 AM, NOORAIN ANSARI wrote: > Dear John, > > You can also use in F3... > > > =INDEX(Data!$C$2:$C$37,MATCH(1,(Data!$A$2:$A$37=E3)*(Data!$B$2

Re: $$Excel-Macros$$ Need Formula for Lookup Based on a Matrix of Data

ail.com > > *From:* Sourabh Salgotra > *Sent:* Thursday, January 26, 2012 11:04 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Need Formula for Lookup Based on a Matrix > of Data > > plz sir explain this formula i have confusion in this. how

Re: $$Excel-Macros$$ Need Formula for Lookup Based on a Matrix of Data

Thank you very much Rajan. John On Mon, Jan 30, 2012 at 12:44 PM, Rajan_Verma wrote: > Use this > > > =OFFSET(INDEX(Data!A:A,MATCH(Dashboard!E3,Data!A:A,0),1),2,MATCH(Dashboard!F2,Data!$A$1:$L$1,0)-1) > > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googleg

RE: $$Excel-Macros$$ Need Formula for Lookup Based on a Matrix of Data

Use this =OFFSET(INDEX(Data!A:A,MATCH(Dashboard!E3,Data!A:A,0),1),2,MATCH(Dashboard!F 2,Data!$A$1:$L$1,0)-1) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of John A. Smith Sent: Jan/Thu/2012 08:49 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$

Re: $$Excel-Macros$$ Need Formula for Lookup Based on a Matrix of Data

:$1,0)) Don Guillett SalesAid Software dguille...@gmail.com From: NOORAIN ANSARI Sent: Thursday, January 26, 2012 10:22 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need Formula for Lookup Based on a Matrix of Data Dear John, You can also use

Re: $$Excel-Macros$$ Need Formula for Lookup Based on a Matrix of Data

,MATCH($E3,Data!$A:$A),MATCH(F$2,Data!$1:$1,0)) Don Guillett SalesAid Software dguille...@gmail.com From: NOORAIN ANSARI Sent: Thursday, January 26, 2012 10:22 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need Formula for Lookup Based on a Matrix of Data De

Re: $$Excel-Macros$$ Need Formula for Lookup Based on a Matrix of Data

2,Data!$1:$1,0)) > > Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* NOORAIN ANSARI > *Sent:* Thursday, January 26, 2012 10:22 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Need Formula for Lookup Based on a Matrix &g

Re: $$Excel-Macros$$ Need Formula for Lookup Based on a Matrix of Data

> SalesAid Software > dguille...@gmail.com > > *From:* NOORAIN ANSARI > *Sent:* Thursday, January 26, 2012 10:22 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Need Formula for Lookup Based on a Matrix > of Data > > Dear John, > > You can

Re: $$Excel-Macros$$ Need Formula for Lookup Based on a Matrix of Data

Simpler with no CSE '=INDEX(Data!$A$1:$L$37,MATCH($E3,Data!$A:$A),MATCH(F$2,Data!$1:$1,0)) Don Guillett SalesAid Software dguille...@gmail.com From: NOORAIN ANSARI Sent: Thursday, January 26, 2012 10:22 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need Formula for L

Re: $$Excel-Macros$$ Need Formula for Lookup Based on a Matrix of Data

Put this in E3>copy across>down =INDEX(Data!$A$1:$L$37,MATCH($E3,Data!$A:$A),MATCH(F$2,Data!$1:$1,0)) Don Guillett SalesAid Software dguille...@gmail.com From: John A. Smith Sent: Thursday, January 26, 2012 9:18 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need

Re: $$Excel-Macros$$ Need Formula for Lookup Based on a Matrix of Data

Dear John, You can also use in F3... =INDEX(Data!$C$2:$C$37,MATCH(1,(Data!$A$2:$A$37=E3)*(Data!$B$2:$B$37="Total"),0)) with ctrl+Shift+enter See attached sheet. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://

Re: $$Excel-Macros$$ Need Formula for Lookup Based on a Matrix of Data

Use in F3 and drag down and across =SUMPRODUCT((Data!$A$2:$A$37=$E3)*(Data!$B$2:$B$37="Total")*OFFSET(Data!$A$2:$A$37,0,MATCH(Dashboard!F$2,Data!$B$1:$L$1,0))) Regards, Sam Mathai Chacko On Thu, Jan 26, 2012 at 8:48 PM, John A. Smith wrote: > Thank you for your valuable help. > > I need a formu

Re: $$Excel-Macros$$ Need Formula- Very Very Urgent

Great Solution SAM On Mon, Sep 5, 2011 at 10:48 PM, GoldenLance wrote: > =SUMPRODUCT(LEN(A1)- > LEN(SUBSTITUTE(UPPER(A1),CHAR(ROW(INDIRECT("65:90"))),""))) > > from > http://www.excelfox.com/forum/showthread.php?135-Count-Alpha-In-AlphaNumeric-Text > > GL > > On Sep 5, 9:09 pm, Intelligent But C

Re: $$Excel-Macros$$ Need Formula- Very Very Urgent

=SUMPRODUCT(LEN(A1)- LEN(SUBSTITUTE(UPPER(A1),CHAR(ROW(INDIRECT("65:90"))),""))) from http://www.excelfox.com/forum/showthread.php?135-Count-Alpha-In-AlphaNumeric-Text GL On Sep 5, 9:09 pm, Intelligent But Crazy wrote: > Thanks Noorain, > > for your Quick Help. but actually my requirement is F

  1   2   >