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