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

$$Excel-Macros$$ Count If Cell Contains

rmula that will count (IRE), (GB), etc etcAny help would be appreciated. Thanks,David Lanne -- 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 co

Re: $$Excel-Macros$$ How to learn VBA or MACORS myself at home???

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

Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function

Sorry I zsee I forgot my name   Thanks, David Lanne From: David Lanne To: "excel-macros@googlegroups.com" Sent: Tuesday, November 15, 2011 1:09 AM Subject: Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function Thanks for the guide, I'

Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function

Thanks for the guide, I'm trying to do something similiar to example 3 but I can't seem to get my =getphoto cell (C3) to be a picture. Result comes up 0. I can't seem to get my C3 to accept/format the pic.   My formula is =indirect("Logos!B"&match('newspaper headlines'!$F$3,Logos!$A$:$A$,0)) My

Re: $$Excel-Macros$$ Re: Doesn't this mean?

Thanks From: lifescholar To: MS EXCEL AND VBA MACROS Sent: Monday, September 5, 2011 2:47 AM Subject: $$Excel-Macros$$ Re: Doesn't this mean?     If (Range("c32") <> Range("c33")) Then On Sep 5, 6:06 am, David Lanne wrote: > Sub OTX() > ' > &

Re: $$Excel-Macros$$ Re: Doesn't this mean?

"c32") <> Range("c33")) Then > >On Sep 5, 6:06 am, David Lanne wrote: >> Sub OTX() >> ' >> ' OTX Macro >> ' >> ' >>     If (c32 <> c33) Then >>     End If >>     If (c32 = c33) Then >>    

Re: $$Excel-Macros$$ Doesn't this mean?

acros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de David Lanne Envoyé : lundi 5 septembre 2011 07:06 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$ Doesn't this mean?   Sub OTX() ' ' OTX Macro ' '     If (c32 <> c33) Then     End

$$Excel-Macros$$ Doesn't this mean?

s c33 then it runs "OT". Right now it runs "OT" whether c32/c33 are equal or not.   Thanks, David Lanne -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and

Re: $$Excel-Macros$$ VLOOKUP or Similiar

I think you could insert a new column A and use 1,2,3.1000 to label rows From: NOORAIN ANSARI To: excel-macros@googlegroups.com Sent: Sunday, August 28, 2011 7:18 PM Subject: Re: $$Excel-Macros$$ VLOOKUP or Similiar Dear Cab, If possible please provide a sample sheet.. On Mon, Aug 29, 2

Re: $$Excel-Macros$$ Run - Copy / Paste - Repeat Macro

nd/replace (ctrl-h) there is an option to look in formulas.   You could copy the sheets, then use find/replace to replace references to Info4 with Info3, etc.   Paul From: David Lanne To: excel-macros@googlegroups.com Sent: Thu, April 7, 2011 5:51:07 PM Subject: Re: $$Excel-Macros$$ Run - Co

Re: $$Excel-Macros$$ Run - Copy / Paste - Repeat Macro

I have a similar issue. I have 4 workbooks basically (dumb info 1, dumb info 2, etc). The layout/format of the four are the same. The first 76 sheets of each book contains the data. Another 5-10 sheets are use to consolidate. With dumb info 4 I got playing around with graphs and charts. So I hav

Re: $$Excel-Macros$$ Submit Excel idea or suggestion !

With all the fanasty/real sport stuff it would be nice to have a schedule generator that could do the games with home/away function.   Thanks, David --- On Thu, 2/3/11, Ayush wrote: From: Ayush Subject: $$Excel-Macros$$ Submit Excel idea or suggestion ! To: excel-macros@googlegroups.com Date: