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:

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

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

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

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

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