Re: $$Excel-Macros$$ Please help..

[NOORAIN ANSARI]

Dear Manoj,

Need more clarification..
What is criteria of Model1,Model2,Model3

Please explain




On Fri, Jul 20, 2012 at 11:15 AM, Manoj Kumar wrote:

>
> Dear Expert,
>
> Please help me
>
> Query file attached with mail...
>
> Regard
> Manoj
>
>
>  --
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>



-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelvbaclinic.blogspot.com

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Help Me

[NOORAIN ANSARI]

Dear Manoj,

Attachment is missing

On Fri, Jul 20, 2012 at 11:13 AM, Manoj Kumar wrote:

> Dear Expert,
>
> Please help me
>
> Query file attached with mail...
>
> Regard
> Manoj
>
> --
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>



-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelvbaclinic.blogspot.com

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Company Name in front of Show its sector

[amar takale]

I used this code But not work. Which I send second file sample 1 Use it &
put code.
If I put code & run code not work. Y also try.My answer in sheet like

 H D F C Bank Ltd. *Bank*
 State Bank Of India *Bank*

 Tata Steel Ltd. *Metals & Minerals*
 Sterlite Industries (India) Ltd. *Metals & Minerals*

 Mahindra & Mahindra Ltd. *Auto*
 Maruti Suzuki India Ltd.*Auto*
On Thu, Jul 19, 2012 at 6:39 PM, dguillett1  wrote:

>   You asked for a macro and I provided one that did work with your
> example. Please fully explain.
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* amar takale 
> *Sent:* Thursday, July 19, 2012 7:59 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Company Name in front of Show its sector
>
> Code is not work.I will Sent file You will work with below code.I use but
> not work.There are any formula?
>
> On Thu, Jul 19, 2012 at 6:09 PM, dguillett1  wrote:
>
>>   Should work
>>
>> Option Explicit
>> Sub groupsSAS()
>> Dim mr As Range
>> Dim b As Range
>> Dim sr As Long
>> Rows(2).Insert
>> Set mr = Cells(2, "b") _
>> .Resize(Cells(Rows.Count, "b").End(xlUp).Row)
>> For Each b In mr.SpecialCells(xlBlanks)
>> sr = b.Offset(-1).End(xlUp).Row
>> Cells(sr, "c") _
>> .Resize(b.Row - sr + 1).Value = Cells(sr, "b")
>> Next b
>> End Sub
>>
>> Don Guillett
>> Microsoft Excel Developer
>> SalesAid Software
>> dguille...@gmail.com
>>
>>  *From:* amar takale 
>> *Sent:* Thursday, July 19, 2012 5:54 AM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ Company Name in front of Show its sector
>>
>>
>> --
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> mailto:excel-macros%2bunsubscr...@googlegroups.com
>>
>>
>>  --
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> mailto:excel-macros%2bunsubscr...@googlegroups.com
>>
>>
>>
>
> --
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>
> --
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Do

Re: $$Excel-Macros$$ Required some MS Excel question for interview.

[NOORAIN ANSARI]

Dear Indrajit,

PFA

On Fri, Jul 20, 2012 at 9:48 AM, Indrajit $nai wrote:

> Thanks Noorain, but please send me the Answer paper also. :)
>
>
> On Fri, Jul 20, 2012 at 8:07 AM, NOORAIN ANSARI 
> wrote:
>
>> Dear Indrajit,
>>
>> See attached sheet, Hope it hlep to you.
>>
>>
>> On Fri, Jul 20, 2012 at 2:04 AM, Indrajit $nai 
>> wrote:
>>
>>>
>>> Hi All,
>>>
>>> Can some one provide me some set of MS Excel (Practical
>>> and Theoretical) question for interview.
>>>
>>> Thanks in advance.
>>>
>>> --
>>> Indrajit
>>>
>>> Disclaimer:
>>> This electronic message and any files transmitted with it are
>>> confidential and intended solely for the use of the individual or entity to
>>> whom they are addressed. If you are not the intended recipient you are
>>> hereby notified that any disclosure, copying, distribution or taking any
>>> action in reliance on the contents of this information is strictly
>>> prohibited and may be unlawful.
>>>
>>> --
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>>
>>>
>>>
>>
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>> www.noorainansari.com
>> www.excelvbaclinic.blogspot.com
>>
>>
>>
>>
>>  --
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>
>
>
>  --
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>



-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelvbaclinic.blogspot.com

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

-

Re: $$Excel-Macros$$ Required some MS Excel question for interview.

[Indrajit $nai]

Thanks Noorain, but please send me the Answer paper also. :)


On Fri, Jul 20, 2012 at 8:07 AM, NOORAIN ANSARI wrote:

> Dear Indrajit,
>
> See attached sheet, Hope it hlep to you.
>
>
> On Fri, Jul 20, 2012 at 2:04 AM, Indrajit $nai wrote:
>
>>
>> Hi All,
>>
>> Can some one provide me some set of MS Excel (Practical
>> and Theoretical) question for interview.
>>
>> Thanks in advance.
>>
>> --
>> Indrajit
>>
>> Disclaimer:
>> This electronic message and any files transmitted with it are
>> confidential and intended solely for the use of the individual or entity to
>> whom they are addressed. If you are not the intended recipient you are
>> hereby notified that any disclosure, copying, distribution or taking any
>> action in reliance on the contents of this information is strictly
>> prohibited and may be unlawful.
>>
>> --
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelvbaclinic.blogspot.com
>
>
>
>
>  --
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ regarding ratio

[NOORAIN ANSARI]

Hi Sunita,

Try this one

*=SUBSTITUTE(TEXT(A1/B1,"?/?"),"/",":")*
or

*=ROUND(A1/B1, 2) &":" & ROUND(B1/A1,2)*


-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelvbaclinic.blogspot.com


On Thu, Jul 19, 2012 at 3:08 PM, सुनिता पौडेल  wrote:

> it shows 1:0
>
> thnx
>
> On Thu, Jul 19, 2012 at 2:57 PM, NOORAIN ANSARI 
> wrote:
>
>> Please try it..
>>
>> Hope it will help to you.
>> =(LEFT(TEXT(A1/B1,"/"),FIND("/",TEXT(A1/B1,"/"))-1)&":"
>> &RIGHT(TEXT(A1/B1,"/"),LEN(TEXT(A1/B1,"/"))
>> -FIND("/",TEXT(A1/B1,"/"
>>
>>
>> On Thu, Jul 19, 2012 at 2:07 PM, सुनिता पौडेल wrote:
>>
>>> not working .is it because add-ins blah..
>>> thnx
>>>
>>> On Thu, Jul 19, 2012 at 1:58 PM, Krishnaraddi V. Madolli <
>>> krishnaraddi.mado...@asia.xchanging.com> wrote:
>>>

 http://spreadsheetpage.com/index.php/tip/a_formula_to_calculate_a_ratio/
 

 ** **

 ** **

 Regards,

 ** **

 Krishnaraddi V Madolli.

 Data Analytics Team

 Sedgwick Claims Management Services, Inc.
 Xchanging Towers, SJR iPark, 

 EPIP Area, Whitefield 

 Bangalore - 560 066. India.

 Direct Line: +1.800.920.9657 Extn 1915

 Switchboard: +90-(0)80-3054 Extn 1915

 Email: krishnaraddi.mado...@asia.xchanging.com 

 krishnaraddi.mado...@sedgwickcms.com

 www.sedgwickcms.com|
 *The leader in innovative claims and productivity management solutions*

 ** **

 Success is never permanent, Failure is never final, so always do not
 stop effort until your victory makes a history.

 *[image:
 http://images.coolchaser.com/themes/t/404137-i311.photobucket.com-albums-kk467-volleycutiegirl-icon.png]
 **Please consider the environment before printing this message***

 ** **

 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *?? ?
 *Sent:* Thursday, July 19, 2012 1:35 PM
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ regarding ratio

 ** **

 Dear all,

  

 Please do me one favor. I tried to find out the ratio between two
 numbers but seems the formula isn't working. So can you please help me.
 

  

 Thank you

  

 Sunita

 --
 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


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

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com

  

 "CONFIDENTIALITY NOTICE: This message and any attachment are
 confidential and may also be privileged. If you are not the intended
 recipient of this e-mail you may not copy, forward, disclose or otherwise
 use it or any part of it in any form whatsoever. If you are not the
 intended recipient please telephone or e-mail the sender and delete this
 message and any attachment from your system."

 --
 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to thi

$$Excel-Macros$$ Re: Error Cleaning

[bpascal123]

 Hi SG,

This code below should help you. You can run it from the vba ide in the 
attached file.
I'm not as comfortable as Don is with vba objects and methods so maybe 
Don's code is better for this.
I don't run if it takes time for many rows, ask again i like to search on 
the web trick to improve coding syntax.

Hope this answers what you need, 

Pascal Baro

Sub SGTest()

Dim wbIn As Workbook
Dim wsIn As Worksheet
Dim wsInOut As Worksheet
Dim v() As Variant
Dim r As Range
Dim rCol As Integer
Dim i As Long, j As Long
Dim lastr As Long, lastc As Long

Set wbIn = Workbooks("Book1 - Copy.xlsm")
'Set wsInOut = wbIn.Worksheets.Add: wsInOut.Name = "sorted data ok2"
Set wsInOut = wbIn.Worksheets("sorted data")
Set wsIn = wbIn.Worksheets("splitted data")

With Application
.Calculation = xlCalculationManual
.DisplayAlerts = False
.ScreenUpdating = False
End With

lastc = 0
wsIn.Rows(1).Copy wsInOut.Rows(1)
lastr = wsIn.Cells(Rows.Count, 8).End(xlUp).Row

For i = lastr To 2 Step -1

Set r = wsIn.Range(wsIn.Cells(i, 8), wsIn.Cells(i, 
wsIn.Columns.Count).End(xlToLeft))
rCol = r.Columns.Count

If rCol > 1 Then
v = Array(r)
wsIn.Rows(i + 1 & ":" & i + rCol - 1).Insert

wsIn.Range(wsIn.Cells(i, 1), wsIn.Cells(i, 7)).Copy _
wsIn.Range(wsIn.Cells(i + 1, 1), wsIn.Cells(i + rCol - 1, 7))

wsIn.Range(wsIn.Cells(i, 8), wsIn.Cells(i + rCol - 1, 8)).Value = _
Application.WorksheetFunction.Transpose(v)

If rCol > lastc Then lastc = rCol

End If

Next i

lastr = wsIn.Cells(Rows.Count, 8).End(xlUp).Row
wsIn.Range(wsIn.Cells(1, 9), wsIn.Cells(lastr, lastc + 9)).ClearContents

With Application
.Calculation = xlCalculationAutomatic
.DisplayAlerts = True
.ScreenUpdating = True
End With

Set r = Nothing
Set wbIn = Nothing
Set wsIn = Nothing
Set wsInOut = Nothing

End Sub

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com




Book1 - Copy.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

$$Excel-Macros$$ Required some MS Excel question for interview.

[Indrajit $nai]

Hi All,

Can some one provide me some set of MS Excel (Practical
and Theoretical) question for interview.

Thanks in advance.

-- 
Indrajit

Disclaimer:
This electronic message and any files transmitted with it are confidential
and intended solely for the use of the individual or entity to whom they
are addressed. If you are not the intended recipient you are hereby
notified that any disclosure, copying, distribution or taking any action in
reliance on the contents of this information is strictly prohibited and may
be unlawful.

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: RE: $$Excel-Macros$$ Re: how i convert pdf file to Excel using macro.

[NOORAIN ANSARI]

Hi Caasi,

Check out this article
http://www.linkedin.com/groups/How-Import-PDF
-File-Data-1871310.S.74131482?trk=group_search_item_list-0-b-ttl&goback=%2Egna_1871310


Sub ImportPDFFileData()
'Author: Steve Lipsman
'Purpose: Import PDF File Data Into Excel Worksheet
'Other Requirement(s): 'Acrobat' Checked in VBA Tools-References
'Reference Renames Itself 'Adobe Acrobat 9.0 Object Library' After
Reference Is Saved

'Declare Variable(s)
Dim appAA As Acrobat.CAcroApp, docPDF As Acrobat.CAcroPDDoc
Dim strFileName As String, intNOP As Integer, arrI As Variant
Dim intC As Integer, intR As Integer, intBeg As Integer, intEnd As Integer

'Initialize Variables
Set appAA = CreateObject("AcroExch.App"): Set docPDF =
CreateObject("AcroExch.PDDoc")

'Set PDF FileName
strFileName = "Your Full PDF File Pathname Here.pdf"

'Read PDF File
docPDF.Open (strFileName)

'Extract Number of Pages From PDF File
intNOP = docPDF.GetNumPages

'Select First Data Cell
Range("A1").Select

'Open PDF File
ActiveWorkbook.FollowHyperlink strFileName, , True

'Loop Through All PDF File Pages
For intC = 1 To intNOP
'Go To Page Number
SendKeys ("+^n" & intC & "{ENTER}")

'Select All Data In The PDF File's Active Page
SendKeys ("^a"), True

'Right-Click Mouse
SendKeys ("+{F10}"), True

'Copy Data As Table
SendKeys ("c"), True

'Minimize Adobe Window
SendKeys ("%n"), True

'Paste Data In This Workbook's Worksheet
ActiveSheet.Paste

'Select Next Paste Cell
Range("A" & Range("A1").SpecialCells(xlLastCell).Row + 2).Select

'Maximize Adobe Window
SendKeys ("%x")
Next intC

'Close Adobe File and Window
SendKeys ("^w"), True

'Empty Object Variables
Set appAA = Nothing: Set docPDF = Nothing

'Select First Cell
Range("A1").Select
End Sub

On Thu, Jul 19, 2012 at 7:08 PM, caasi  wrote:

> Hi Ayush Jain,
>
> I have a question. I have lot of pdf files to be converted to Excel .
> However , the pdf to excel converter converts only  max 2 -5 pages . My
> question is  can we use a macro to convert pdf to excel. please advise
> please its very urgent ..
>
> Thanks ,
>
> Isaac.
>
> On Sunday, February 20, 2011 4:22:14 AM UTC-5, Ayush Jain wrote:
>>
>> Hi Shrinivas,
>>
>> In excel 2007 version and onwards, We already have functionality to save
>> excel in PDF format. So we do not need a VBA for Excel to PDF.
>> While saving excel workbook , Just select the .pdf in 'Save as Type' and
>> this will generate a PDF format file for you.
>>
>> Let me know if you have more questions.
>>
>> Regards
>> Ayush Jain
>> Group Manager.
>
>  --
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>



-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelvbaclinic.blogspot.com

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Fwd: Rank Formula

[xlstime]

Hi Amar,

Please find the attached solution


Rgds,
XLS

On Thu, Jul 19, 2012 at 6:32 PM, amar takale  wrote:

> Sir
> But if student fail Then who is second highest will calculate first Rank
> automatically.
> Thanks
>
> On Thu, Jul 19, 2012 at 6:28 PM, NOORAIN ANSARI 
> wrote:
>
>> Dear Am
>>
>> Dear Amar,
>>
>> see attached sheet, Hope it help to you.
>>
>>
>>
>> On Thu, Jul 19, 2012 at 1:48 PM, amar takale wrote:
>>
>>
>>>
>>> -- Forwarded message --
>>> From: amar takale 
>>> Date: Thu, Jul 19, 2012 at 1:47 PM
>>> Subject: Rank Formula
>>> To: excel-macros@googlegroups.com
>>>
>>>
>>>
>>>
>>>  --
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>>
>>>
>>>
>>
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>> www.noorainansari.com
>> www.excelvbaclinic.blogspot.com
>>
>>
>>
>>
>>  --
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>
>  --
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>



-- 
.

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com




Copy of Rank(Solved).xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: Failure of code when trying to break a section out into a seperate routine

[Anil Pandit]

Thanks Asa,

I changed the code so that, in the parent procedure (PowerReturnOutput), I 
changed the data type of the array (Partnumber()) from "String" to 
"Variable". When passing an array to the routine: EnterPN, I included open 
and closed brackets after the variable name. I also used brackets in 
EnterPN's first argument and it now seems to work fine. Thanks for the help 
again. I also do have an "On Error Resume Next" Statement in the parent 
routine of Sub PowerReturnOutput(), which would explain the seemingly 
strange flow.

I did see values in the array of the called procedure (PNArray) before it 
would exit, in the immediate window, which seems strange. The array was 
declared with a data type of "String" in the parent procedure 
(PowerReturnOutput()), before it was passed as an argument to the child 
(EnterPN) procedure. If you can offer an explanation for this, that would 
be great, however I am just happy it is working and that I know what I 
should do to pass an array as a sub or function argument in future.

Cheers!

Anil

On Sunday, July 15, 2012 11:04:27 AM UTC+1, Anil Pandit wrote:
>
> Hi all,
>
> I have the following code in a sub routine which works (please see code in 
> bold font), but which I want in a separate routine, so I can re-use the 
> code.
>
> --
> Sub PowerReturnOutput()
>
> '   This sub procedure looks up the part number on sheet 4 and returns the
> '   part number & description to sheet 2
>
> Dim PwrAndGnd() As Variant
> Dim Distance As Long
> Dim CableType As String
> Dim PwrColour As String
> Dim RtnColour As String
> Dim PartNumber(1 To 6) As String
> Dim PN As Variant
> Dim Cell As Range
> Dim TOPwrGndPN As Range
> Dim TOPwrGndDesc As Range
> Dim XGPwrAndGnd As Range
> 
> Set TOPwrGndPN = Range("TOPwrGndPN")
> Set TOPwrGndDesc = Range("TOPwrGndDesc")
> Set XGPwrAndGnd = Worksheets("Eagle XG Input").Range("XGPwrAndGnd")
> 
> '   Return an array with the XGArray function.
> PwrAndGnd = XGArray(XGPwrAndGnd)
>
> '   Extract elements into variables, adding 10 to BDFB distance.
> Distance = PwrAndGnd(1) + 10
> PwrColour = PwrAndGnd(3)
> RtnColour = PwrAndGnd(4)
> CableType = PwrAndGnd(5)
> 
> '   Extract part numbers into an array
> PartNumber(1) = AWGxPwrRtnPN(Distance, PwrColour, CableType)
> PartNumber(2) = AWGxPwrRtnPN(Distance, RtnColour, CableType)
> PartNumber(3) = AWG1GndPN(CableType)
> PartNumber(4) = AWG6PwrRtnPN(PwrColour, CableType)
> PartNumber(5) = AWG6PwrRtnPN(RtnColour, CableType)
> PartNumber(6) = AWG6GndPN(CableType)
> 
> *'   Enter the part numbers in sheet 2
> Call EnterPN(PartNumber, TOPwrGndPN)
>
> 'For Each PN In PartNumber()
> 'For Each Cell In TOPwrGndPN
> 'If IsEmpty(Cell) Then
> 'Cell.Value = PN
> 'Exit For
> 'End If
> 'Next Cell
> 'Next PN*
>
> '   Enter the descriptions in sheet 2
> For Each PN In PartNumber()
> For Each Cell In TOPwrGndDesc
> If IsEmpty(Cell) Then
> If PN = "Not Available" Then
> With Cell
> .Value = "EAAA Brown AWG 2/0 cable is not 
> available."
> .Font.Italic = True
> .Font.Color = vbRed
> .Offset(0, -1).Font.Italic = True
> .Offset(0, -1).Font.Color = vbRed
> End With
> Exit For
> Else
> Cell = AWGxPNDesc(PN)
> Exit For
> End If
> End If
> Next Cell
> Next PN
>
> End Sub
> --
>
> I created another sub-routine which is called from the PowerReturnOutput 
> routine:
>
> --
> Sub EnterPN(PNArray, OutputRng)
>
> '   This sub procedure enters part numbers into the output range.
>
> Dim PN As Variant
> Dim Cell As Range
>
> For Each PN In PNArray()
> For Each Cell In OutputRng
> If IsEmpty(Cell) Then
> Cell.Value = PN
> Exit For
> End If
> Next Cell
> Next PN
> 
> End Sub
> --
> The code does not work. When I set a break-point and step through the 
> code, I can see that the EnterPN routine is called and that PNArray() and 
> OutputRng have values in the immediate window. After the line:
>
> For Each PN In PNArray()
>
> The sub exits and returns to the parent of the parent routine from which 
> it was called (i.e the routine which called PowerReturnOutput())!
>
> I hope someone can help me understand and hopefully fix this behaviour.
>
> Regards,
>
> Anil
> --
>

-- 
-- 
FORU

Re: RE: $$Excel-Macros$$ Re: how i convert pdf file to Excel using macro.

[caasi]

Hi Ayush Jain,

I have a question. I have lot of pdf files to be converted to Excel . 
However , the pdf to excel converter converts only  max 2 -5 pages . My 
question is  can we use a macro to convert pdf to excel. please advise 
please its very urgent ..

Thanks ,

Isaac.

On Sunday, February 20, 2011 4:22:14 AM UTC-5, Ayush Jain wrote:
>
> Hi Shrinivas,
>
> In excel 2007 version and onwards, We already have functionality to save 
> excel in PDF format. So we do not need a VBA for Excel to PDF.
> While saving excel workbook , Just select the .pdf in 'Save as Type' and 
> this will generate a PDF format file for you.
>
> Let me know if you have more questions.
>
> Regards
> Ayush Jain
> Group Manager.

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ HOW TO CREATE REPORTS IN EXCEL

[Mangesh Vimay]

Hi Noorain,
Thanks.
Can u provide me examples for all below 3 types based on any same sample
data. So that I could learn it.


On Thu, Jul 19, 2012 at 5:55 PM, NOORAIN ANSARI wrote:

> Dear Mangesh,
>
> To Create report in MS Excel you can use.
>
> 1. Pivot table
> 2. Subtotal
> 3. Consolidate
>
>
>
>
>
> On Thu, Jul 19, 2012 at 3:25 PM, Mangesh Vimay wrote:
>
>> Hi Friends,
>>
>> Please help me on "HOW TO CREATE REPORTS IN EXCEL" by providing suitable
>> examples so that I could learn it.
>> Thanks.
>>
>> --
>> With regards,
>>
>> MaNgEsH
>>
>>  --
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelvbaclinic.blogspot.com
>
>
>
>
>  --
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>



-- 
With regards,

MaNgEsH

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Company Name in front of Show its sector

[dguillett1]

You asked for a macro and I provided one that did work with your example. 
Please fully explain.

Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com

From: amar takale 
Sent: Thursday, July 19, 2012 7:59 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Company Name in front of Show its sector

Code is not work.I will Sent file You will work with below code.I use but not 
work.There are any formula?


On Thu, Jul 19, 2012 at 6:09 PM, dguillett1  wrote:

  Should work

  Option Explicit
  Sub groupsSAS()
  Dim mr As Range
  Dim b As Range
  Dim sr As Long
  Rows(2).Insert
  Set mr = Cells(2, "b") _
  .Resize(Cells(Rows.Count, "b").End(xlUp).Row)
  For Each b In mr.SpecialCells(xlBlanks)
  sr = b.Offset(-1).End(xlUp).Row
  Cells(sr, "c") _
  .Resize(b.Row - sr + 1).Value = Cells(sr, "b")
  Next b
  End Sub

  Don Guillett
  Microsoft Excel Developer
  SalesAid Software
  dguille...@gmail.com

  From: amar takale 
  Sent: Thursday, July 19, 2012 5:54 AM
  To: excel-macros@googlegroups.com 
  Subject: $$Excel-Macros$$ Company Name in front of Show its sector


  -- 
  -- 
  FORUM RULES (986+ members already BANNED for violation)
   
  1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
   
  2) Don't post a question in the thread of another member.
   
  3) Don't post questions regarding breaking or bypassing any security measure.
   
  4) Acknowledge the responses you receive, good or bad.
   
  5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
   
  NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
   
  
--
  To post to this group, send email to excel-macros@googlegroups.com
   
  To unsubscribe, send a blank email to 
mailto:excel-macros%2bunsubscr...@googlegroups.com
   
   

  -- 
  -- 
  FORUM RULES (986+ members already BANNED for violation)
   
  1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
   
  2) Don't post a question in the thread of another member.
   
  3) Don't post questions regarding breaking or bypassing any security measure.
   
  4) Acknowledge the responses you receive, good or bad.
   
  5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
   
  NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
   
  
--
  To post to this group, send email to excel-macros@googlegroups.com
   
  To unsubscribe, send a blank email to 
mailto:excel-macros%2bunsubscr...@googlegroups.com
   
   


-- 
-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
 
 

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

To unsubscribe, send a blank email to excel-m

Re: $$Excel-Macros$$ Fwd: Rank Formula

[amar takale]

Sir
But if student fail Then who is second highest will calculate first Rank
automatically.
Thanks

On Thu, Jul 19, 2012 at 6:28 PM, NOORAIN ANSARI wrote:

> Dear Am
>
> Dear Amar,
>
> see attached sheet, Hope it help to you.
>
>
>
> On Thu, Jul 19, 2012 at 1:48 PM, amar takale  wrote:
>
>
>>
>> -- Forwarded message --
>> From: amar takale 
>> Date: Thu, Jul 19, 2012 at 1:47 PM
>> Subject: Rank Formula
>> To: excel-macros@googlegroups.com
>>
>>
>>
>>
>>  --
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelvbaclinic.blogspot.com
>
>
>
>
>  --
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Company Name in front of Show its sector

[amar takale]

Code is not work.I will Sent file You will work with below code.I use but
not work.There are any formula?

On Thu, Jul 19, 2012 at 6:09 PM, dguillett1  wrote:

>   Should work
>
> Option Explicit
> Sub groupsSAS()
> Dim mr As Range
> Dim b As Range
> Dim sr As Long
> Rows(2).Insert
> Set mr = Cells(2, "b") _
> .Resize(Cells(Rows.Count, "b").End(xlUp).Row)
> For Each b In mr.SpecialCells(xlBlanks)
> sr = b.Offset(-1).End(xlUp).Row
> Cells(sr, "c") _
> .Resize(b.Row - sr + 1).Value = Cells(sr, "b")
> Next b
> End Sub
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* amar takale 
> *Sent:* Thursday, July 19, 2012 5:54 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Company Name in front of Show its sector
>
>
> --
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>
> --
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com




Sample file1.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Fwd: Rank Formula

[NOORAIN ANSARI]

Dear Am

Dear Amar,

see attached sheet, Hope it help to you.


On Thu, Jul 19, 2012 at 1:48 PM, amar takale  wrote:


>
> -- Forwarded message --
> From: amar takale 
> Date: Thu, Jul 19, 2012 at 1:47 PM
> Subject: Rank Formula
> To: excel-macros@googlegroups.com
>
>
>
>
>  --
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>



-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelvbaclinic.blogspot.com

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com




Rank(Solved).xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Company Name in front of Show its sector

[dguillett1]

Should work

Option Explicit
Sub groupsSAS()
Dim mr As Range
Dim b As Range
Dim sr As Long
Rows(2).Insert
Set mr = Cells(2, "b") _
.Resize(Cells(Rows.Count, "b").End(xlUp).Row)
For Each b In mr.SpecialCells(xlBlanks)
sr = b.Offset(-1).End(xlUp).Row
Cells(sr, "c") _
.Resize(b.Row - sr + 1).Value = Cells(sr, "b")
Next b
End Sub

Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com

From: amar takale 
Sent: Thursday, July 19, 2012 5:54 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Company Name in front of Show its sector


-- 
-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
 
 

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ HOW TO CREATE REPORTS IN EXCEL

[NOORAIN ANSARI]

Dear Mangesh,

To Create report in MS Excel you can use.

1. Pivot table
2. Subtotal
3. Consolidate




On Thu, Jul 19, 2012 at 3:25 PM, Mangesh Vimay wrote:

> Hi Friends,
>
> Please help me on "HOW TO CREATE REPORTS IN EXCEL" by providing suitable
> examples so that I could learn it.
> Thanks.
>
> --
> With regards,
>
> MaNgEsH
>
>  --
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>



-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelvbaclinic.blogspot.com

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl

[amar takale]

On Thu, Jul 19, 2012 at 5:35 PM, dguillett1  wrote:

>   Your file did NOT show any pass/fail or grades so how can we help?
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* amar takale 
> *Sent:* Thursday, July 19, 2012 12:47 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Need formula to take out total number of
> boy and girl
>
>  Dear all
> Can you please help me to find out Boys & girls Rank (Regarding Marks) If
> they failed then can not count their rank.Can I got this formula
> Thank you very much for the support you all have been providing.
>
> Amar
>
>
> On Wed, Jul 18, 2012 at 6:56 PM, dguillett1  wrote:
>
>>   See sumproduct formulas in attached.
>>
>> Don Guillett
>> Microsoft Excel Developer
>> SalesAid Software
>> dguille...@gmail.com
>>
>>  *From:* group birle 
>> *Sent:* Wednesday, July 18, 2012 7:47 AM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ Need formula to take out total number of
>> boy and girl
>>
>>  check this
>>
>>
>>
>>  On Thu, Jul 12, 2012 at 2:54 PM, सुनिता पौडेल wrote:
>>
>>>  Dear all,
>>>
>>> Can you please help me to find out the total number of boy and girl ? I
>>> used countif for their grade and it worked. However, for girl and boy
>>> seggregation it isnot working.
>>>
>>> Thank you very much for the support you all have been providing.
>>>
>>> sunita
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> mailto:excel-macros%2bunsubscr...@googlegroups.com
>>
>>
>> --
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> mailto:excel-macros%2bunsubscr...@googlegroups.com
>>
>>
>>  --
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> mailto:excel-macros%2bunsubscr...@googlegroups.com
>>
>>
>>
>
> --
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cro

Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl

[dguillett1]

Your file did NOT show any pass/fail or grades so how can we help?

Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com

From: amar takale 
Sent: Thursday, July 19, 2012 12:47 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Need formula to take out total number of boy and 
girl

Dear all
Can you please help me to find out Boys & girls Rank (Regarding Marks) If they 
failed then can not count their rank.Can I got this formula

Thank you very much for the support you all have been providing.

Amar



On Wed, Jul 18, 2012 at 6:56 PM, dguillett1  wrote:

  See sumproduct formulas in attached.

  Don Guillett
  Microsoft Excel Developer
  SalesAid Software
  dguille...@gmail.com

  From: group birle 
  Sent: Wednesday, July 18, 2012 7:47 AM
  To: excel-macros@googlegroups.com 
  Subject: Re: $$Excel-Macros$$ Need formula to take out total number of boy 
and girl

  check this




  On Thu, Jul 12, 2012 at 2:54 PM, सुनिता पौडेल  wrote:

Dear all,

Can you please help me to find out the total number of boy and girl ? I 
used countif for their grade and it worked. However, for girl and boy 
seggregation it isnot working.

Thank you very much for the support you all have been providing.

sunita
-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please 
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will 
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security 
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 

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

To unsubscribe, send a blank email to 
mailto:excel-macros%2bunsubscr...@googlegroups.com

  -- 
  -- 
  FORUM RULES (986+ members already BANNED for violation)
   
  1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
   
  2) Don't post a question in the thread of another member.
   
  3) Don't post questions regarding breaking or bypassing any security measure.
   
  4) Acknowledge the responses you receive, good or bad.
   
  5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
   
  NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
   
  
--
  To post to this group, send email to excel-macros@googlegroups.com
   
  To unsubscribe, send a blank email to 
mailto:excel-macros%2bunsubscr...@googlegroups.com
   
   

  -- 
  -- 
  FORUM RULES (986+ members already BANNED for violation)
   
  1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
   
  2) Don't post a question in the thread of another member.
   
  3) Don't post questions regarding breaking or bypassing any security measure.
   
  4) Acknowledge the responses you receive, good or bad.
   
  5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
   
  NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
   
  
--
  To post to this group, send email to excel-macros@googlegroups.com
   
  To unsubscribe, send a blank email to 
mailto:excel-macros%2bunsubscr...@googlegroups.com
   
   


-- 
-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsib

$$Excel-Macros$$ Re: Error Cleaning

[SG]

Hi Experts,
 
Please find attached sheet for cleaning. What i want is this after 
splitting , each error gets a unique row like i manually done in the third 
sheet.Problem is that the no. of columns can increase & "Code used by user" 
will always be in the end,so, macro will copy the complete row from "code 
used by user" to "Region" Column & then overwrite the splitted value in the 
"Code used by Coder" value & same would be deleted from splitted column. If 
u need more explanation, please refer document in the my first post for 
this problem.I'm looking forward to the help.
 
Thanks
 

On Tuesday, July 17, 2012 8:32:12 PM UTC+5:30, bpascal123 wrote:

> It's difficult to understand and help as you've posted different version 
> of your data, at first there you start with a certain number of columns and 
> then you end up with different column like :  Study Name Coder(SC) 1.Coder 
> /Qer name for scorecards 2.Type Of Errors Final for Scorecard
> I also try to understand Don's code but honestly it makes me more 
> confused. Try to post the exact thing that you want, that is the data as it 
> comes and the data as you exactly want it
>

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com




Book1.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ HOW TO CREATE REPORTS IN EXCEL

[Mangesh Vimay]

Hi Roshan,

You are right !!!
I have to provide some data to u in order to get the report. But I need
some sample reports based on any data so that by practicing them, I could
learn some thing like creating the reports and manipulating reports. Also,
tell me what types of reports we can develop in Excel? As I am new to this
world, Please help on above queries.


On Thu, Jul 19, 2012 at 3:54 PM, Roshan Mathew  wrote:

> Hi Mangesh,
>
> Can you list out the below:
> To create any report your should be having some data, can you share the
> data?
> What type of reports are looking for?
>
>
>
> On Thu, Jul 19, 2012 at 1:55 PM, Mangesh Vimay wrote:
>
>> Hi Friends,
>>
>> Please help me on "HOW TO CREATE REPORTS IN EXCEL" by providing suitable
>> examples so that I could learn it.
>> Thanks.
>>
>> --
>> With regards,
>>
>> MaNgEsH
>>
>>  --
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>
>
>
> --
> Regards,
> Roshan Mathew
>
>


-- 
With regards,

MaNgEsH

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ WHEN STATUS GETS CHANGED - SHOULD GET AN E-MAIL TO MY ID

[Jayaprakash S]

Dear Experts,

Greetings...

I need your help & advise as per the attached example sheet.

Many Thanks.

JP

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com




WHEN STATUS GETS CHANGED - SHOULD GET AN E-MAIL TO MY ID.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Company Name in front of Show its sector

[amar takale]

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com




Sample file.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ HOW TO CREATE REPORTS IN EXCEL

[Mangesh Vimay]

Hi Friends,

Please help me on "HOW TO CREATE REPORTS IN EXCEL" by providing suitable
examples so that I could learn it.
Thanks.

-- 
With regards,

MaNgEsH

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ regarding ratio

[सुनिता पौडेल]

it shows 1:0

thnx

On Thu, Jul 19, 2012 at 2:57 PM, NOORAIN ANSARI wrote:

> Please try it..
>
> Hope it will help to you.
> =(LEFT(TEXT(A1/B1,"/"),FIND("/",TEXT(A1/B1,"/"))-1)&":"
> &RIGHT(TEXT(A1/B1,"/"),LEN(TEXT(A1/B1,"/"))
> -FIND("/",TEXT(A1/B1,"/"
>
>
> On Thu, Jul 19, 2012 at 2:07 PM, सुनिता पौडेल  wrote:
>
>> not working .is it because add-ins blah..
>> thnx
>>
>> On Thu, Jul 19, 2012 at 1:58 PM, Krishnaraddi V. Madolli <
>> krishnaraddi.mado...@asia.xchanging.com> wrote:
>>
>>>
>>> http://spreadsheetpage.com/index.php/tip/a_formula_to_calculate_a_ratio/
>>> 
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> Regards,
>>>
>>> ** **
>>>
>>> Krishnaraddi V Madolli.
>>>
>>> Data Analytics Team
>>>
>>> Sedgwick Claims Management Services, Inc.
>>> Xchanging Towers, SJR iPark, 
>>>
>>> EPIP Area, Whitefield 
>>>
>>> Bangalore - 560 066. India.
>>>
>>> Direct Line: +1.800.920.9657 Extn 1915
>>>
>>> Switchboard: +90-(0)80-3054 Extn 1915
>>>
>>> Email: krishnaraddi.mado...@asia.xchanging.com 
>>>
>>> krishnaraddi.mado...@sedgwickcms.com
>>>
>>> www.sedgwickcms.com|
>>> *The leader in innovative claims and productivity management solutions*
>>>
>>> ** **
>>>
>>> Success is never permanent, Failure is never final, so always do not
>>> stop effort until your victory makes a history.
>>>
>>> *[image:
>>> http://images.coolchaser.com/themes/t/404137-i311.photobucket.com-albums-kk467-volleycutiegirl-icon.png]
>>> **Please consider the environment before printing this message***
>>>
>>> ** **
>>>
>>> *From:* excel-macros@googlegroups.com [mailto:
>>> excel-macros@googlegroups.com] *On Behalf Of *?? ?
>>> *Sent:* Thursday, July 19, 2012 1:35 PM
>>> *To:* excel-macros@googlegroups.com
>>> *Subject:* $$Excel-Macros$$ regarding ratio
>>>
>>> ** **
>>>
>>> Dear all,
>>>
>>>  
>>>
>>> Please do me one favor. I tried to find out the ratio between two
>>> numbers but seems the formula isn't working. So can you please help me.*
>>> ***
>>>
>>>  
>>>
>>> Thank you
>>>
>>>  
>>>
>>> Sunita
>>>
>>> --
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>>
>>>  
>>>
>>> "CONFIDENTIALITY NOTICE: This message and any attachment are
>>> confidential and may also be privileged. If you are not the intended
>>> recipient of this e-mail you may not copy, forward, disclose or otherwise
>>> use it or any part of it in any form whatsoever. If you are not the
>>> intended recipient please telephone or e-mail the sender and delete this
>>> message and any attachment from your system."
>>>
>>> --
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>>
>>>
>>>
>>
>>  --
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or

Re: $$Excel-Macros$$ regarding ratio

[NOORAIN ANSARI]

Please try it..

Hope it will help to you.
=(LEFT(TEXT(A1/B1,"/"),FIND("/",TEXT(A1/B1,"/"))-1)&":"
&RIGHT(TEXT(A1/B1,"/"),LEN(TEXT(A1/B1,"/"))
-FIND("/",TEXT(A1/B1,"/"

On Thu, Jul 19, 2012 at 2:07 PM, सुनिता पौडेल  wrote:

> not working .is it because add-ins blah..
> thnx
>
> On Thu, Jul 19, 2012 at 1:58 PM, Krishnaraddi V. Madolli <
> krishnaraddi.mado...@asia.xchanging.com> wrote:
>
>>  http://spreadsheetpage.com/index.php/tip/a_formula_to_calculate_a_ratio/
>> 
>>
>> ** **
>>
>> ** **
>>
>> Regards,
>>
>> ** **
>>
>> Krishnaraddi V Madolli.
>>
>> Data Analytics Team
>>
>> Sedgwick Claims Management Services, Inc.
>> Xchanging Towers, SJR iPark, 
>>
>> EPIP Area, Whitefield 
>>
>> Bangalore - 560 066. India.
>>
>> Direct Line: +1.800.920.9657 Extn 1915
>>
>> Switchboard: +90-(0)80-3054 Extn 1915
>>
>> Email: krishnaraddi.mado...@asia.xchanging.com 
>>
>> krishnaraddi.mado...@sedgwickcms.com
>>
>> www.sedgwickcms.com|
>> *The leader in innovative claims and productivity management solutions*
>>
>> ** **
>>
>> Success is never permanent, Failure is never final, so always do not stop
>> effort until your victory makes a history.
>>
>> *[image:
>> http://images.coolchaser.com/themes/t/404137-i311.photobucket.com-albums-kk467-volleycutiegirl-icon.png]
>> **Please consider the environment before printing this message***
>>
>> ** **
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *?? ?
>> *Sent:* Thursday, July 19, 2012 1:35 PM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ regarding ratio
>>
>> ** **
>>
>> Dear all,
>>
>>  
>>
>> Please do me one favor. I tried to find out the ratio between two numbers
>> but seems the formula isn't working. So can you please help me.
>>
>>  
>>
>> Thank you
>>
>>  
>>
>> Sunita
>>
>> --
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>>  
>>
>> "CONFIDENTIALITY NOTICE: This message and any attachment are confidential
>> and may also be privileged. If you are not the intended recipient of this
>> e-mail you may not copy, forward, disclose or otherwise use it or any part
>> of it in any form whatsoever. If you are not the intended recipient please
>> telephone or e-mail the sender and delete this message and any attachment
>> from your system."
>>
>> --
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>
>  --
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion

Re: $$Excel-Macros$$ Insert the complete sentence by typing in the wildcard(*) and first few characters of the sentence

[Wireless CellularGuy]

Hi Noorain,

Please find the sample. Very Items are mentioned in the sample. Actually,
there are thousands of items and corresponding comments are available.

Regards,
Wireless

On Thu, Jul 19, 2012 at 2:24 PM, NOORAIN ANSARI wrote:

> Dear Wireless,
>
> Please share a sample workbook.
>
>
> On Thu, Jul 19, 2012 at 1:39 PM, wirelesscellularguy <
> wirelesscellular...@gmail.com> wrote:
>
>> Hi All,
>>
>> I have a predefined sentences to be filled in various cells and under
>> specific conditions.
>>
>> I am checking the entries in column A and based on that I am filling the
>> Column B cells with predefined sentences. As there are many different
>> predefined sentences, I was wondering can it be done by entering the * with
>> the first few characters of the sentence.
>>
>> Please help in this regard.
>>
>> Regards,
>> Wireless
>>
>> --
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelvbaclinic.blogspot.com
>
>
>
>
>  --
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com




Sample.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Insert the complete sentence by typing in the wildcard(*) and first few characters of the sentence

[NOORAIN ANSARI]

Dear Wireless,

Please share a sample workbook.

On Thu, Jul 19, 2012 at 1:39 PM, wirelesscellularguy <
wirelesscellular...@gmail.com> wrote:

> Hi All,
>
> I have a predefined sentences to be filled in various cells and under
> specific conditions.
>
> I am checking the entries in column A and based on that I am filling the
> Column B cells with predefined sentences. As there are many different
> predefined sentences, I was wondering can it be done by entering the * with
> the first few characters of the sentence.
>
> Please help in this regard.
>
> Regards,
> Wireless
>
> --
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>



-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelvbaclinic.blogspot.com

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ regarding ratio

[सुनिता पौडेल]

not working .is it because add-ins blah..
thnx

On Thu, Jul 19, 2012 at 1:58 PM, Krishnaraddi V. Madolli <
krishnaraddi.mado...@asia.xchanging.com> wrote:

>  http://spreadsheetpage.com/index.php/tip/a_formula_to_calculate_a_ratio/*
> ***
>
> ** **
>
> ** **
>
> Regards,
>
> ** **
>
> Krishnaraddi V Madolli.
>
> Data Analytics Team
>
> Sedgwick Claims Management Services, Inc.
> Xchanging Towers, SJR iPark, 
>
> EPIP Area, Whitefield 
>
> Bangalore - 560 066. India.
>
> Direct Line: +1.800.920.9657 Extn 1915
>
> Switchboard: +90-(0)80-3054 Extn 1915
>
> Email: krishnaraddi.mado...@asia.xchanging.com 
>
> krishnaraddi.mado...@sedgwickcms.com
>
> www.sedgwickcms.com|
> *The leader in innovative claims and productivity management solutions*
>
> ** **
>
> Success is never permanent, Failure is never final, so always do not stop
> effort until your victory makes a history.
>
> *[image:
> http://images.coolchaser.com/themes/t/404137-i311.photobucket.com-albums-kk467-volleycutiegirl-icon.png]
> **Please consider the environment before printing this message***
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *?? ?
> *Sent:* Thursday, July 19, 2012 1:35 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ regarding ratio
>
> ** **
>
> Dear all,
>
>  
>
> Please do me one favor. I tried to find out the ratio between two numbers
> but seems the formula isn't working. So can you please help me.
>
>  
>
> Thank you
>
>  
>
> Sunita
>
> --
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>  
>
> "CONFIDENTIALITY NOTICE: This message and any attachment are confidential
> and may also be privileged. If you are not the intended recipient of this
> e-mail you may not copy, forward, disclose or otherwise use it or any part
> of it in any form whatsoever. If you are not the intended recipient please
> telephone or e-mail the sender and delete this message and any attachment
> from your system."
>
> --
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

To unsubscribe, send a blank email to excel-macros+

$$Excel-Macros$$ Fwd: Rank Formula

[amar takale]

-- Forwarded message --
From: amar takale 
Date: Thu, Jul 19, 2012 at 1:47 PM
Subject: Rank Formula
To: noorain.ans...@gmail.com

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com




Rank.xls
Description: MS-Excel spreadsheet

RE: $$Excel-Macros$$ regarding ratio

[Krishnaraddi V. Madolli]

http://spreadsheetpage.com/index.php/tip/a_formula_to_calculate_a_ratio/


Regards,

Krishnaraddi V Madolli.
Data Analytics Team
Sedgwick Claims Management Services, Inc.
Xchanging Towers, SJR iPark,
EPIP Area, Whitefield
Bangalore - 560 066. India.
Direct Line: +1.800.920.9657 Extn 1915
Switchboard: +90-(0)80-3054 Extn 1915
Email: 
krishnaraddi.mado...@asia.xchanging.com
krishnaraddi.mado...@sedgwickcms.com
www.sedgwickcms.com
 |  The leader in innovative claims and productivity management solutions

Success is never permanent, Failure is never final, so always do not stop 
effort until your victory makes a history.
[http://images.coolchaser.com/themes/t/404137-i311.photobucket.com-albums-kk467-volleycutiegirl-icon.png]Please
 consider the environment before printing this message

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of ?? ?
Sent: Thursday, July 19, 2012 1:35 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ regarding ratio

Dear all,

Please do me one favor. I tried to find out the ratio between two numbers but 
seems the formula isn't working. So can you please help me.

Thank you

Sunita
--
--
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited.

NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

To unsubscribe, send a blank email to 
excel-macros+unsubscr...@googlegroups.com


"CONFIDENTIALITY NOTICE: This message and any attachment are confidential and 
may also be privileged. If you are not the intended recipient of this e-mail 
you may not copy, forward, disclose or otherwise use it or any part of it in 
any form whatsoever. If you are not the intended recipient please telephone or 
e-mail the sender and delete this message and any attachment from your system."

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com


<>

Re: $$Excel-Macros$$ regarding ratio

[NOORAIN ANSARI]

Hi Sunita

Please try it
=E7/GCD(E7,F7) &":" & F7/GCD(E7,F7)

On Thu, Jul 19, 2012 at 1:34 PM, सुनिता पौडेल  wrote:

> Dear all,
>
> Please do me one favor. I tried to find out the ratio between two numbers
> but seems the formula isn't working. So can you please help me.
>
> Thank you
>
> Sunita
>
> --
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>



-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelvbaclinic.blogspot.com

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ Insert the complete sentence by typing in the wildcard(*) and first few characters of the sentence

[wirelesscellularguy]

Hi All,

I have a predefined sentences to be filled in various cells and under 
specific conditions.

I am checking the entries in column A and based on that I am filling the 
Column B cells with predefined sentences. As there are many different 
predefined sentences, I was wondering can it be done by entering the * with 
the first few characters of the sentence.

Please help in this regard.

Regards,
Wireless

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ regarding ratio

[सुनिता पौडेल]

Dear all,

Please do me one favor. I tried to find out the ratio between two numbers
but seems the formula isn't working. So can you please help me.

Thank you

Sunita

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com




ratio.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Please provide me Excel 2003 & 2007 Short Key

[Manoj Kumar]

Thanks dear..€.

On Thu, Jul 19, 2012 at 12:50 AM, NOORAIN ANSARI
wrote:

> Dear Manoj,
>
> Please find attached short cut for excel 2003,2007 and 2010.
>
>
> On Thu, Jul 19, 2012 at 1:18 PM, Manoj Kumar 
> wrote:
>
>> Hi.
>>
>> Please provide me Excel 2003 & 2007 Short Key
>>
>> Regard
>> Manoj
>>
>> --
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelvbaclinic.blogspot.com
>
>
>
>
>  --
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ Please provide me Excel 2003 & 2007 Short Key

[Manoj Kumar]

Hi.

Please provide me Excel 2003 & 2007 Short Key

Regard
Manoj

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Time Calculation in TAT Report : If greater than 5 hours

[NOORAIN ANSARI]

Dear Sunder,

Please use..

*=IF(A3=TIMEVALUE("10:00:00 AM"),"Meet the TAT",IF(A3=TIMEVALUE("03:00:00
PM"),"Not Meet the TAT",""))*

On Thu, Jul 19, 2012 at 1:02 PM, Sundarvelan N  wrote:

> Hi Friends,
>
> Please help me in calculating the TAT
>
> If my registration is 9 A.M
>
> and the despatch time is 10 A.M - Met the TAT
> IF the despatch time is 3 P.M - Not Me the TAT
> Thanks
> N.Sundarvelan
> 9600160150
>
>  --
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>



-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelvbaclinic.blogspot.com

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Time Calculation in TAT Report : If greater than 5 hours

[Amresh Maurya]

   Hi ,

Kindly use below formula.

despatch Time




Acutal despatch Time


TAT Status


Formula  7/18/12 9:00 AM 7/18/12 10:00 AM TAT Meet =IF(TEXT(C2,"hh")="10","TAT
Meet","TAT not Meet")  7/18/12 9:00 PM 7/18/12 3:00 PM TAT not Meet
=IF(TEXT(C3,"hh")="10","TAT
Meet","TAT not Meet")
Regards
Amresh

On Thu, Jul 19, 2012 at 1:02 PM, Sundarvelan N  wrote:
> Hi Friends,
>
> Please help me in calculating the TAT
>
> If my registration is 9 A.M
>
> and the despatch time is 10 A.M - Met the TAT
> IF the despatch time is 3 P.M - Not Me the TAT
> Thanks
> N.Sundarvelan
> 9600160150
>
> --
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will
> not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
--
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ How to learn/understand INDEX, INDIRECT, FIND, MATCH, OFFSET functions?

[Indrajit $nai]

Thanks a lot @ Noorain. :)

On Wed, Jul 18, 2012 at 9:32 PM, NOORAIN ANSARI wrote:

>
>
> On Wed, Jul 18, 2012 at 3:09 AM, Indrajit $nai wrote:
>
>> Hi All,
>>
>> Tell me some easiest way to learn/understand INDEX, INDIRECT, FIND,
>> MATCH, OFFSET functions.
>>
>> Thanks in advance.
>>
>> --
>> Indrajit
>>
>> Disclaimer:
>> This electronic message and any files transmitted with it are
>> confidential and intended solely for the use of the individual or entity to
>> whom they are addressed. If you are not the intended recipient you are
>> hereby notified that any disclosure, copying, distribution or taking any
>> action in reliance on the contents of this information is strictly
>> prohibited and may be unlawful.
>>
>> --
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelvbaclinic.blogspot.com
>
>
>
>
>  --
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ Time Calculation in TAT Report : If greater than 5 hours

[Sundarvelan N]

Hi Friends,

Please help me in calculating the TAT

If my registration is 9 A.M

and the despatch time is 10 A.M - Met the TAT
IF the despatch time is 3 P.M - Not Me the TAT
Thanks
N.Sundarvelan
9600160150

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com