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

On Sat, 2/3/18, Rabindra Thapa <rabinthapa2...@gmail.com> 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

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

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

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

$$Excel-Macros$$ Need Formula

Dear Excel Gurus, Please find the atttached file and give your valuable suggestions and fedback. With Regards *HARISH P Y* *P* *THINK BEFORE YOU PRINT:**Before printing this e-mail think whether it is really necessary. Thanks for your support to protect our environment for the future

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

May 2016 at 12:27, Abhishek Jain <abhishek@gmail.com> wrote: >> >>> Please explain a bit more what exactly do you need. >>> >>> On Tue, May 24, 2016 at 12:09 PM, Shaikh Iqbal <iqbal.hp...@gmail.com> >>> wrote: >>> >>>> Hi

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

>> wrote: >> >>> Hi, >>> >>> Anybody help me ! >>> >>> >>> >>> ------ Forwarded message -- >>> From: Shaikh Iqbal <iqbal.hp...@gmail.com> >>> Date: 23 May 2016 at 19:55 >>> Subject: $$

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

il.com> > wrote: > >> Hi, >> >> Anybody help me ! >> >> >> >> -- Forwarded message -- >> From: Shaikh Iqbal <iqbal.hp...@gmail.com> >> Date: 23 May 2016 at 19:55 >> Subject: $$Excel-Macros$$ Need - Formula weekl

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

t; Date: 23 May 2016 at 19:55 > Subject: $$Excel-Macros$$ Need - Formula weekly bonus > To: excel-macros@googlegroups.com > > > Dear Export, > > Please find attached daily tracking file. I need the a formula in Column Q > as per criteria. > > > > > > > >

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

Hi, Anybody help me ! -- Forwarded message -- From: Shaikh Iqbal <iqbal.hp...@gmail.com> Date: 23 May 2016 at 19:55 Subject: $$Excel-Macros$$ Need - Formula weekly bonus To: excel-macros@googlegroups.com Dear Export, Please find attached daily tracking file.

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

, 2015 5:19 PM *To:* excel-macros *Subject:* $$Excel-Macros$$ NEED FORMULA FOR TEXT TO NUMBER CONVERTING 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 please share formula for this. Here, example

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

Haroon From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of SUDHIR VERMA Sent: Thursday, August 27, 2015 5:19 PM To: excel-macros Subject: $$Excel-Macros$$ NEED FORMULA FOR TEXT TO NUMBER CONVERTING Dear Friends, Please help me as per attached sheet. I

$$Excel-Macros$$ Need Formula

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 A4 A6 A8 A10 BMW Series 3 Series 5 Series 7 X6 Mercedes A Class C Class E Class S Class Brand Model Answer BMW Model - 2

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 deepakexce...@gmail.comwrote: 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

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 deepakexce...@gmail.comwrote: 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 -

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

$$Excel-Macros$$ Need - formula help

Dear Exports, Need your help for if condition. Pls find attached file. Rgds, 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

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

Subject: $$Excel-Macros$$ Need - formula help Dear Exports, Need your help for if condition. Pls find attached file. Rgds, 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

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

-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 *Subject:* $$Excel-Macros$$ Need - formula help Dear Exports, Need your help for if condition. Pls find attached file

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

,INT(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 *Subject:* $$Excel-Macros$$ Need - formula help Dear Exports, Need your help

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,INT(C2/3

$$Excel-Macros$$ Need formula help

Want to choss Day only from date pls refer attachment Thanks Dhaval Shah -- 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

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

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

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 prabhupin...@gmail.comwrote: Hi Experts, Please find the attached file, please revert with appropriate formula for my requirement Thanks Regards,

$$Excel-Macros$$ Need Formula

Hi Experts, Please find the attached file, please revert with appropriate formula for my requirement Thanks Regards, Prabhu R -- 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 @

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 prabhupin...@gmail.com wrote: Hi Experts, Please find the attached file, please revert

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

Hi pfa From: raghunandan rallapalli raghunandan.rallapa...@gmail.com 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

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 prabakar.k...@gmail.comwrote: Hi Team, I need your help to get details with formula in attached

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 prafulltjad...@gmail.comwrote: Dear Prabhakar, find the same ...It is alternate use... Our expert can give you better solution on it. Regards, Prafull Jadhav. MIS-executive. On

$$Excel-Macros$$ Need Formula

Hi Team, I need your help to get details with formula in attached file. Rgds, Prabhakar -- 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

$$Excel-Macros$$ Need formula for sum

Hi, need formula for sum in attach Regards, Deepak -- 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

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:RT) or

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 deepakexce...@gmail.comwrote: Sorry attached wrong one now attached the correct one. Regards, Deepak On Wed, Feb 27, 2013 at 5:41 PM, David Grugeon da...@grugeon.com.auwrote: We need more

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 deepakexce...@gmail.comwrote: But if some in some place text exists then what to do Regards, Deepak On Wed, Feb 27, 2013 at 8:47 PM, Maries talk2mar...@gmail.com wrote: Hi, Try it,

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 aks.sharm...@gmail.comwrote: Use attached one. This'll take care of text values also. On Thu, Feb 28, 2013 at 10:41 AM, Deepak Rawat deepakexce...@gmail.comwrote:

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 rakeshks@gmail.com wrote: Dear Abhishek, Working fine Will yo please explain this how it works? On Tue, Feb 19, 2013 at 12:55 PM, Abhishek Jain

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

Dear Experts, I need a formula/function which can give required value. Sample file attached. Thanks in Advance -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- 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

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

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 abhishek@gmail.comwrote: 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

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 todhavals...@gmail.comwrote: Dear Friends pls refer my sheet

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

dear frnd. Use Pivot get the solution. On 2/12/13, Dhaval Shah todhavals...@gmail.com 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

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 todhavals...@gmail.com 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

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-Macros$$ Need formula

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@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Need formula

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 deepakexce...@gmail.comwrote: Dear All, Pls provide proper formula for attached problem. Regards, Deepak -- Join official Facebook page of this forum

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

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 koul.ash...@gmail.com wrote: HI try this =SUMPRODUCT((1/COUNTIF(C3:C20,C3:C20))) visit

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

: $$Excel-Macros$$ need formula Highlight Hi Manjunath, PFA, Regards Prince On Thursday, January 17, 2013 6:41:46 PM UTC+5:30, Manjunath Narayanappa wrote: Dear all, Please can I get macro for below requests Regards Manjunath From: excel-...@googlegroups.com [mailto:excel-...@googlegroups.com

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

: *Subject:* Re: FW: $$Excel-Macros$$ need formula Highlight 1st Conditional Formatting: [image: Inline image 1] 2nd Conditional Formatting Rules Manager: [image: Inline image 2] Regards, Kuldeep Singh Info Edge India Limited (naukri.com

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

to learn more abt Conditional formatting Regarda Manjunath *From:* excel-...@googlegroups.com [mailto:excel-...@**googlegroups.com] *On Behalf Of *Kuldeep Singh *Sent:* 22 January 2013 10:05 *To:* excel-...@googlegroups.com *Subject:* Re: FW: $$Excel-Macros$$ need formula Highlight

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

@googlegroups.com Cc: Manjunath Narayanappa; Prince Subject: Re: FW: $$Excel-Macros$$ need formula Highlight Hi Manjunath, See below pdf. I hope it will help you. http://ide20.com/upload/ModuleAE/Lesson01.pdf http://ide20.com/upload/ModuleAE/Lesson02.pdf http://ide20.com/upload/ModuleAE/Lesson03.pdf

$$Excel-Macros$$ Need Formula to get user logged in

hi friends; i need a formula that will tell me about which user has logged in the particular file -- Midhun Thampan. Administrator(Business Process Management) Maersk Global Services. Powai, Hiranandani. Mumbai:400076 -- Join official Facebook page of this forum @

$$Excel-Macros$$ need formula Highlight

Of Manjunath Narayanappa Sent: 17 January 2013 08:47 To: 'excel-...@googlegroups.com' Subject: $$Excel-Macros$$ need formula Highlight Dear Expert, Good afternoon have a nice day :) I have a data in the attached spreadsheet, automatically data in B column should get highlighted when

$$Excel-Macros$$ need formula Highlight

Of Manjunath Narayanappa Sent: 17 January 2013 08:47 To: 'excel-...@googlegroups.com' Subject: $$Excel-Macros$$ need formula Highlight Dear Expert, Good afternoon have a nice day :) I have a data in the attached spreadsheet, automatically data in B column should get highlighted when

$$Excel-Macros$$ need formula Highlight

Dear Expert, Good afternoon have a nice day :) I have a data in the attached spreadsheet, automatically data in B column should get highlighted when there is a duplicate or repeated entry. Please help me on this. Thanks Manjunath PLEASE CONSIDER THE

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

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 amreshkushw...@gmail.comwrote: On Thu, Jan 17, 2013 at 12:21 PM, Deepak Rawat deepakexce...@gmail.com wrote: Dear Anoop, I need as i

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

Dear all, Please can I get macro for below requests Regards Manjunath From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Manjunath Narayanappa Sent: 17 January 2013 08:47 To: 'excel-macros@googlegroups.com' Subject: $$Excel-Macros$$ need formula Highlight

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

you can use conditional formatting for this  --- On Thu, 1/17/13, Manjunath Narayanappa manjunath.narayana...@aon.co.uk wrote: From: Manjunath Narayanappa manjunath.narayana...@aon.co.uk Subject: FW: $$Excel-Macros$$ need formula Highlight To: 'excel-macros@googlegroups.com' excel-macros

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

-...@googlegroups.com javascript:] *On Behalf Of *Manjunath Narayanappa *Sent:* 17 January 2013 08:47 *To:* 'excel-...@googlegroups.com javascript:' *Subject:* $$Excel-Macros$$ need formula Highlight Dear Expert, Good afternoon have a nice day :) I have a data in the attached spreadsheet

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 deepakexce...@gmail.comwrote: Hi, thax for reply but still unsolved in panchayat it should come 2 rather

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

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

$$Excel-Macros$$ Need formula

HI, Could u suggest any formula to get summary from the data attached in summary sheet. -- 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, Need Help, Formula

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 deepakexce...@gmail.comwrote: HI, Could u suggest any formula to get summary from the data attached in summary sheet. -- Join official Facebook page

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 aks.sharm...@gmail.comwrote: 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

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 deepakexce...@gmail.comwrote: Dear Anoop, I need as i given table. regards, Deepak rawat On Thu, Jan 17, 2013 at 11:43 AM,

Re: $$Excel-Macros$$ Need formula

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

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 prabakar.k...@gmail.comwrote: 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

$$Excel-Macros$$ Need Formula

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 RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem,

$$Excel-Macros$$ Need formula based on 3 condition

Hello All, Requesting to help again. I.ve tried IF condition to solve this problem but failed. I don.t know how to create conditions with multiple If. With Regards, Suyog -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise,

$$Excel-Macros$$ Need formula based on 3 condition

Hello All, Please see attached excel, I'm confused how can I set IF statement based on varying 3 condition for one cell. Please review advice. With Regards, *Suyog* -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate

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

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

Sent: Tuesday, December 11, 2012 12:29 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 advance please. Raghu Nandan R-- Join official Facebook page of this forum @ https://www.facebook.com

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 in

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

$$Excel-Macros$$ need formula help

Sir Please see the sample and help me.In this file Row C4 to AD 4 has amount to be paid for each unit.If emp-1 done 2 units in c5 then c5*c4 , emp-2 done 3 units in c6 then c6*c4. as same up to AD to all employes. I already set formula in AE for all employes.Please verify and suggest me for

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

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 rajey...@gmail.com wrote: Dear Sir I need formula in b2 and c2 max and minimum value of a2:a40 excluding

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 rajey...@gmail.com wrote: Dear Sir I need formula in b2 and c2 max and minimum value of a2:a40 excluding other than numbers. rgds --

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 noorain.ans...@gmail.comwrote: Dear Rajesh, Please try it..

$$Excel-Macros$$ need formula

Hello everyone I need simple average and minimum formula in the column but excluding the value if 0. thanks -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles.

Re: $$Excel-Macros$$ need formula

- From: rajeyssh rajey...@gmail.com To: excel-macros@googlegroups.com Sent: Tue, September 25, 2012 5:47:00 AM Subject: $$Excel-Macros$$ need formula Hello everyone I need simple average and minimum formula in the column but excluding the value if 0

RE: $$Excel-Macros$$ need formula

: $$Excel-Macros$$ need formula Hello everyone I need simple average and minimum formula in the column but excluding the value if 0. thanks -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use

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

, 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.Can I got this formula Thank

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, सुनिता पौडेल tosune...@gmail.com 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

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

: See sumproduct formulas in attached. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com *From:* group birle birlegr...@gmail.com *Sent:* Wednesday, July 18, 2012 7: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

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, सुनिता पौडेल tosune...@gmail.com 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, सुनिता पौडेल

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 noorain.ans...@gmail.comwrote: 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, सुनिता पौडेल

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 noorain.ans...@gmail.comwrote: 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 noorain.ans...@gmail.com wrote:

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 also

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, सुनिता पौडेल tosune...@gmail.com wrote: Hi, Still not working :( its 2010 On Fri, Jul 13, 2012 at 12:04 PM, NOORAIN ANSARI

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 noorain.ans...@gmail.comwrote: Hi Sunita, Please confirm.. Is it not working..

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

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 support you all have been providing. sunita -- FORUM RULES (986+ members already

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, सुनिता पौडेल tosune...@gmail.com wrote: wow thnx... is there

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

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 boy and girl wow thnx

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, सुनिता पौडेल tosune...@gmail.com 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

  1   2   >