Re: $$Excel-Macros$$ Sumif if criteria 2 match

Dear Amar, You can also try... =SUM(IF(($A$2:$A$69=F3)*($B$2:$B$69>6000),$C$2:$C$69,"")) with ctrl+shift+Enter On Wed, Feb 6, 2013 at 11:40 AM, amar takale wrote: > Hi All, > Pls suggest me Sumif formula if criteria 2 match. > > Regards > Amar > > -- > Are you =EXP(E:RT) or =NO

Re: $$Excel-Macros$$ Sumif if criteria 2 match

hi Amar, for sumifs formula use =SUMIFS($C$2:$C$69,$A$2:$A$69,F3,$B$2:$B$69,">"&6000) for all versions of excel use =SUMPRODUCT(($A$2:$A$69=F3)*($B$2:$B$69>6000)*($C$2:$C$69)) Regards, Aamir Shahzad On Wed, Feb 6, 2013 at 11:29 AM, अनिल नारायण गवली wrote: > Dear Amar, > > Pl find attached . I

Re: $$Excel-Macros$$ Re: Conditional Format Entire Row if Any Column has a specific value

pfa you can modify the range on formula as desired. On Wed, Feb 6, 2013 at 9:34 AM, John A. Smith wrote: > Paul, > > #1) By using conditional formatting, highlight any row the EXACT target > value is in regardless of the column it's in > #2) Has to be an EXACT match > #3) Helper columns are okay

Re: $$Excel-Macros$$ Sumif if criteria 2 match

Hi Amar, You can use *Sumifs formula*. Regards, Kuldeep Singh Info Edge India Limited (naukri.com) Phone.: +91-0120-4841100, Extn.: 2467, 9716615535 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* On Wed, Fe

Re: $$Excel-Macros$$ $$excel-$$ sumproduct not working in vba -reg.

Dear Karunanithi, Pl forward those files I'll see and get back to you later. Warm Regards, Gawli Anil On Wed, Feb 6, 2013 at 11:32 AM, karunanithi ramaswamy wrote: > Dear Gawli Anil, > Thank you very much for your timely help. The formula works fine. > When I copy the code from macro1,

$$Excel-Macros$$ Sumif if criteria 2 match

Hi All, Pls suggest me Sumif formula if criteria 2 match. Regards Amar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thr

Re: $$Excel-Macros$$ $$excel-$$ sumproduct not working in vba -reg.

Dear Gawli Anil,     Thank you very much for your timely help.  The formula works fine. When  I copy the code from macro1, it is not working(error1004 etc)(in Sub Test12..End Sub) R.Karunanithi. 6/2/2013. From: अनिल नारायण गवली To: excel-macros@googlegroup

$$Excel-Macros$$ Excel change Language

Hello Experts, I need your help on how to change excel language. Please help me to clear my below queris 1) I have written my vba in code in english and my excel file is going to use in Germany on german systems with german language excel application. so here is problem my some code is giving ga

Re: $$Excel-Macros$$ Re: Prince Kumar - Most Helpful Member Jan'13

Dear Viking, This is not the right mail to post u r query. better post a fresh mail to our expeert groups. By the way u can use find function or search, or mid to extract your desired word. Warm Regards, Gawli Anil. On Tue, Feb 5, 2013 at 6:55 PM, wrote: > ** > Hi prince > > > I have one q

Re: $$Excel-Macros$$ Macro to hide Rows - Urgent

Hi Please find the attachment with the solution. On Tue, Feb 5, 2013 at 9:50 PM, Secret Shot wrote: > Dear Group, > > I need your expertise, in creating Macro to hide rows, requirement is > mention in attach file. I attached a sample file to explain my requirement. > please Help. > > -- > Pank

Re: $$Excel-Macros$$ Re: Conditional Format Entire Row if Any Column has a specific value

Paul, #1) By using conditional formatting, highlight any row the EXACT target value is in regardless of the column it's in #2) Has to be an EXACT match #3) Helper columns are okay #4) Rows quantity varies but can be between several hundred to approximately 8-9,000 #5) Can be either formula or VBA

Re: $$Excel-Macros$$ Re: Conditional Format Entire Row if Any Column has a specific value

questions: #1) What do you mean by "highlight the row"? #2) will this be an "exact" match? or partial contents of the cells? #3) can we add a "helper" column and filter? #4) How many rows are we talking about? #5) does it have to be a FORMULA? can you use VBA? If we add a new column (either at the

$$Excel-Macros$$ Re: Conditional Format Entire Row if Any Column has a specific value

I wasn't clear enough so I created an example of my question. Thank you all for quick responses. My target value can be in none or one or many of the 180 columns, not interdependent on each other, and not in the same column on different rows. Please see the attached example for a more clear

$$Excel-Macros$$ Macro to hide Rows - Urgent

Dear Group, I need your expertise, in creating Macro to hide rows, requirement is mention in attach file. I attached a sample file to explain my requirement. please Help. -- Pankaj Pandey Bhopal -- 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) !

Re: $$Excel-Macros$$ Formula to find items between two dates

Hi Hilary, Please see the attachment, Hope it will meet your expectation. -- With Regards, Noorain Ansari http:// noorainansari.com http:// excelvbaclinic.com

$$Excel-Macros$$ Re: Prince Kumar - Most Helpful Member Jan'13

Congrats Prince Thanks and regards, Shekhar On Saturday, February 2, 2013 11:49:07 AM UTC+5:30, Ayush Jain wrote: > > > Dear members, > > Prince Kumar has been selected as 'Most Helpful Member' for the month of > Jan'13. He has posted 103 posts last month and helped forum members throu

$$Excel-Macros$$ Re: Conditional Format Entire Row if Any Column has a specific value

Hi John, Please find attached file which has conditional formatting based on criteria you have mentioned. Thanks and regards, Shekhar On Tuesday, February 5, 2013 8:35:08 PM UTC+5:30, JohnA wrote: > > I have a spreadsheet with 180 columns and 8,000 rows. I would like to > highlight a row i

Re: $$Excel-Macros$$ Conditional Format Entire Row if Any Column has a specific value

use this in conditional formatting =AND(COUNTIF(1:1,234)>=1) [image: Inline image 1] Regards Ashish On Tue, Feb 5, 2013 at 8:35 PM, John A. Smith wrote: > I have a spreadsheet with 180 columns and 8,000 rows. I would like to > highlight a row if a specific value is anywhere in the spreadshee

$$Excel-Macros$$ Conditional Format Entire Row if Any Column has a specific value

I have a spreadsheet with 180 columns and 8,000 rows. I would like to highlight a row if a specific value is anywhere in the spreadsheet. (for example in cell K23 = 234 and H112 = 234, then both row 23 and 112 are highlighted). Please help with the formula to accomplish this. Thank you. John -

Re: $$Excel-Macros$$ Re: Prince Kumar - Most Helpful Member Jan'13

Hi prince I have one query I want to find out one word in sentence like vikas-input-vaue >From this above sentence I want to find out " in " word from whole sentence. >Which formula to use Plz help me Vikas Sent from my BlackBerry® Smartphone on Loop Mobile. -Original Message- Fro

Re: $$Excel-Macros$$ user could select either ">" or "<" and the formulawould change *

Pls find attached solution to your query HTH On Tue, Feb 5, 2013 at 9:20 AM, Divaker Pandey wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (divake...@gmail.com) Add cleanup > rule

$$Excel-Macros$$ Macro

Dear Experts, Can you please send me the advance excel & Macro ppt, it will be useful to learn Thanks Manjunath PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL For Aon's standard conditions associated with this e-mail please visit http://www.aon.

Re: $$Excel-Macros$$ Macro For Worksheet

hi Shrinivas, Pl find attached herwith u requirement. Warm Regards, Gawli Anil On Tue, Feb 5, 2013 at 1:29 PM, Shrinivas Shevde wrote: > Dear Anil > Thanks for reply > Basically I want to make different different work book for every worksheet > In attached file I have 3 sheet means I want to

$$Excel-Macros$$ user could select either ">" or "<" and the formula would change

Hi expert, is it possible without macro. I'm trying to make a dynamic formula so the user could select either ">" or "<" and the formula would change. See Attachment. Divaker -- 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 Fac