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

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

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

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

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

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

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

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

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 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

=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 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

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 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

> > ** ** > > 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

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

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 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

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

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

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 !!

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 !!

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 !!

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 !!

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

Hi, Can u check this this can be helpor not On Wed, Jul 28, 2010 at 11:21 PM, Ahmed Honest wrote: > Dear All, > > Please find attach the sheet wherein I need the Data from "Tracking Sheet" > should go the each individual sheets the data. > > Please see attach file for more understanding. > >

Re: $$Excel-Macros$$ Need Formula

Hello, Let me know, How many number of REPs are there? Why do you want to put them in different sheets? Regards, Kishan Reddy, K On Jul 29, 2:11 pm, Venkatesh Narla wrote: > Hi, > Can u check this this can be helpor not > > On Wed, Jul 28, 2010 at 11:21 PM, Ahmed Honest wrote: > > Dear Al

Re: $$Excel-Macros$$ Need Formula

you used to pivot table.. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/grou

Re: $$Excel-Macros$$ Need Formula

Hi Rahim, Look attached file . *Best Regards,* *Venkat* On Thu, Jul 14, 2011 at 10:35 PM, Rahim Sharieff wrote: > Hi Experts, > > Please refer the attached workbook. > > The first sheet here "Schedule" gives the training requirements and > Training batches, and the second sheet "Trainin

Re: $$Excel-Macros$$ Need Formula

Hi Venkat, Thanks for the update... But this is not what I was looking for... I need a formula in the table above that.. The ones already show the result that I desire to achive. Thanks On Fri, Jul 15, 2011 at 10:57 AM, Venkatesan c wrote: > Hi Rahim, > > Look attached file . > > > *Best

Re: $$Excel-Macros$$ Need Formula

Hi Mahesh, Thanks so much for the formula... I really appreciate your work..!!! Have a Great Weekend..!! Warm Regards, Rahim Sharieff. On Fri, Jul 15, 2011 at 9:55 PM, Mahesh parab wrote: > Hi Rahim > > find attach > > > Thanks > Mahesh > > On Thu, Jul 14, 2011 at 10:35 PM, Rahim Sharieff >

Re: $$Excel-Macros$$ Need Formula

hi jocky pfa. it may help. -- *Great day,* *viper * On Mon, Aug 1, 2011 at 1:15 PM, jocky Beta wrote: > > Hi Team, > > I have one sheet in which Two Columns are there in which first Column > there is Employee id and employee name. In Second column i need the exact > employee id as

RE: $$Excel-Macros$$ Need Formula

Hi, Here is the solution. Thanks & Regards, Nitesh Kandade Jr. Analyst OneWest Bank, FSB Office: (213) 337-3653 Ext.: 68361 nitesh.kand...@owb.com This message contains information which may be confidential and privileged. Unless you are the addressee (or aut

Re: $$Excel-Macros$$ Need Formula

Hi Jocky, Find attached resolved your query.. *Best Regards,* *Venkat* *Chennai* On Mon, Aug 1, 2011 at 1:15 PM, jocky Beta wrote: > > Hi Team, > > I have one sheet in which Two Columns are there in which first Column > there is Employee id and employee name. In Second column i need the e

RE: $$Excel-Macros$$ Need Formula

See the attached FIle =SUM(($B$4:$B$20=E4)*$A$4:$A$20) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kandade, Nitesh Sent: Monday, August 01, 2011 1:37 PM To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ Need Formula

Re: $$Excel-Macros$$ Need Formula

Dear Jocky, Please use below formula...it wll be useful in case of duplicacy.. See attached Sheet... =IF(COUNTIF($E$4:E4,E4)>1,VLOOKUP(E4,CHOOSE({1,2},$B$4:$B$20,$A$4:$A$20),2,1),VLOOKUP(E4,CHOOSE({1,2},$B$4:$B$20,$A$4:$A$20),2,0)) -- Thanks & regards, Noorain Ansari *http://noorain-ansari.blo

Re: $$Excel-Macros$$ Need Formula

try this cell d4 =INDEX($A$3:$A$20,MATCH(E4,$B$3:$B$20,0)) On Mon, Aug 1, 2011 at 1:15 PM, jocky Beta wrote: > > Hi Team, > > I have one sheet in which Two Columns are there in which first Column > there is Employee id and employee name. In Second column i need the exact > employee id as

Re: $$Excel-Macros$$ Need Formula

lf Of *Kandade, Nitesh > *Sent:* Monday, August 01, 2011 1:37 PM > > *To:* 'excel-macros@googlegroups.com' > *Subject:* RE: $$Excel-Macros$$ Need Formula > > ** ** > > Hi, > > Here is the solution. > > ** ** > > * * > > * * &g

Re: $$Excel-Macros$$ Need Formula

Hi this is very good one..can u pls let me know how this formula works if don't know how any duplicate values are there in the series... Thanks Jagadeesh On Mon, Aug 1, 2011 at 5:13 PM, NOORAIN ANSARI wrote: > Dear Jocky, > > Please use below formula...it wll be useful in case of duplicacy.. >

RE: $$Excel-Macros$$ Need Formula

Its only if you have unique Name and Integer ID in the data Base.. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of XLS S Sent: Monday, August 01, 2011 9:22 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need Formula if i put a5

Re: $$Excel-Macros$$ Need formula

Dear naanu Go through the attachment. it may help. or please make it clear with sample file -- *Great day,* *viper * On Thu, Aug 25, 2011 at 8:51 PM, naanu wrote: > I want to know the formula to find out the solution. > > ** ** > > For Ex: I have two columns > > ** ** > > Aru*

Re: $$Excel-Macros$$ Need formula

Thank u so much , but i want in below format Aru fddfs Text found ihcx zesr Text found dst fddfs Text found cfdf zesr Text found eder dfds Text found dfds dfds Text found yes err Text not found fddfs dfsf Text not found dfds dsdas Text not found zesr xzcxc Text not found vdfd wewq T

Re: $$Excel-Macros$$ Need formula

why not? simply use =IF(COUNTIF($A$3:$A$15,C3)=0,"Text not found","Text found") pfa -- *Great day,* *viper* On Fri, Aug 26, 2011 at 4:57 PM, naanu v wrote: > Thank u so much , but i want in below format > > Aru fddfs Text found ihcx zesr Text found dst fddfs Text found > cfdf ze

Re: $$Excel-Macros$$ Need formula

Thank u i would like to know is there any other formula in lookup or statistical or information On Fri, Aug 26, 2011 at 5:09 PM, NOORAIN ANSARI wrote: > Dear nannu, > > See attached sheet, if it help > > > -- > Thanks & regards, > Noorain Ansari > *http://noorain-ansari.blogspot.com/*

Re: $$Excel-Macros$$ Need formula

thank u but plz refer to my previous mail i also wanted tht array to be sorted with d help of formula On Fri, Aug 26, 2011 at 5:16 PM, NOORAIN ANSARI wrote: > Dear naanu, > > try it through Lookup > =IF(ISERROR(VLOOKUP(C3,$A$3:$A$15,1,0)),"Text Not Found","Text Found") > > On Fri, Aug 26, 20

RE: $$Excel-Macros$$ Need formula

Try this : =IF(ISERROR(MATCH(C3,$A$3:$A$15,0)),"Text Not found","Text Found") From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of naanu v Sent: Friday, August 26, 2011 4:57 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-M

RE: $$Excel-Macros$$ Need formula

If Next Next SortedList = arr End Function From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of naanu v Sent: Friday, August 26, 2011 5:21 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need form

RE: $$Excel-Macros$$ Need formula

Also use OPTION COMPARE TEXT if you are sorting list of Alphabets From: Rajan_Verma [mailto:rajanverma1...@gmail.com] Sent: Friday, August 26, 2011 5:56 PM To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ Need formula Try this to sort list in Array Function :

Re: $$Excel-Macros$$ Need formula

thanks for vb code but i m nt much familiar with vb code if u give in formula it would be better so i can study the formula and can put in my work -- -- Some important links for excel users: 1. Follow us on TWITTER

Re: $$Excel-Macros$$ Need formula

Just paste it in a Module and use this function in worksheet by Function Name : its a instant solution for your query : On Fri, Aug 26, 2011 at 6:38 PM, naanu v wrote: > thanks for vb code > > but i m nt much familiar with vb code > > if u give in formula it would be better > > so i can study 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

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, 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

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

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

=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

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

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

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 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 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 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

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 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 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 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

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

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

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

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

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 Correction !!!!!!!!!!!!!

Attached for ur reference Regards, Manoj Kumar On Mon, Jan 17, 2011 at 12:16 PM, jocky Beta wrote: > > Hi, > > I made a Excel sheet with help of V lookup using the Data validation, but > my formula shows unknown error. hence pls explain me the step by > step procedure for the same. > > >

Re: $$Excel-Macros$$ need Formula Correction !!!!!!!!!!!!!

Dear Jocky, please find attached sheet.. Formula is here... =IFERROR(VLOOKUP($F$2,DATA!$B$2:$G$8,3,0),"") Thanks & regards, Noorain Ansari On Sun, Jan 16, 2011 at 11:33 PM, Manoj kumar < manoj.vishwakarma...@gmail.com> wrote: > Attached for ur reference > > > > Regards, > Manoj Kumar

Re: $$Excel-Macros$$ need Formula Correction !!!!!!!!!!!!!

For contact person ur formula should be =VLOOKUP($F$2,DATA!$B:$G,3,0) And so on. i.e instead of A it shoul start from B.as unique value is in col. B. Hope it will haelp u. On 17 January 2011 12:16, jocky Beta wrote: > > Hi, > > I made a Excel sheet with help of V lookup using the Data validat

Re: $$Excel-Macros$$ need Formula Correction !!!!!!!!!!!!!

Check this...! I worked out somethingBelieve in order... Regards, Solomon On Mon, Jan 17, 2011 at 10:46 AM, jocky Beta wrote: > > Hi, > > I made a Excel sheet with help of V lookup using the Data validation, but > my formula shows unknown error. hence pls explain me the step by > step p

Re: $$Excel-Macros$$ need Formula Correction !!!!!!!!!!!!!

Hi Jocky, The reason you are getting #NA error because your criteria for "* table_array"* * * (*This is the table of data that VLOOKUP searches to find the information you are after.*) is wrong. Your range should start from column B and not A because "the value you want to find in the B column of

Re: $$Excel-Macros$$ need Formula Correction !!!!!!!!!!!!!

Hi Team, I got the Point _ But one more Question is in my Data Sheet their is Two Phone numbers are saved in F6 when it results in Main Data sheet its shows the Question mark between the ph no, I want to ask is their any way to arreng the same like F6. i.e one under one? Regards *J

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 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 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 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 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 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 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

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

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 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 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

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

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 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 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 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 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

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- Very Very Urgent

Dear Pankaj, Please try itand see attached sheet.. *Function Count_text(s As Range) For i = 1 To Len(s) If VBA.Asc(Mid(s, i, 1)) > 65 And VBA.Asc(Mid(s, i, 1)) < 90 Or VBA.Asc(Mid(s, i, 1)) > 96 And VBA.Asc(Mid(s, i, 1)) < 123 Then Count_text = Count_text & VBA.Mid(s, i, 1) End If Nex

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

Thanks Noorain, for your Quick Help. but actually my requirement is Formula, is there any inbuilt formula or combination of inbulilt formulas?? On Mon, Sep 5, 2011 at 9:09 PM, Intelligent But Crazy wrote: > > Dear Group, > > Is there any formula which can give the count of alphabets in a cell

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

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 for Current Date Access

Dear Ankur, Its working fine. Thank you very much. Regards, Idhrees. On Tue, Jul 5, 2011 at 3:46 PM, ankur wrote: > *You can create a form, by using the IIF function in Control Source > property...Of the field which required > > =IIf([Valid date]=Date(),"valid","expired") > > one sample fil

  1   2   >