$$Excel-Macros$$ count if filter problem

Hi, need help on filter countif formula not showing only filtered calculation( count ) but count visible working fine here in attached file i put formula but when i put filter on pname showing all other count solution pls Thanks -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wan

Re: $$Excel-Macros$$ Count uniques with only 1 criteria column

Thanks Paul. The concatenation is a good idea so I can 'force' them to be considered as one in the list. Looks like I'm forced to used helper cells to complete the count? I don't believe you can pass an array argument into the concatenation function? On Tue, May 23, 2017 at 7:23 AM, Paul Schrei

Re: $$Excel-Macros$$ Count uniques with only 1 criteria column

There are several approaches.Using Excel functions, I would concatenate the values;=A2&"_"&B2which would result in:SNUser1001   25  1001_251002   25  1002_251003   26  1003_261001   25  1001_251004   26  1004_26 Then you can use your functions to count unique values of column C. You can do so

$$Excel-Macros$$ Count uniques with only 1 criteria column

Hello all, I have a bit of a variation from the count unique values with 2 criteria... in this case I have two columns: the first is a list of serial numbers that does contain duplicates and the second column is the user number that has used that serial number (also contains duplicates). For e

Re: $$Excel-Macros$$ Count Number Frequency

Dear All, Any update on this query. Pls help. Thanks Abhishek On Mon, Feb 27, 2017 at 11:45 AM, Abhishek Kumar Tanwar < abhishekkumartanw...@gmail.com> wrote: > Dear All, > > Want to know, how many calls are drop in 24 hrs, 48 hrs and after 48 hrs > by each mobile number. > > Sheet is attache

$$Excel-Macros$$ Count Number Frequency

Dear All, Want to know, how many calls are drop in 24 hrs, 48 hrs and after 48 hrs by each mobile number. Sheet is attached. Pls help in this query. Thanks Abhishek -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook pa

Re: $$Excel-Macros$$ Count of blank cells conditions to non empty another cells

Hi Nikkipram Please share some dummy data. On Tue, Nov 22, 2016 at 12:34 AM, Nikkipram wrote: > Hi all, > I have a mis containing the payment details of the invoices > > Column a multiple lines with pro duct details > Column b with invoice value(same value against each products..bcoz invoice >

$$Excel-Macros$$ Count of blank cells conditions to non empty another cells

Hi all, I have a mis containing the payment details of the invoices Column a multiple lines with pro duct details Column b with invoice value(same value against each products..bcoz invoice value will be same if multiple items are billed in a single invoices) Column c with cheque no, if payment no

$$Excel-Macros$$ Count of blank cells conditions to non empty another cells

Hi all, I have a mis containing the payment details of the invoices Column a multiple lines with pro duct details Column b with invoice value(same value against each products..bcoz invoice value will be same if multiple items are billed in a single invoices) Column c with cheque no, if payment no

Re: $$Excel-Macros$$ Count of date in multiple sheets of same workbook

I tried taking a look at it, but there were too many questions to address in the time I had available.I can try to describe SOME of questions. Keep in mind that YOU know what you're attempting to do, YOU know what the data means and YOU know what you want your report to look like.WE can only spen

Re: $$Excel-Macros$$ Count of date in multiple sheets of same workbook

Hi Guys, Please revert. On Wed, Jun 15, 2016 at 11:10 PM, Devendra Sahay < devendrasahanypt...@gmail.com> wrote: > Hi Guys, > > > Right now am working in on report in which I have to count the a > particular date in multiple sheets & am doing it by using the function - > Countifs and the i have

$$Excel-Macros$$ Count of date in multiple sheets of same workbook

Hi Guys, Right now am working in on report in which I have to count the a particular date in multiple sheets & am doing it by using the function - Countifs and the i have to write a long formula for it. Another one issue is to extract total amount of bookings in current week in multiple sheets.

$$Excel-Macros$$ Count a particular alphabet in a string

Dear genius I want to count total no. of any alphabet like a,b,c,d in a given string and it should be dynamic by excel vba suppose string is as follo Excel knowledge is good for future. Criteria:How many "o" in the string, find by vba Ragards Narendra -- Are you =EXP(E:RT) or =NOT(EXP(E

Re: $$Excel-Macros$$ Count If Cell Contains

Great Abhishek!. Regards, Prafull Jadhav 9920553518 On 8 September 2015 at 11:51, 'David Lanne' via MS EXCEL AND VBA MACROS < excel-macros@googlegroups.com> wrote: > Thank you very much > > > > On Tuesday, September 8, 2015 2:17 AM, Swapnil Palande < > palande.swapni...@gmail.com> wrote: > > > G

Re: $$Excel-Macros$$ Count If Cell Contains

Thank you very much On Tuesday, September 8, 2015 2:17 AM, Swapnil Palande wrote: Great...Learned somthing new today... Thanks Abhishek. Regards,Swapnil Palande On Tue, Sep 8, 2015 at 11:33 AM, Abhishek Jain wrote: Just one correction, if I may: Countif(A1:A100,"(IRE)") would only

Re: $$Excel-Macros$$ Count If Cell Contains

Great...Learned somthing new today... Thanks Abhishek. Regards, Swapnil Palande On Tue, Sep 8, 2015 at 11:33 AM, Abhishek Jain wrote: > Just one correction, if I may: > > Countif(A1:A100,"(IRE)") would only count the cells having exact text as > "(IRE)" not those which *contain* "(IRE)". For t

Re: $$Excel-Macros$$ Count If Cell Contains

Just one correction, if I may: Countif(A1:A100,"(IRE)") would only count the cells having exact text as "(IRE)" not those which *contain* "(IRE)". For that you would have to put an asterisk before and after the look up text so as to do wild card search. Here is what your formula would be: =Counti

Re: $$Excel-Macros$$ Count If Cell Contains

Assuming data stored in Range A1:A100 Put this formula in B1, it will give the count of IRE in the given Range CountIf(A1:A100,"(IRE)") Use the same again with another criteria CountIf(A1:A100,"(xxx)") -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,

$$Excel-Macros$$ Count If Cell Contains

| Bernardini | | Candy Ride (ARG) | | Candy Ride (ARG) | | Cape Blanco (IRE) | | Cape Cross (IRE) | | Champs Elysees (GB) | | Champs Elysees (GB) | | Congrats | | Curlin | | Danehill Dancer (IRE) | | Dansili (GB) | | Disco Ri

Re: $$Excel-Macros$$ count # of common strings between two cells

  End If     Next C End Sub  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 -

$$Excel-Macros$$ count # of common strings between two cells

Here is what I have -- 1 A B C D E F G 2 12,13 11 9,10 12 14,16 6 A,B 3 12 11 9,10 11 18 6 A 1. I would like to find number of common string between A2 and A3, B2 and B3, etc 2. I would like to get total number of strings in each line, regardless of cell or comma 3. this is what the results

Re: $$Excel-Macros$$ Count if in an active status

type this in g1 =SUM(IF(F1>=DATE(YEAR($B$1:$B$14),MONTH($B$1:$B$14),1),IF(F1<=DATE(YEAR($C$1:$C$14),MONTH($C$1:$C$14),1),1,0))) and press ctrl +shift =enter see if it helps On Fri, May 15, 2015 at 12:10 AM, Heather Battle wrote: > that's correct > > On Thursday, May 14, 2015 at 1:13:52 PM U

Re: $$Excel-Macros$$ Count if in an active status

that's correct On Thursday, May 14, 2015 at 1:13:52 PM UTC-4, ashish wrote: > > just wanted to check even if the some one is active just for a day in a > month like start date is 1 jan 2014 and end date is 2 jan 2014 will that > be counted as active in jan month > > > On Thu, May 14, 2015 at 1

Re: $$Excel-Macros$$ Count if in an active status

just wanted to check even if the some one is active just for a day in a month like start date is 1 jan 2014 and end date is 2 jan 2014 will that be counted as active in jan month On Thu, May 14, 2015 at 10:37 PM, Heather Battle wrote: > I have a spreadsheet where i have participants that enro

$$Excel-Macros$$ Count if in an active status

I have a spreadsheet where i have participants that enrollment start and end dates. i would like to know if there is a formula to determine if they were in active status for a particular month and since there is a group of them, to count a number people who were also active given the start and e

$$Excel-Macros$$ Count Unique Value in Date Range

Dear Experts, Kindly help in formula to count unique values in give date range. I tried with sumproduct but failed. Sample data is attached. Thanks for your kind support, always. Regards, Zafar 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

Re: $$Excel-Macros$$ Count duplicate records.

t;>>> By "formula", do you mean Excel "function" or VBA functions in a macro? >>>> >>>> *Paul* >>>> - >>>> >>>> >>>> >>>> >>>> >>&g

Re: $$Excel-Macros$$ Count duplicate records.

gt;> >>> >>> >>> >>> *“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$$ Count duplicate records.

;> >> >> >> >> >> *“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$$ Count duplicate records.

” - John Wesley* > ----- > > *From:* Ahmad Mustfa > *To:* excel-macros@googlegroups.com > *Sent:* Wednesday, February 11, 2015 6:00 AM > *Subject:* $$Excel-Macros$$ Count duplicate records. > > Hi all. > I am looking for a formula to

Re: $$Excel-Macros$$ Count duplicate records.

Thanks for the reply . good effort. Could you please see the attachment i have created actual format i wanted? On Thu, Feb 12, 2015 at 12:14 PM, Vaibhav Joshi wrote: > Hi > > check attached file: > > use follo. formula to count distinct values: > =SUMPRODUCT(1/COUNTIF(A1:A10,A1:A10)) > > & for d

Re: $$Excel-Macros$$ Count duplicate records.

Hi check attached file: use follo. formula to count distinct values: =SUMPRODUCT(1/COUNTIF(A1:A10,A1:A10)) & for duplicated values: =COUNT($A$1:$A$10)-SUMPRODUCT(1/COUNTIF(A1:A10,A1:A10)) Where A1 to A1o is your range of class. Cheers!! On Wed, Feb 11, 2015 at 4:30 PM, Ahmad Mustfa wrote: >

Re: $$Excel-Macros$$ Count duplicate records.

ou can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - > > From: Ahmad Mustfa >To: excel-macros@googlegroups.com >Sent: Wednesday, February 11, 2015 6:00 A

$$Excel-Macros$$ Count duplicate records.

Hi all. I am looking for a formula to count duplicate records for a specific class/field in excel. Please help. Thanks -- Regards, Ahmad Mustafa +44 7768197568 -- 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 thi

Re: $$Excel-Macros$$ Count ATM ID WITH FOURMULA

Hi try anyone of below.. =SUMPRODUCT(--($B$2:$B$820=$O11)*($C$2:$C$820=P$10)) or =COUNTIFS($B$2:$B$820,$O11,$C$2:$C$820,P$10) Thankx & Rgds, Chandra Singh Bisht Ph -: 09818724321 On Wed, Sep 10, 2014 at 12:30 PM, Saleem Ansari wrote: > Dear Sir, > > Please Find The Attachment > > Please

Re: FW: $$Excel-Macros$$ Count help

From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *AK >> *Sent:* Wednesday, March 19, 2014 8:15 AM >> *To:* excel-macros@googlegroups.com >> *Subject:* $$Excel-Macros$$ Count help >> >> >> >> Hi All, >> &

Re: FW: $$Excel-Macros$$ Count help

com > *Subject:* $$Excel-Macros$$ Count help > > > > Hi All, > > > > I need to count the non-blank cell from the latest month (Cell M1 -- Feb > 2014) to last blank cell and ignoring rest of the previous values. > > countblank or CountA formula is not working as

FW: $$Excel-Macros$$ Count help

pfa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of AK Sent: Wednesday, March 19, 2014 8:15 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Count help Hi All, I need to count the non-blank cell from the latest month (Cell M1 -- Feb

$$Excel-Macros$$ Count help

Hi All, I need to count the non-blank cell from the latest month (Cell M1 -- Feb 2014) to last blank cell and ignoring rest of the previous values. countblank or CountA formula is not working as they are counting all the cells in the range. For example 1: If I need to update cell N2 the value

Re: $$Excel-Macros$$ Count of 1, 2, 3..... in a range

Hi Kathirvelan, Hope I have done for what you are looking for. Your didn't elaborate properly. I did this, consider as number and also as digit. Regards, Waseem Saifi On Sat, Mar 1, 2014 at 5:00 PM, KATHIRVELAN N wrote: > Dear Friends, > > Please help me to count the 1, 2, 3 in row range.

$$Excel-Macros$$ Count of 1, 2, 3..... in a range

Dear Friends, Please help me to count the 1, 2, 3 in row range. Thanks, Kathirvelan -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use con

Fwd: $$Excel-Macros$$ COUNT OF RECOVERY DAYS

-- Forwarded message -- From: SUDHIR VERMA Date: 12 February 2014 21:34 Subject: $$Excel-Macros$$ COUNT OF RECOVERY DAYS To: excel-macros Dear All, Please suggest me to prepare recovery days. Better explanation in attachment. thanking you Sudhir Verma -- Are you =EXP(E:RT

$$Excel-Macros$$ COUNT OF RECOVERY DAYS

Dear All, Please suggest me to prepare recovery days. Better explanation in attachment. thanking you Sudhir Verma -- 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/discussexc

Re: $$Excel-Macros$$ Count Names City Wise

Thanx !! Regards, Deepak On Fri, May 31, 2013 at 1:20 PM, priti verma wrote: > have u enter it with CSE, > PFA for better clarification > > > On Fri, May 31, 2013 at 1:17 PM, Deepak Rawat wrote: > >> its giving 1 for delhi rather than 3 >> >> Kindly check >> >> regards >> >> >> On Fri, May 31,

Re: $$Excel-Macros$$ Count Names City Wise

have u enter it with CSE, PFA for better clarification On Fri, May 31, 2013 at 1:17 PM, Deepak Rawat wrote: > its giving 1 for delhi rather than 3 > > Kindly check > > regards > > > On Fri, May 31, 2013 at 1:08 PM, priti verma wrote: > >> use this >> >> =SUM(N(FREQUENCY(IF($F$4:$F$13=A4,IF($G$4:

Re: $$Excel-Macros$$ Count Names City Wise

its giving 1 for delhi rather than 3 Kindly check regards On Fri, May 31, 2013 at 1:08 PM, priti verma wrote: > use this > > =SUM(N(FREQUENCY(IF($F$4:$F$13=A4,IF($G$4:$G$13<>"",ROW($G$4:$G$13),""),""),IF($F$4:$F$13=A4,IF($G$4:$G$13<>"",ROW($G$4:$G$13),""),""))>0)) > > > On Fri, May 31, 2013 at

Re: $$Excel-Macros$$ Count Names City Wise

use this =SUM(N(FREQUENCY(IF($F$4:$F$13=A4,IF($G$4:$G$13<>"",ROW($G$4:$G$13),""),""),IF($F$4:$F$13=A4,IF($G$4:$G$13<>"",ROW($G$4:$G$13),""),""))>0)) On Fri, May 31, 2013 at 12:59 PM, Deepak Rawat wrote: > Hi, > > I need a formula to count names of managers city wise, attached > > Pls advise > >

$$Excel-Macros$$ Count Names City Wise

Hi, I need a formula to count names of managers city wise, attached Pls advise 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)

Re: $$Excel-Macros$$ Count cell (Decimal Value) in range

Thanks Prabhu sir On Tue, Apr 23, 2013 at 8:52 PM, Prabhu Pinky wrote: > Hi Amar, > > Please check the attached file. hope it works for your concern. > > > > > On 17 April 2013 17:03, amar takale wrote: > >> Dear All >> Can tell anyone tell me how to count cell of decimal no.value in range.I >>

Re: $$Excel-Macros$$ Count cell (Decimal Value) in range

roups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *amar takale > *Sent:* 17 April 2013 5:03 > *To:* excel-macros@googlegroups.com > > *Subject:* $$Excel-Macros$$ Count cell (Decimal Value) in range > > ** ** > > Dear All > > Can tell anyone tell

Re: $$Excel-Macros$$ Count cell (Decimal Value) in range

- > > > -- > *From:* amar takale > *To:* excel-macros@googlegroups.com > *Sent:* Wed, April 17, 2013 8:16:37 AM > *Subject:* Re: $$Excel-Macros$$ Count cell (Decimal Value) in range > > Dear Paul > Perfect,your answer is corre

Re: $$Excel-Macros$$ Count cell (Decimal Value) in range

From: amar takale To: excel-macros@googlegroups.com Sent: Wed, April 17, 2013 8:16:37 AM Subject: Re: $$Excel-Macros$$ Count cell (Decimal Value) in range Dear Paul Perfect,your answer is correct,now i understand of my mistek. Thanks very much sir Regards Amar On Wed, Apr 17, 2013 at 5:20 PM, Paul Sc

Re: $$Excel-Macros$$ Count cell (Decimal Value) in range

> -- > *From:* amar takale > *To:* excel-macros@googlegroups.com > *Sent:* Wed, April 17, 2013 7:33:44 AM > *Subject:* $$Excel-Macros$$ Count cell (Decimal Value) in range > > Dear All > Can tell anyone tell me how to count cell of decimal no.value in range.

Re: $$Excel-Macros$$ Count cell (Decimal Value) in range

esley - From: amar takale To: excel-macros@googlegroups.com Sent: Wed, April 17, 2013 7:33:44 AM Subject: $$Excel-Macros$$ Count cell (Decimal Value) in range Dear All Can tell anyone tell me how to count cell of decimal no.value in range.I try but not come co

Re: $$Excel-Macros$$ Count No of Days between Start and End Date over a period of different years

o all the people you can, >> As long as ever you can.” - John Wesley >> *- >> >> >> -- >> *From:* prkhan56 >> *To:* excel-macros@googlegroups.com >> *Sent:* Tue, February 19, 2013 6:21:

Re: $$Excel-Macros$$ Count No of Days between Start and End Date over a period of different years

At all the times you can, > To all the people you can, > As long as ever you can.” - John Wesley > *- > > > -- > *From:* prkhan56 > *To:* excel-macros@googlegroups.com > *Sent:* Tue, February 19, 2013 6:21:59 AM > *Subject:* Re: $$Excel-Macros$$ Count No of Days between S

Re: $$Excel-Macros$$ Count No of Days between Start and End Date over a period of different years

helps. > > > *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 ca

Re: $$Excel-Macros$$ Count No of Days between Start and End Date over a period of different years

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 - ____________ From: Paul Schreiner To: excel-macros@googlegroups.com Sent: Tue, February 19, 2013 7:42:26 AM

Re: $$Excel-Macros$$ Count No of Days between Start and End Date over a period of different years

can, As long as ever you can.” - John Wesley - From: prkhan56 To: excel-macros@googlegroups.com Sent: Tue, February 19, 2013 6:21:59 AM Subject: Re: $$Excel-Macros$$ Count No of Days between Start and End Date over a peri

Re: $$Excel-Macros$$ Count No of Days between Start and End Date over a period of different years

u 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 > *--------- > > > -- > *From:* Rashid Khan > > *To:* excel-.

RE: $$Excel-Macros$$ Count No of Days between Start and End Date over a period of different years

-Macros$$ Count No of Days between Start and End Date over a period of different years Hello All, I am attaching a sample file for my problem. I wish to have a formula entered in Cell D2 (highlighted in yellow - to be dragged across and down) to calculate the number of days in Col D, E and F

Re: $$Excel-Macros$$ Count No of Days between Start and End Date over a period of different years

-- From: Rashid Khan To: excel-macros@googlegroups.com Sent: Mon, February 18, 2013 3:11:46 PM Subject: $$Excel-Macros$$ Count No of Days between Start and End Date over a period of different years Hello All, I am attaching a sample file for my problem. I

$$Excel-Macros$$ Count No of Days between Start and End Date over a period of different years

Hello All, I am attaching a sample file for my problem. I wish to have a formula entered in Cell D2 (highlighted in yellow - *to be dragged across and down*) to calculate the number of days in Col D, E and F over different years from the Start and End Date. Thanks in advance Rashid Khan -- Are

$$Excel-Macros$$ Count Names - Macro

Dear all, I am writing to request help in updating my current macro code, so it output's name count based on unique values from coulmn A, B and C, as currently it is based on only column B. current output: can be shown on the example workbook in sheet 4 desired output: RBS = 5 CA = 1 SG = 1

Re: $$Excel-Macros$$ Count

Yes Viper, your formula is totalling perfect On Thu, Feb 7, 2013 at 2:19 PM, The Viper wrote: > did you try =SUM(1/COUNTIFS(A2:A10,A2:A10,B2:B10,B2:B10,C2:C10,C2:C10)) > with CSE ??? > > > On Thu, Feb 7, 2013 at 2:44 PM, Smitha S R wrote: > >> Hi, >> Required is : >> >> >> Count of names matchi

Re: $$Excel-Macros$$ Count

did you try =SUM(1/COUNTIFS(A2:A10,A2:A10,B2:B10,B2:B10,C2:C10,C2:C10)) with CSE ??? On Thu, Feb 7, 2013 at 2:44 PM, Smitha S R wrote: > Hi, > Required is : > > > Count of names matching product 'A' and Id '1S' is 4 > and count of names matching product 'A' and ID '2B' is 4 > > > On Thu, Feb 7,

Re: $$Excel-Macros$$ Count

Hi, Required is : Count of names matching product 'A' and Id '1S' is 4 and count of names matching product 'A' and ID '2B' is 4 On Thu, Feb 7, 2013 at 2:40 PM, Aamir Shahzad wrote: > check now > > =COUNTIFS($A$2:$A$10,A5,$B$2:$B$10,B5,$C$2:$C$10,C5) > > On Thu, Feb 7, 2013 at 1:58 PM, Smitha S

Re: $$Excel-Macros$$ Count

check now =COUNTIFS($A$2:$A$10,A5,$B$2:$B$10,B5,$C$2:$C$10,C5) On Thu, Feb 7, 2013 at 1:58 PM, Smitha S R wrote: > Hi, > This formula does not suit my requirement. I have to count the names > matching the product and ID. > > > On Thu, Feb 7, 2013 at 2:09 PM, Aamir Shahzad > wrote: > >> You c

Re: $$Excel-Macros$$ Count

Hi, This formula does not suit my requirement. I have to count the names matching the product and ID. On Thu, Feb 7, 2013 at 2:09 PM, Aamir Shahzad wrote: > You can use: > > =COUNTIFS($A$2:$A$10,A2,$B$2:$B$10,B2) > > Aamir Shahzad > > On Thu, Feb 7, 2013 at 1:36 PM, Smitha S R wrote: > >> Hi, >

Re: $$Excel-Macros$$ Count

use =SUM(1/COUNTIFS(A2:A10,A2:A10,B2:B10,B2:B10,C2:C10,C2:C10)) with CSE On Thu, Feb 7, 2013 at 2:09 PM, Aamir Shahzad wrote: > You can use: > > =COUNTIFS($A$2:$A$10,A2,$B$2:$B$10,B2) > > Aamir Shahzad > > On Thu, Feb 7, 2013 at 1:36 PM, Smitha S R wrote: > >> Hi, >> >> Please help me in findin

Re: $$Excel-Macros$$ Count

You can use: =COUNTIFS($A$2:$A$10,A2,$B$2:$B$10,B2) Aamir Shahzad On Thu, Feb 7, 2013 at 1:36 PM, Smitha S R wrote: > Hi, > > Please help me in finding the count of unique values matching criteria as > in the attachment. > > Regard > Smitha > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Ex

$$Excel-Macros$$ Count

Hi, Please help me in finding the count of unique values matching criteria as in the attachment. Regard Smitha -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Count in cell formula

Dear Excel Learner, *"You can also try"* Google stats will show you in active posters list and you will get more counts. On Fri, Jan 18, 2013 at 4:39 PM, Ms-Exl-Learner wrote: > Hm... No one is understanding what I am trying to say... > > It's not only about this post, I am also talking about

Re: $$Excel-Macros$$ Count in cell formula

@Gawli Anil, Hm... No one is understanding what I am trying to say... It's not only about this post, I am also talking about the posts in which I am not at all involved. if you see in every post I am seeing everyone knowingly doing the copy paste of the same solution which is already offered

Re: $$Excel-Macros$$ Count in cell formula

Dear Ms-Exl-Learner, Hey Dear, Keep helping others that's good but don't tally with others... You has done it ...that's good we appreciate ur talent:) Warm Regards, Gawli Anil On Fri, Jan 18, 2013 at 4:03 PM, Ms-Exl-Learner wrote: > @ Gawli Anil, > > I am not seeing anyone spent

Re: $$Excel-Macros$$ Count in cell formula

@ Gawli Anil, I am not seeing anyone spent time in giving solution for this, Just seeing copy paste, *Including your post*. On 18-01-2013 10:32 AM, ?? wrote: Hey Our User , Yaar don't get personal afterall we have to help others. Warm Regardsm Gawli Anil On Fri, Jan 18

Re: $$Excel-Macros$$ Count in cell formula

Dear All My friend, Thanks everybody to solved my problem & spent time for my solution. With the help of expertise, I am very Glad Regards Amar On Fri, Jan 18, 2013 at 10:32 AM, अनिल नारायण गवली wrote: > Hey Our User , > > Yaar don't get personal afterall we have to help others. > >

Re: $$Excel-Macros$$ Count in cell formula

Hey Our User , Yaar don't get personal afterall we have to help others. Warm Regardsm Gawli Anil On Fri, Jan 18, 2013 at 2:46 AM, Excel_Lover wrote: > ha ha!!! > > > > On Thu, Jan 17, 2013 at 2:22 PM, Ms-Exl-Learner > wrote: > >> @ Noorain Ansari, >> >> Could you ple

Re: $$Excel-Macros$$ Count in cell formula

ha ha!!! On Thu, Jan 17, 2013 at 2:22 PM, Ms-Exl-Learner wrote: > @ Noorain Ansari, > > Could you please explain what is the use of *Sumproduct* in your below > formula? > > *=SUMPRODUCT(LEN(C5)-LEN(SUBSTITUTE(C5,",",""))+1)* > > Why not it should be *LEN(C5)-LEN(SUBSTITUTE(C5,

Re: $$Excel-Macros$$ Count in cell formula

venus On Jan 17, 2013 3:41 PM, "amar takale" wrote: > Dear champs > Pl suggest simple count formula in cell > > -- > 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 > He

Re: $$Excel-Macros$$ Count in cell formula

Okay i gotbut i have not taken 30 minutes for this solution. -- With Regards, Noorain Ansari http:// noorainansari.com http:// excelvbaclinic.com On

Re: $$Excel-Macros$$ Count in cell formula

@ Noorain Ansari, Could you please explain what is the use of /*Sumproduct*/ in your below formula? /*=SUMPRODUCT(LEN(C5)-LEN(SUBSTITUTE(C5,",",""))+1)*/ Why not it should be /*LEN(C5)-LEN(SUBSTITUTE(C5,",",""))+1*/? Since both will result the same answer. *My Suggestion Posted HALF AN HOU

Re: $$Excel-Macros$$ Count in cell formula

If cell is non-blank you can use. it.. On Thu, Jan 17, 2013 at 4:19 PM, NOORAIN ANSARI wrote: > Dear Amar, > > You can also try... > > *=SUMPRODUCT(LEN(C5)-LEN(SUBSTITUTE(C5,",",""))+1) > * > > -- > With Regards, > Noorain Ansari > http:// > noorainansari.com

Re: $$Excel-Macros$$ Count in cell formula

Dear Amar, You can also try... *=SUMPRODUCT(LEN(C5)-LEN(SUBSTITUTE(C5,",",""))+1) * -- With Regards, Noorain Ansari http:// noorainansari.com http:// excelvbaclinic.com

Re: $$Excel-Macros$$ Count in cell formula

psl find attached herewith Warm Regards, Gawli Anil On Thu, Jan 17, 2013 at 3:48 PM, Ms-Exl-Learner wrote: > =IF(LEN(TRIM(C5)),LEN(C5)-LEN(SUBSTITUTE(C5,",",""))+1,"") > -- Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- Join official Facebook

Re: $$Excel-Macros$$ Count in cell formula

* In D5 cell =IF(LEN(TRIM(C5)),LEN(C5)-LEN(SUBSTITUTE(C5,",",""))+1,"") Drag it down...* On 17-01-2013 3:40 PM, amar takale wrote: Dear champs Pl suggest simple count formula in cell -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use co

$$Excel-Macros$$ Count in cell formula

Dear champs Pl suggest simple count formula in cell -- 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, Code Problem, and Need Advice

Re: $$Excel-Macros$$ count no of students for each month

PFA Thanks, On Fri, Dec 7, 2012 at 7:52 PM, BINSAR DENNY wrote: > Dear Surder, > > are you need like attached. > > > On Fri, Dec 7, 2012 at 7:31 PM, Sundarvelan N wrote: > >> Thaks for your reply >> >> But i need 6 for July >> >> Unique value. >> Thanks >> N.Sundarvelan >> 9600160150 >> >> >

Re: $$Excel-Macros$$ count no of students for each month

Dear Surder, are you need like attached. On Fri, Dec 7, 2012 at 7:31 PM, Sundarvelan N wrote: > Thaks for your reply > > But i need 6 for July > > Unique value. > Thanks > N.Sundarvelan > 9600160150 > > > > On Fri, Dec 7, 2012 at 5:48 PM, Born to Win wrote: > >> PFA >> >> >> Thanks, >> >> >> >

Re: $$Excel-Macros$$ count no of students for each month

Thaks for your reply But i need 6 for July Unique value. Thanks N.Sundarvelan 9600160150 On Fri, Dec 7, 2012 at 5:48 PM, Born to Win wrote: > PFA > > > Thanks, > > > > > > On Fri, Dec 7, 2012 at 3:45 AM, Sundarvelan N wrote: > >> Dear Gurus, >> >> Please help me to count no of students for

Re: $$Excel-Macros$$ count no of students for each month

PFA Thanks, On Fri, Dec 7, 2012 at 3:45 AM, Sundarvelan N wrote: > Dear Gurus, > > Please help me to count no of students for each month > > For example : > > july 6 students > Thanks > N.Sundarvelan > 9600160150 > > -- > Join official Facebook page of this forum @ > https://www.facebook.c

$$Excel-Macros$$ count no of students for each month

Dear Gurus, Please help me to count no of students for each month For example : july 6 students Thanks N.Sundarvelan 9600160150 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like P

Re: $$Excel-Macros$$ Count the no of Red colored cells and green colored cells

file with formula On 30 October 2012 16:41, Sundarvelan N wrote: > Dear Gurus, > > Please help me to Count the no of Red colored cells and green colored > cells. > Thanks > N.Sundarvelan > 9600160150 > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel >

Re: $$Excel-Macros$$ Count the no of Red colored cells and green colored cells

hi Sundarvelan, You can use the following array formulas for count the Red & Green cells. Please note it's calculating the cell values not cell colors. See the attached file. =COUNT(IF(D2:AG2>C2,D2:AG2)) =COUNT(IF(D2:AG2<=C2,D2:AG2)) Aamir Shahzad On Tue, Oct 30, 2012 at 4:11 PM, Sundarvelan

$$Excel-Macros$$ Count the no of Red colored cells and green colored cells

Dear Gurus, Please help me to Count the no of Red colored cells and green colored cells. Thanks N.Sundarvelan 9600160150 -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate threa

Re: $$Excel-Macros$$ Count multiple criteria in a column with the help of VBA

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$$ Count multiple criteria in a column with the help of VBA

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 - From: jeet singh To: excel-macros@googlegroups.com Sent: Wed, September 12, 2012 2:32:12 PM Subject:

Re: $$Excel-Macros$$ Count when po is greater than zero

> * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Muralidhar E > *Sent:* 04 September 2012 11:28 > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Count when po is greater than zero > > **

RE: $$Excel-Macros$$ Count when po is greater than zero

om> Sent: Monday, September 03, 2012 3:33 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Count when po is greater than zero Hi, Thanks for quickly reply, but it is not working, in result columncount of name is not coming, name is appears, Plz, ignore the column E

Re: $$Excel-Macros$$ Count when po is greater than zero

ft Excel Developer >>> SalesAid Software >>> dguille...@gmail.com >>> >>> *From:* Muralidhar E >>> *Sent:* Monday, September 03, 2012 3:33 AM >>> *To:* excel-macros@googlegroups.com >>> *Subject:* Re: $$Excel-Macros$$ Count when p

  1   2   3   >