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

2015-09-07 Thread 'David Lanne' via MS EXCEL AND VBA MACROS
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

$$Excel-Macros$$ Count If Cell Contains

2015-09-07 Thread 'David Lanne' via MS EXCEL AND VBA MACROS
| 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$$ How to learn VBA or MACORS myself at home???

2014-07-14 Thread 'David Lanne' via MS EXCEL AND VBA MACROS
Slaying Excel Dragons by Mike Girvin is a good book. I still can't figure out all the language stuff. But what helped me was recording marcos doing simple stuff, (ex renaming sheets, sorting data, etc) then stepping into the marco and I could see what its doing, which helped down the line when I