date:20111002

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
> minimum percentage number. Kindly help me to sort out this problem.
>
> Text is : minimum qualification pcm with 50% or MCA 60%
> Result should be : 50%
>
> I've attached the file, Please find enclosed.
>
>
> Thanks
> Karan Singh
>
>  
> 
> 
>  
> 
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Regards
Rajan verma
+91 9158998701

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

=IFERROR(MIN(--MID(A2,SMALL(IFERROR(ROW(INDIRECT("1:"&LEN(A2)))*SEARCH("%",MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1)),""),ROW(INDIRECT("1:"&MAX(1,LEN(A2)-LEN(SUBSTITUTE(A2,"%",""))-2,3)),"")


Another flaw with the formula is that since this uses 3 characters, if your
text has a single digit percentage starting at the very beginning of the
text like '8% with pcm or 45% in the aggregate', it will return a blank, and
not 8%. But I guess that would be a very rare case :D

Enjoy,

Sam Mathai Chacko (GL)


On Sun, Oct 2, 2011 at 5:15 PM, rajan verma wrote:

> 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
>> minimum percentage number. Kindly help me to sort out this problem.
>>
>> Text is : minimum qualification pcm with 50% or MCA 60%
>> Result should be : 50%
>>
>> I've attached the file, Please find enclosed.
>>
>>
>> Thanks
>> Karan Singh
>>
>>  
>> 
>> 
>>  
>> 
>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Regards
> Rajan verma
> +91 9158998701
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Sam Mathai Chacko

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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).AutoFilter 1, ">1"
.Offset(, -1).Resize(, 2).Copy
Sheets.Add(After:=ActiveSheet).Cells(1)
.AutoFilter
.Cells(0).Resize(.Rows.Count + 1).Clear
End With

End Sub

Regards,

Sam Mathai Chacko (GL)

On Sun, Oct 2, 2011 at 11:05 AM, anil kumar  wrote:

> Hi suman,
>
>
> I have a address software in which data enterd by other opprters and I
> think some data is double so i want to export data from there in excel short
> out double data than i will remove that data from software. so i wanted to
> printout that double address.
>
>
>
>
> Anil
>
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Sam Mathai Chacko

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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/*
> *http://noorain-ansari.blogspot.com/*
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
B.N Chetan kumar

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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 Ayush
>> --
>> Thanks & regards,
>> Noorain Ansari
>>  *http://excelmacroworld.blogspot.com/*
>> *http://noorain-ansari.blogspot.com/*
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> B.N Chetan kumar
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*http://www.excelvbamacros.com/*


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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 awarded the Microsoft MVP award
for the 2nd year in row...

Congrate Ayush
-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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.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 Ayush
>> --
>> Thanks & regards,
>> Noorain Ansari
>>  *http://excelmacroworld.blogspot.com/*
>> *http://noorain-ansari.blogspot.com/*
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> B.N Chetan kumar
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Sam Mathai Chacko

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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,Vehicle,"")

Once you are done with that, use the following formulas in your Revisit
summary sheet

D5=SUMPRODUCT((EntryDate>=$A5)*(EntryDate<=$B5))
E5=SUM(IF(FREQUENCY(IF(LEN(Data)>0,MATCH(Data,Data,0),""),
IF(LEN(Data)>0,MATCH(Data,Data,0),""))>0,1)) *Array Formula*
F5=D5-E5
G5=SUM(IF(FREQUENCY(IF(LEN(Data)>0,MATCH(Data,Data,0),""),
IF(LEN(Data)>0,MATCH(Data,Data,0),""))=G$3,1)) *Array Formula*

H5:L5 - Copy formula from G5

You can continue from M5 to a few more columns to the right, (maybe till
frequency of 10) and copy the above formula

OR

have all frequencies greater than or equal to 7 by slightly modifying the
above formula as this

M5=SUM(IF(FREQUENCY(IF(LEN(Data)>0,MATCH(Data,Data,0),""),
IF(LEN(Data)>0,MATCH(Data,Data,0),""))*>*=M$3,1)) *Array Formula*

Note the last part where I added a greater than symbol. Unfortunately, I am
not able to upload the file now.

Happy Meru Cabbing. We enjoy your service.

Regards,

Sam Mathai Chacko (GL)

On Sun, Oct 2, 2011 at 6:18 PM, Amit Desai (MERU)
wrote:

>  Dear All,
>
> ** **
>
> Need your help..
>
> ** **
>
> Please find attached excel file. I need to analyse revisit of vehicles in
> workshop with a moving average of 30 days 1st aug to 1st Sept, 2nsAug
> to 2nsSept. Thus I need total count of vehicles in a period & unique count
> of vehicles in a period. 
>
> ** **
>
> One sheet is log – raw data & other sheet is Revisit summary where in I
> need answer is orange cells. I could get the result fir the first period (1
> st Aug to 1st Sept)butcould not get the correct answer for second period
> onwards
>
> ** **
>
> Also suggest if any changes can be done to simplify the formula used in
> current file...
>
> ** **
>
> Regards,
>
> *Amit Desai*
>
> --
> Disclaimer: This message and its attachments contain confidential
> information and may also contain legally privileged information. This
> message is intended solely for the named addressee. If you are not the
> addressee indicated in this message (or authorized to receive for
> addressee), you may not copy or deliver any part of this message or its
> attachments to anyone or use any part of this message or its attachments.
> Rather, you should permanently delete this message and its attachments (and
> all copies) from your system and kindly notify the sender by reply e-mail.
> Any content of this message and its attachments that does not relate to the
> official business of Meru Cab Company Pvt. Ltd. must be taken not to have
> been sent or endorsed by any of them. Email communications are not private
> and no warranty is made that e-mail communications are timely, secure or
> free from computer virus or other defect.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Sam Mathai Chacko

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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 consistent contributor to this excel forum but has
> acheived this recognition for first time.
>
> *About Noorain Ansari :*
> [image: noorain.jpg]
>
> Noorain is a great poet and keep sharing his thoughts on different topics
> throgh cool poems. Professionally, he is a Excel aficionado and presently
> working as senior business analyst in One97 Communication Ltd. He is a MS
> excel - vba expert and keep sharing his thoughts with this forum. You can
> follow his blogs for Excel knowledge and cool poems :
> www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com
>
> *Noorain, Many thanks for all your great support to group. Keep it up*
>
> *Thanks to Don Guillett, Bheema, Venkat, GoldenLance, Ashish Koul, XLS S ,
> Paul and other folks for helping excel enthusiasts voluntarily !! Keep it up
> !!
>
> *Keep posting.
>
> Regards
> Ayush Jain
> Group Manager
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
<>

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://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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,
>>>
>>> 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/*
>>> *http://noorain-ansari.blogspot.com/*
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>
>>
>> --
>> B.N Chetan kumar
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *http://www.excelvbamacros.com/*
>
>
> P Before printing, think about the environment.
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Regards
Rajan verma
+91 9158998701

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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. He has been consistent contributor to this excel forum but has
> acheived this recognition for first time.
>
> *About Noorain Ansari :*
> [image: noorain.jpg]
>
> Noorain is a great poet and keep sharing his thoughts on different topics
> throgh cool poems. Professionally, he is a Excel aficionado and presently
> working as senior business analyst in One97 Communication Ltd. He is a MS
> excel - vba expert and keep sharing his thoughts with this forum. You can
> follow his blogs for Excel knowledge and cool poems :
> www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com
>
> *Noorain, Many thanks for all your great support to group. Keep it up*
>
> *Thanks to Don Guillett, Bheema, Venkat, GoldenLance, Ashish Koul, XLS S ,
> Paul and other folks for helping excel enthusiasts voluntarily !! Keep it up
> !!
>
> *Keep posting.
>
> Regards
> Ayush Jain
> Group Manager
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
syed aliya

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
<>

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 the month of
>> Sept'11
>> He has posted 140 posts in sept 2011 and helped many people through his
>> expertise. He has been consistent contributor to this excel forum but has
>> acheived this recognition for first time.
>>
>> *About Noorain Ansari :*
>> [image: noorain.jpg]
>>
>> Noorain is a great poet and keep sharing his thoughts on different topics
>> throgh cool poems. Professionally, he is a Excel aficionado and presently
>> working as senior business analyst in One97 Communication Ltd. He is a MS
>> excel - vba expert and keep sharing his thoughts with this forum. You can
>> follow his blogs for Excel knowledge and cool poems :
>> www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com
>>
>> *Noorain, Many thanks for all your great support to group. Keep it up*
>>
>> *Thanks to Don Guillett, Bheema, Venkat, GoldenLance, Ashish Koul, XLS S
>> , Paul and other folks for helping excel enthusiasts voluntarily !! Keep it
>> up !!
>>
>> *Keep posting.
>>
>> Regards
>> Ayush Jain
>> Group Manager
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> .
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Regards
Rajan verma
+91 9158998701

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
<>

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 Microsoft MVP award for 
the 2nd year in row...

Congrate Ayush
-- 

Thanks & regards,
Noorain Ansari
http://excelmacroworld.blogspot.com/
http://noorain-ansari.blogspot.com/

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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()
>
> 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).AutoFilter 1, ">1"
> .Offset(, -1).Resize(, 2).Copy
> Sheets.Add(After:=ActiveSheet).Cells(1)
> .AutoFilter
> .Cells(0).Resize(.Rows.Count + 1).Clear
> End With
>
> End Sub
>
> Regards,
>
> Sam Mathai Chacko (GL)
>
>
> On Sun, Oct 2, 2011 at 11:05 AM, anil kumar  wrote:
>
>> Hi suman,
>>
>>
>> I have a address software in which data enterd by other opprters and I
>> think some data is double so i want to export data from there in excel short
>> out double data than i will remove that data from software. so i wanted to
>> printout that double address.
>>
>>
>>
>>
>> Anil
>>
>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Sam Mathai Chacko
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Regards
Rajan verma
+91 9158998701

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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' for the month of
> Sept'11
> He has posted 140 posts in sept 2011 and helped many people through his
> expertise. He has been consistent contributor to this excel forum but has
> acheived this recognition for first time.
>
> *About Noorain Ansari :*
> [image: noorain.jpg]
>
> Noorain is a great poet and keep sharing his thoughts on different topics
> throgh cool poems. Professionally, he is a Excel aficionado and presently
> working as senior business analyst in One97 Communication Ltd. He is a MS
> excel - vba expert and keep sharing his thoughts with this forum. You can
> follow his blogs for Excel knowledge and cool poems :
> www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com
>
> *Noorain, Many thanks for all your great support to group. Keep it up*
>
> *Thanks to Don Guillett, Bheema, Venkat, GoldenLance, Ashish Koul, XLS S ,
> Paul and other folks for helping excel enthusiasts voluntarily !! Keep it up
> !!
>
> *Keep posting.
>
> Regards
> Ayush Jain
> Group Manager
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Regards,

Shiek

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
<>

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 for appreciating Meru's service

Regards,
Amit Desai



From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Sam Mathai Chacko
Sent: 02 October 2011 21:28
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help needed to find total & Unique count from a 
range of moving dates

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,Vehicle,"")

Once you are done with that, use the following formulas in your Revisit summary 
sheet

D5=SUMPRODUCT((EntryDate>=$A5)*(EntryDate<=$B5))
E5=SUM(IF(FREQUENCY(IF(LEN(Data)>0,MATCH(Data,Data,0),""), 
IF(LEN(Data)>0,MATCH(Data,Data,0),""))>0,1)) Array Formula
F5=D5-E5
G5=SUM(IF(FREQUENCY(IF(LEN(Data)>0,MATCH(Data,Data,0),""), 
IF(LEN(Data)>0,MATCH(Data,Data,0),""))=G$3,1)) Array Formula

H5:L5 - Copy formula from G5

You can continue from M5 to a few more columns to the right, (maybe till 
frequency of 10) and copy the above formula

OR

have all frequencies greater than or equal to 7 by slightly modifying the above 
formula as this

M5=SUM(IF(FREQUENCY(IF(LEN(Data)>0,MATCH(Data,Data,0),""), 
IF(LEN(Data)>0,MATCH(Data,Data,0),""))>=M$3,1)) Array Formula

Note the last part where I added a greater than symbol. Unfortunately, I am not 
able to upload the file now.

Happy Meru Cabbing. We enjoy your service.

Regards,

Sam Mathai Chacko (GL)
On Sun, Oct 2, 2011 at 6:18 PM, Amit Desai (MERU) 
mailto:amit.de...@merucabs.com>> wrote:
Dear All,

Need your help..

Please find attached excel file. I need to analyse revisit of vehicles in 
workshop with a moving average of 30 days 1st aug to 1st Sept, 2nsAug to 
2nsSept. Thus I need total count of vehicles in a period & unique count of 
vehicles in a period.

One sheet is log - raw data & other sheet is Revisit summary where in I need 
answer is orange cells. I could get the result fir the first period (1st Aug to 
1st Sept)butcould not get the correct answer for second period onwards

Also suggest if any changes can be done to simplify the formula used in current 
file...

Regards,
Amit Desai


Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to 
excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel



--
Sam Mathai Chacko
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Disclaimer: This messa

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:

>  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 for appreciating Meru’s service
>
> ** **
>
> Regards,
>
> *Amit Desai*
>
> * *
>
> * *
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Sam Mathai Chacko
> *Sent:* 02 October 2011 21:28
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Help needed to find total & Unique count
> from a range of moving dates
>
> ** **
>
> 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,Vehicle,"")
>
> Once you are done with that, use the following formulas in your Revisit
> summary sheet
>
> D5=SUMPRODUCT((EntryDate>=$A5)*(EntryDate<=$B5))
> E5=SUM(IF(FREQUENCY(IF(LEN(Data)>0,MATCH(Data,Data,0),""),
> IF(LEN(Data)>0,MATCH(Data,Data,0),""))>0,1)) *Array Formula*
> F5=D5-E5
> G5=SUM(IF(FREQUENCY(IF(LEN(Data)>0,MATCH(Data,Data,0),""),
> IF(LEN(Data)>0,MATCH(Data,Data,0),""))=G$3,1)) *Array Formula*
>
> H5:L5 - Copy formula from G5
>
> You can continue from M5 to a few more columns to the right, (maybe till
> frequency of 10) and copy the above formula
>
> OR
>
> have all frequencies greater than or equal to 7 by slightly modifying the
> above formula as this
>
> M5=SUM(IF(FREQUENCY(IF(LEN(Data)>0,MATCH(Data,Data,0),""),
> IF(LEN(Data)>0,MATCH(Data,Data,0),""))*>*=M$3,1)) *Array Formula*
>
> Note the last part where I added a greater than symbol. Unfortunately, I am
> not able to upload the file now.
>
> Happy Meru Cabbing. We enjoy your service.
>
> Regards,
>
> Sam Mathai Chacko (GL)
>
> On Sun, Oct 2, 2011 at 6:18 PM, Amit Desai (MERU) 
> wrote:
>
> Dear All,
>
>  
>
> Need your help..
>
>  
>
> Please find attached excel file. I need to analyse revisit of vehicles in
> workshop with a moving average of 30 days 1st aug to 1st Sept, 2nsAug
> to 2nsSept. Thus I need total count of vehicles in a period & unique count
> of vehicles in a period. 
>
>  
>
> One sheet is log – raw data & other sheet is Revisit summary where in I
> need answer is orange cells. I could get the result fir the first period (1
> st Aug to 1st Sept)butcould not get the correct answer for second period
> onwards
>
>  
>
> Also suggest if any changes can be done to simplify the formula used in
> current file...
>
>  
>
> Regards,
>
> *Amit Desai*
>
> ** **
>  --
>
> Disclaimer: This message and its attachments contain confidential
> information and may also contain legally privileged information. This
> message is intended solely for the named addressee. If you are not the
> addressee indicated in this message (or authorized to receive for
> addressee), you may not copy or deliver any part of this message or its
> attachments to anyone or use any part of this message or its attachments.
> Rather, you should permanently delete this message and its attachments (and
> all copies) from your system and kindly notify the sender by reply e-mail.
> Any content of this message and its attachments that does not relate to the
> official business of Meru Cab Company Pvt. Ltd. must be taken not to have
> been sent or endorsed by any of them. Email communications are not private
> and no warranty is made that e-mail communications are timely, secure or
> free from computer virus or other defect.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
>
>
>
> --
> Sam Mathai Chacko
>
> --
>
> -

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
> Visita ; http://www.youtube.com/user/timextag41
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Visita ; http://sites.google.com/site/chilexcel/Home
Visita ; http://www.youtube.com/user/timextag41

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$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/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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 2nd year in row...
>
> Congrate Ayush
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*
*
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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 been consistent contributor to this excel forum but has
> acheived this recognition for first time.
>
> *About Noorain Ansari :*
> [image: noorain.jpg]
>
> Noorain is a great poet and keep sharing his thoughts on different topics
> throgh cool poems. Professionally, he is a Excel aficionado and presently
> working as senior business analyst in One97 Communication Ltd. He is a MS
> excel - vba expert and keep sharing his thoughts with this forum. You can
> follow his blogs for Excel knowledge and cool poems :
> www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com
>
> *Noorain, Many thanks for all your great support to group. Keep it up*
>
> *Thanks to Don Guillett, Bheema, Venkat, GoldenLance, Ashish Koul, XLS S ,
> Paul and other folks for helping excel enthusiasts voluntarily !! Keep it up
> !!
>
> *Keep posting.
>
> Regards
> Ayush Jain
> Group Manager
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
<>

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:

> Hi suman,
>
>
> I have a address software in which data enterd by other opprters and I
> think some data is double so i want to export data from there in excel short
> out double data than i will remove that data from software. so i wanted to
> printout that double address.
>
>
>
>
> Anil
>
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 







   «•´`•.(*•.¸(`•.¸*¸.•´)¸.•*).•´`•»
«´¨*•.¸¸.*.~*--Suman --*~..*.¸¸.•*¨`»
   «•´`•.(¸.•´(¸.• * •.¸)`•.¸).•´`•»

Mob: +91 9810333884

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
<>

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 the attached file.
>
> In this case I need create 4 PPTs i.e. for
> 1) Title A one PPT with same file name as Title,
> 2) Title B one PPT with same file name as Title,
> 3) Title C one PPT with same file name as Title,
> 4) Title D one PPt with same file name as Title.
>
>
> Thanks,
>
> Chandra Shekar B
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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 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/*
>> *http://noorain-ansari.blogspot.com/*
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
>   *
> *
> *
> *
> *
> *
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 







   «•´`•.(*•.¸(`•.¸*¸.•´)¸.•*).•´`•»
«´¨*•.¸¸.*.~*--Suman --*~..*.¸¸.•*¨`»
   «•´`•.(¸.•´(¸.• * •.¸)`•.¸).•´`•»

Mob: +91 9810333884

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
<>

$$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 and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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 the date value in excel as "dd/mm/".  But like to get the
> output
> as "dd-mmm-"
>
> please help and oblige
>
> Thank you in advance
>
> Ragards,
>
> Sanjib
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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,
>
> 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 the date value in excel as "dd/mm/".  But like to get
>> the output
>> as "dd-mmm-"
>>
>> please help and oblige
>>
>> Thank you in advance
>>
>> Ragards,
>>
>> Sanjib
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

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

Re: $$Excel-Macros$$ find doubling

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

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

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

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ find doubling

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ find doubling

Re: $$Excel-Macros$$ PPT

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

$$Excel-Macros$$ Urgent Help!

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

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

28 matches

Site Navigation

Mail list logo

Footer information