Re: $$Excel-Macros$$ regarding date format in excel vba

2011-10-02 Thread Sanjib Chatterjee
thank you for your quick responce Swapnil Palande . But i want to say is there any option in excel to put the date value like "dd/mm/",without changing my computer date format. Thanking you Sanjib On Mon, Oct 3, 2011 at 11:43 AM, Swapnil Palande < palande.swapni...@gmail.com> wrote: > Hi

Re: $$Excel-Macros$$ regarding date format in excel vba

2011-10-02 Thread Swapnil Palande
Hi, Use format function. ex. MsgBox Format(CDate("03/10/2011"), "dd-mmm-") Regards, Swapnil. On Mon, Oct 3, 2011 at 11:33 AM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > Dear Friends, > > would u please help me about the below mentioned problem in VBA EXCEL > > I like to put

$$Excel-Macros$$ Urgent Help!

2011-10-02 Thread rashid memon
Hi, Can any one help me. My Excel Files are *corupted *Please tell me what i can do for *Recover Excel files.* * * * * Rashid Memon. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks

Re: $$Excel-Macros$$ New Microsoft MVP Mr. Ayush Jain (2nd Times)..

2011-10-02 Thread Suman
Congrats...!!! On Mon, Oct 3, 2011 at 10:10 AM, Venkat CV wrote: > Dear Ayush, > > Congrats > > *Best Regards,* > *Venkat * > *Chennai* > *My Linked in profile > * > > On Sun, Oct 2, 2011 at 8:40 PM, NOORAIN ANSARI > wrote: > >> Dear Gro

Re: $$Excel-Macros$$ PPT

2011-10-02 Thread Chandra Shekar
Hello, Any help on this. Thanks in advance. Regards, Chandra Shekar B On Fri, Sep 30, 2011 at 8:47 AM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hello, > > I am looking for a macro which can copy slides based on TITLE and create a > new presentation. Could u please help me out in

Re: $$Excel-Macros$$ find doubling

2011-10-02 Thread Suman
Use this =countif(A:A,A2)>1 in conditional formating. Its compares all of the values in column A to the contents of cell A2 the condition is TRUE if there r more den one. After dat set the format if there r duplicate. Then use filter by color. On Sun, Oct 2, 2011 at 11:05 AM, anil kumar wrote: >

Re: $$Excel-Macros$$ Most Helpful Member Sep'11 - Noorain Ansari

2011-10-02 Thread Amresh Maurya
Congratulation Noorain... Regards Amresh On Sat, Oct 1, 2011 at 12:13 PM, Ayush Jain wrote: > Hello Everyone, > > Noorain Ansari has been selected as 'Most Helpful Member' for the month of > Sept'11 > He has posted 140 posts in sept 2011 and helped many people through his > expertise. He has be

Re: $$Excel-Macros$$ New Microsoft MVP Mr. Ayush Jain (2nd Times)..

2011-10-02 Thread Venkat CV
Dear Ayush, Congrats *Best Regards,* *Venkat * *Chennai* *My Linked in profile * On Sun, Oct 2, 2011 at 8:40 PM, NOORAIN ANSARI wrote: > Dear Group, > > Our Group Manager Mr. Ayush Jain has been awarded the Microsoft MVP award > for the 2n

$$Excel-Macros$$ Most Helpful Member Sep'11 - Noorain Ansari

2011-10-02 Thread Frank Linden
Thank you Noorain for working so hard to help all of us who need it. It is very much appreciated -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exce

Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

2011-10-02 Thread ChilExcel
Urgent !! i Need VB lines codes for 2011/10/1 ChilExcel > hi > > i Need VB lines codes for > Alert MsgBox Pair duplicate entry in row > > Column D function account and duplicates alerts (NO Problem!) > Attach File , thank you all > > -- > Visita ; http://sites.google.com/site/chilexcel/Home > Vi

Re: $$Excel-Macros$$ Help needed to find total & Unique count from a range of moving dates

2011-10-02 Thread Sam Mathai Chacko
Amit, please go to Names Manager, and give the name of the range as Data, and use the formula that I provided below. To go to Name Manager using a short-cut key, hit CTRL+F3 Post back if you need more help. Regards, Sam Mathai Chacko (GL) On Mon, Oct 3, 2011 at 12:10 AM, Amit Desai (MERU) wrote

RE: $$Excel-Macros$$ Help needed to find total & Unique count from a range of moving dates

2011-10-02 Thread Amit Desai (MERU)
Dear Sam, Thanks for the detailed explanation but I could not understand the range "Data" - how to create a range. I have selected data set in for Vehicle & EntryDate & created data range for the same. But could not move further since I could not create "Data" range. And yes, thanks a lot

Re: $$Excel-Macros$$ Most Helpful Member Sep'11 - Noorain Ansari

2011-10-02 Thread Shiek Peer Mohd
Congrats Noorain. You deserved it.. Congrats to Don Guillett, Bheema, Venkat, GoldenLance, Ashish Koul, XLS S , Paul for your valuable suggestions Regards Shiek On Sun, Oct 2, 2011 at 12:43 AM, Ayush Jain wrote: > Hello Everyone, > > Noorain Ansari has been selected as 'Most Helpful Member' f

Re: $$Excel-Macros$$ find doubling

2011-10-02 Thread rajan verma
You can Also use Conditional Fomatting in Excel-2007 to Identify Dulicatte Recort. GoTo Conditional Formatting -> new Rule -> Format Only Unique Or Duplicate Values . Regards Rajan On Sun, Oct 2, 2011 at 5:45 PM, Sam Mathai Chacko wrote: > Here's one way of doing it. > > Sub CopyDuplicates() >

Re: $$Excel-Macros$$ New Microsoft MVP Mr. Ayush Jain (2nd Times)..

2011-10-02 Thread dguillett1
As an M$ Excel MVP, I also welcome him to the group From: NOORAIN ANSARI Sent: Sunday, October 02, 2011 10:10 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ New Microsoft MVP Mr. Ayush Jain (2nd Times).. Dear Group, Our Group Manager Mr. Ayush Jain has been awarded the Microsof

Re: $$Excel-Macros$$ Most Helpful Member Sep'11 - Noorain Ansari

2011-10-02 Thread rajan verma
Congrats Our Fankaar Mate ..you are excellent in Excel.. Keep it Up.. On Sun, Oct 2, 2011 at 9:28 PM, XLS S wrote: > Congratulation Noorain > > On Sun, Oct 2, 2011 at 12:43 AM, Ayush Jain wrote: > >> Hello Everyone, >> >> Noorain Ansari has been selected as 'Most Helpful Member' for th

Re: $$Excel-Macros$$ Most Helpful Member Sep'11 - Noorain Ansari

2011-10-02 Thread syed aliya raza hashim
Congratt Noorain bhai you rock On Sun, Oct 2, 2011 at 12:43 AM, Ayush Jain wrote: > Hello Everyone, > > Noorain Ansari has been selected as 'Most Helpful Member' for the month of > Sept'11 > He has posted 140 posts in sept 2011 and helped many people through his > expertise.

Re: $$Excel-Macros$$ New Microsoft MVP Mr. Ayush Jain (2nd Times)..

2011-10-02 Thread rajan verma
Congratulation Ayush.. On Sun, Oct 2, 2011 at 8:55 PM, ashish koul wrote: > Congrats Ayush > > > On Sun, Oct 2, 2011 at 8:54 PM, B.N.Chethan kumar < > chetankumar1...@gmail.com> wrote: > >> congrate mate >> >> >> On Sun, Oct 2, 2011 at 8:40 PM, NOORAIN ANSARI >> wrote: >> >>> Dear Group, >>

Re: $$Excel-Macros$$ New Microsoft MVP Mr. Ayush Jain (2nd Times)..

2011-10-02 Thread XLS S
Congratulation Ayush. On Sun, Oct 2, 2011 at 8:40 PM, NOORAIN ANSARI wrote: > Dear Group, > > Our Group Manager Mr. Ayush Jain has been awarded the Microsoft MVP award > for the 2nd year in row... > > Congrate Ayush > -- > Thanks & regards, > Noorain Ansari > *http://excelmacrowo

Re: $$Excel-Macros$$ Most Helpful Member Sep'11 - Noorain Ansari

2011-10-02 Thread XLS S
Congratulation Noorain On Sun, Oct 2, 2011 at 12:43 AM, Ayush Jain wrote: > Hello Everyone, > > Noorain Ansari has been selected as 'Most Helpful Member' for the month of > Sept'11 > He has posted 140 posts in sept 2011 and helped many people through his > expertise. He has been consist

Re: $$Excel-Macros$$ Help needed to find total & Unique count from a range of moving dates

2011-10-02 Thread Sam Mathai Chacko
Hi Amit, Follow steps carefully in sequence Add 3 named ranges as below Vehicle=LOG!$E$2:INDEX(LOG!$E$2:$E$1,MATCH(REPT("z",20),LOG!$E$2:$E$1,1)) EntryDate=LOG!$B$2:INDEX(LOG!$B$2:$B$1,MATCH(9E+305,LOG!$B$2:$B$1,1)) Data=IF((EntryDate>=Sheet2!$A1)*(EntryDate<=Sheet2!$B1)=1,Vehicl

Re: $$Excel-Macros$$ New Microsoft MVP Mr. Ayush Jain (2nd Times)..

2011-10-02 Thread Sam Mathai Chacko
Your success precedes you Ayush. We acknowledge and appreciate your contribution to the Excel community, and so have Microsoft. Congratulations again on behalf of all those who have and will gain from your selfless endeavors. Best Regards Sam Mathai Chacko (GL) On Sun, Oct 2, 2011 at 8:54 PM, B.

Re: $$Excel-Macros$$ New Microsoft MVP Mr. Ayush Jain (2nd Times)..

2011-10-02 Thread sachin . harale
Congrats ayush... Rgds sachin Sent by emoze push m@il on 3G. - From: "NOORAIN ANSARI" Subject:$$Excel-Macros$$ New Microsoft MVP Mr. Ayush Jain (2nd Times).. Date: 02nd October 2011 8:10 pm Dear Group, Our Group Manager Mr. Ayush Jain has been

Re: $$Excel-Macros$$ New Microsoft MVP Mr. Ayush Jain (2nd Times)..

2011-10-02 Thread ashish koul
Congrats Ayush On Sun, Oct 2, 2011 at 8:54 PM, B.N.Chethan kumar wrote: > congrate mate > > > On Sun, Oct 2, 2011 at 8:40 PM, NOORAIN ANSARI > wrote: > >> Dear Group, >> >> Our Group Manager Mr. Ayush Jain has been awarded the Microsoft MVP award >> for the 2nd year in row... >> >> Congrate

Re: $$Excel-Macros$$ New Microsoft MVP Mr. Ayush Jain (2nd Times)..

2011-10-02 Thread B.N.Chethan kumar
congrate mate On Sun, Oct 2, 2011 at 8:40 PM, NOORAIN ANSARI wrote: > Dear Group, > > Our Group Manager Mr. Ayush Jain has been awarded the Microsoft MVP award > for the 2nd year in row... > > Congrate Ayush > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com

Re: $$Excel-Macros$$ find doubling

2011-10-02 Thread Sam Mathai Chacko
Here's one way of doing it. Sub CopyDuplicates() With Range("B2:B" & Cells(Rows.Count, 1).End(xlUp).Row) .Formula = "=COUNTIF($A$2:$A$" & Cells(Rows.Count, 1).End(xlUp).Row & ",A2)" .Value = .Value .Cells(0) = "COUNT" .Cells(0).Resize(.Rows.Count + 1).AutoFilte

Re: $$Excel-Macros$$ Extract (%) Numbers from the text

2011-10-02 Thread Sam Mathai Chacko
As Ashish rightly points out, these functions will work if your percentages are written in ascending order. However, in cases where your text may look like this 10+2 with 60% with pcm or 45% in the aggregate, it will return 60%, not 45% To tackle this issue, try the following array formula =IFER

Re: $$Excel-Macros$$ Extract (%) Numbers from the text

2011-10-02 Thread rajan verma
Try this: =IF(ISERROR(MID(A2,FIND("%",A2,1)-2,3)),"",MID(A2,FIND("%",A2,1)-2,3)) On Sat, Oct 1, 2011 at 3:08 PM, karan 1237 wrote: > Hello All, > > Hope you all are doing well. I'm here as usual, need your assistance. I'v > text data which have percentage numbers (50% or 60%), I need to extract