Re: $$Excel-Macros$$ Hightlight the text for day Fridays only.....

[NOORAIN ANSARI]

Dear Muneer,

You can also use below formula in conditonal formating.
=WEEKDAY($A11)=6

On Wed, Aug 15, 2012 at 7:46 PM, ashish koul  wrote:

> use this formula  in conditional format
>
> =AND(TEXT($A2,"ddd")="Fri")
>
>
> On Wed, Aug 15, 2012 at 12:09 PM, vijayajith VA 
> wrote:
>
>> use ths below code...
>>
>> .
>>
>> Sub highlight_friday()
>> Dim rng As Range
>> Dim cell As Range
>> Dim sh As Worksheet
>> Set rng = Sheet1.Range("A2:A" & Sheet1.Range("A" &
>> Rows.Count).End(xlUp).Row)
>> For Each cell In rng
>> If VBA.Weekday(cell) = 6 Then
>> cell.Offset(0, 1).Interior.Color = vbCyan
>> End If
>> Next cell
>> End Sub
>>
>>
>>
>>
>> On Wed, Aug 15, 2012 at 12:07 PM, vijayajith VA 
>> wrote:
>>
>>> HI Muneer,,,
>>>
>>> I think Few days back noorain & rajan had answered for same questions
>>>
>>>
>>> On Wed, Aug 15, 2012 at 11:28 AM, Mohammed Muneer wrote:
>>>
 **
 Dear Group,

 Please highlight the text in column B based on Friday.


 Regards,
 Muneer,
 CC

 --
 Join official facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES (1120+ 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.

 6) Jobs posting is not allowed.

 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups "MS EXCEL AND VBA MACROS" group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.



>>>
>>>
>>  --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ 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.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
>
>
> *Visit*
> *http://www.excelvbamacros.com/*
> *http://www.accessvbamacros.com/*
>
> P Before printing, think about the environment.
>
>
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
With Regards,
Noorain Ansari
http:// 

Re: $$Excel-Macros$$ MOST REPEATED NO

[Kuldeep Singh]

You can try this.

=COUNTIF(B3:B21,B3)>1

Regards,
Kuldeep Singh
Phone.: +91-120-4763789, Extn.: 789
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*

On Fri, Aug 17, 2012 at 12:00 PM, Amit Gandhi  wrote:

> Hi Experts
>
> If there is any formula which can calculate MOST REPEATED NO from a list?
> Sample file attached.
>
> Pls help me here.
>
> Regards
>
> Amit
>
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Cell show blank but in it show formula

[NOORAIN ANSARI]

Dear Amar,

Please try it.

*=IF(ISERR(INDEX(INDIRECT($D$2),C4)),"",INDEX(INDIRECT($D$2),C4))*

see attached sheet.

On Thu, Aug 16, 2012 at 5:18 PM, amar takale  wrote:

> Thanks to all very much.One question ask to all there are custom
> formatting then error will disappear in cell?Is it right? I used index
> formula in my sheet but it show reference.
> I attached sheet here Pl see all.
>
> On Thu, Aug 16, 2012 at 4:17 PM, Kuldeep Singh wrote:
>
>>
>> You're Great Noorain Sir.
>>
>> Regards,
>> Kuldeep Singh
>> Phone.: +91-120-4763789, Extn.: 789
>> naukrikuld...@gmail.com || www.naukri.com
>> *Please* *Consider the environment. Please don't print this e-mail
>> unless you really need to.*
>>
>> On Thu, Aug 16, 2012 at 4:12 PM, NOORAIN ANSARI > > wrote:
>>
>>> Dear Amar,
>>>
>>> In case of 2003 Version
>>> You can also use..
>>>
>>> =IF(ISERROR(VLOOKUP(F5,$B$4:$D$9,3,0)),"",VLOOKUP(F5,$B$4:$D$9,3,0))
>>> Or
>>>
>>> =IF(ISNA(VLOOKUP(F5,$B$4:$D$9,3,0)),"",VLOOKUP(F5,$B$4:$D$9,3,0))
>>>
>>>
>>>
>>> On Thu, Aug 16, 2012 at 3:39 PM, amar takale wrote:
>>>

  --
 Join official facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES (1120+ 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.

 6) Jobs posting is not allowed.

 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups "MS EXCEL AND VBA MACROS" group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.



>>>
>>>
>>>
>>> --
>>> With Regards,
>>> Noorain Ansari
>>> http:// 
>>> noorainansari.com
>>> http:// 
>>> excelvbaclinic.com
>>>
>>>
>>>  --
>>> Join official facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES (1120+ 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.
>>>
>>> 6) Jobs posting is not allowed.
>>>
>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>>
>>  --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ 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.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MA

$$Excel-Macros$$ MOST REPEATED NO

[Amit Gandhi]

Hi Experts

If there is any formula which can calculate MOST REPEATED NO from a list?
Sample file attached.

Pls help me here.

Regards

Amit

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.




FIND MOST REPEATED NO.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ UDF - to sum range

[NOORAIN ANSARI]

Dear Amol,

Please Try it.*


Function Udf_sum(rng As Excel.Range)
Dim cell As Range
For Each cell In rng
If VBA.IsNumeric(cell) And cell.Value <> "" Then
Udf_sum = Udf_sum + cell
End If
Next cell
End Function
*

On Fri, Aug 17, 2012 at 11:32 AM, Amol J  wrote:

> Hi experts, I need your help, I tried myself but unfortunatly its not
> working.
> I need UDF to sum  range.
> 1) first my range will be B4:E4 and
>   I am going to drag udf into columns to next range will be  C5:E5,
>  Means when I will drag my udf function it will increase in range by
> 1column and 1 row
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
With Regards,
Noorain Ansari
http:// 
noorainansari.com
http:// 
excelvbaclinic.com

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ UDF - to sum range

[Amol J]

Hi experts, I need your help, I tried myself but unfortunatly its not 
working.
I need UDF to sum  range.
1) first my range will be B4:E4 and
  I am going to drag udf into columns to next range will be  C5:E5,
 Means when I will drag my udf function it will increase in range by 
1column and 1 row

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.




rngQuestion.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ UDF to sum range

[Amol J]

 Hi experts, I need your help, I tried myself but unfortunatly its not 
working.
I need UDF to sum  range.
1) first my range will be B4:E4 and
  I am going to drag udf into columns to next range will be  C5:E5,
 Means when I will drag my udf function it will increase in range by 
1column and 1 row
 
PFA  for more details.
 

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.




rngQuestion.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Embed video in excel

[P.VIJAYKUMAR]

Hi Hillary,


The main mistake you are doing is trying to play video from the site.First
save the required video or game to your PC. Then try embedding the videos
in Excel 97-2003 as explained earlier and it definitely works. I have
embedded many videos in excel.


Regards,
P.VIJAY KUMAR

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

RE: $$Excel-Macros$$ Re: Cell show blank but in it show formula

[Rajan_Verma]

If using Excel 2007 and later can use this :

 

=IFERROR(VLOOKUP(F5,$B$4:$D$9,3,0),"")

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prince Dubey
Sent: 16 August 2012 10:53
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Cell show blank but in it show formula

 

Please see the attachment

 

 

regards

prince 

On Thursday, August 16, 2012 3:39:08 PM UTC+5:30, amar takale wrote:

 

-- 
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ 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. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
 
 

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

RE: $$Excel-Macros$$ Re: Tips for working on huge data in excel 2007

[Rajan_Verma]

 

1).Use Minimum Formatting

2). Save file in .xlsb

3). Set calculation Manual  (Calculate formula whenever required)

4). Use name Ranges

 

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prince Dubey
Sent: 16 August 2012 10:48
To: excel-macros@googlegroups.com
Cc: amit.de...@merucabs.com; amit.de...@merucabs.com
Subject: $$Excel-Macros$$ Re: Tips for working on huge data in excel 2007

 

Hi Amit, 

 

I thinks if your data is too large then please try it operate by using
Arrays and dictionary objects In VBA.

 

regards

prince 

On Wednesday, August 15, 2012 7:18:41 PM UTC+5:30, Amit Desai (MERU) wrote:

Dear Friends,

 

I need to work on huge data in excel 2007. Whenever I use any formula it
generally slows down & keeps on calculating on every move.

 

Please provide me tips/suggestion for improving performance.

 

Best Regards,

Amit

 

 

  _  

Disclaimer: This message and its attachments contain confidential
information and may also contain legally privileged information. This
message is intended solely for the named addressee. If you are not the
addressee indicated in this message (or authorized to receive for
addressee), you may not copy or deliver any part of this message or its
attachments to anyone or use any part of this message or its attachments.
Rather, you should permanently delete this message and its attachments (and
all copies) from your system and kindly notify the sender by reply e-mail.
Any content of this message and its attachments that does not relate to the
official business of Meru Cab Company Pvt. Ltd. must be taken not to have
been sent or endorsed by any of them. Email communications are not private
and no warranty is made that e-mail communications are timely, secure or
free from computer virus or other defect.

-- 
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ 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. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
 
 

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ Re: Cell show blank but in it show formula

[Prince Dubey]

Please see the attachment


regards
prince 

On Thursday, August 16, 2012 3:39:08 PM UTC+5:30, amar takale wrote:
>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.




cell blank with hide formula.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Re: Tips for working on huge data in excel 2007

[Prince Dubey]

Hi Amit, 

I thinks if your data is too large then please try it operate by using 
Arrays and dictionary objects In VBA.

regards
prince 

On Wednesday, August 15, 2012 7:18:41 PM UTC+5:30, Amit Desai (MERU) wrote:
>
>  Dear Friends,
>
>  
>
> I need to work on huge data in excel 2007. Whenever I use any formula it 
> generally slows down & keeps on calculating on every move.
>
>  
>
> Please provide me tips/suggestion for improving performance.
>
>  
>
> Best Regards,
>
> Amit
>
>  
>  
> --
> Disclaimer: This message and its attachments contain confidential 
> information and may also contain legally privileged information. This 
> message is intended solely for the named addressee. If you are not the 
> addressee indicated in this message (or authorized to receive for 
> addressee), you may not copy or deliver any part of this message or its 
> attachments to anyone or use any part of this message or its attachments. 
> Rather, you should permanently delete this message and its attachments (and 
> all copies) from your system and kindly notify the sender by reply e-mail. 
> Any content of this message and its attachments that does not relate to the 
> official business of Meru Cab Company Pvt. Ltd. must be taken not to have 
> been sent or endorsed by any of them. Email communications are not private 
> and no warranty is made that e-mail communications are timely, secure or 
> free from computer virus or other defect.
>  

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ Re: Embed Video in excel

[Prince Dubey]

Hi Hilary,

i please try following step hop it will work for you.

1. Save ur work book in 2003-97 format
2.Go to developer tab->In ActiveX Control select last icon (right bottom 
most(more control))->Add window media player->drop it on sheet
3.Click on design mode
4. Select the property of window media player
5.specify URL in URL property of ur video

this worked for me.


Regards
prince 


On Thursday, August 16, 2012 8:39:19 PM UTC+5:30, hilary lomotey wrote:
>
> Hello Guys,
>
> kindly help out, am trying to embed a youtube video in excel but when i go 
> thru the process the video does not download, i have also installed the 
> below flash player and shockwave player but its wont load, pls see attached.
>
> i went to developer tab 
> selected more controls
> selected shockwave 
> had a plus sign and dragged it across
> right clicked got to properties
> went to youtube and copied the address and placed it in the movie 
> properties
> after exit in the design mode but 
> movie wont load
>  
>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ 4 Hot Positions(Unix Admin,J boss Consultant,IT Infra Architect,Solution Archite

[Ayush Jain]

Karan Bhatia is banned.
 
-Ayush Jain

On Thursday, 16 August 2012 01:17:31 UTC+5:30, finu wrote:

>  Please ban this user
>
>  
>  
> *From:* excel-...@googlegroups.com  [mailto:
> excel-...@googlegroups.com ] *On Behalf Of *Ashish Pradhan
> *Sent:* 15 August 2012 20:24
> *To:* excel-...@googlegroups.com 
> *Subject:* Re: $$Excel-Macros$$ 4 Hot Positions(Unix Admin,J boss 
> Consultant,IT Infra Architect,Solution Archite
>
>  
>  
>
> Dear Ayush
>
> Please ban this gentleman. 
>
> Thanks
>
>  
>
> Ashish Pradhan
>
> On 15-08-2012 21:50, Karan Bhatia wrote:
>
>  
> Please respond to   ka...@hmgamerica.com   
>   
> *Position: *Unix Administrator*
> Location: *Houston, TX*
> Duration: *6 months extendable contract*
> Job Description / Responsibility*
>
> Should have around 6-8 years of UNIX/LINUX experience with 6+ years of 
> demonstrated experience and proficiency in managing and maintaining UNIX 
> environment, will be responsible for Installing, configuring and 
> maintaining Sun (Solaris10) /Linux (Red Hat). 
>
> Installation, configuration and managing HA environment using 
> VERITAS/REDHAT clustering, Volume manager and Sun logical volume manager.
>
> -   Storage disk management.
>
> -   Creating/resizing file systems/volumes under Sun/VERITAS volume 
> manager.
>
> -   Installing/Maintaining Solaris Jumpstart and Kick start 
> environment.
>
> -   Updating OS patches using Satellite server.
>
> -   Patch and Package administration.
>
> -   Printer Administration.
>
> -   Writing shell scripts to accomplish day to day system 
> administration task.
>
> -   Configuring and supporting domain on Sun systems.
>
> -   Troubleshooting Hardware and Operating system related issue.
>
> -   Capacity planning and fine tune system for optimal performance.
>
> -   Understanding of SAN and NAS storage.
>
> -   Installation, configuration of NetBackup client.
>
> -   Administration of NIS or LDAP environment.
>
> -   Configuring UNIX Security baseline.
>
> -   Troubleshooting Hardware and Operating system related issues.
>
> -   Experience in System Fault Tolerance Design, Business continuity 
> and Disaster recovery.
>
> -NIS administration
>
> -Zones administration
>
> Experience on following will be added advantage
>
> -Samba
>
> -PGP
>
> -DNS
>
> -Sendmail
>
> -LDAP
>
> -Monitoring Tools (like BMC Patrol, HP open view, IBM Tivoli)
>
> -ITIL awareness
>
>
> ‘’’’
>
> *Position:  JBoss consultant
> Location: Cary, NC
> Duration: 6 months extendable contract
>
> *
>
> *Job Description:*
>
> JBoss installation, configuration and maintenance with Ver.5.x
> Apache installation, configuration and maintenance with Ver.2.x
> Tomcat installation, configuration and maintenance with Ver.6.x
> Knowledge on SVN repository
> Knowledge on RHE Linux and troubleshooting issues on Linux
> Knowledge on troubleshooting JBoss, Apache and Tomcat with Primary 
> Database as Oracle.
>
>
> ‘’
>
> *Position:  IT Infra Architect
> Location: Wilmington, DE
> Duration: 6 months contract*
>
> *Job Description*
>
> The candidates should have architecture experience in the following 
> foundation technologies. 
>
> Strong knowledge in underlying technologies such as 
>
> Good understanding of Storage /Backup Architecture and Design – Expert 
> level
>
> Storage: HP, Hitachi, NetApp – Expert level
>
> Storage understanding of Data Archival technologies
>
> Fabric – Brocade/Cisco – Expert Level
>
> Backup: HP-DP, De-duplication,  Disk based Backup  – Expert level
>
> Good understand of application level backups
>
> Virtualization :VMware – Knowledge 
>
> O/S: Solaris, AIX, HP-UX (One of the OS flavors) - Knowledge
>
> Fundamentals of Networking: (Routing/Switching/Converged Networking/WAN 
> Optimization)
>
> Awareness about well know applications – Exchange, Database, Web services, 
> Middleware
>
> Understand the technical scope of the project and document the requirement 
> by creating or validating the SOW.
>
> Ability to take the both functional and non-functional requirements from 
> the respective teams to freeze the SOW.
>
> Review the SOW ensuring the scope and the prerequisite is complete by 
> validating the dependencies on other projects, IT infrastructure resources 
> required, cross technologies needs are met.
>
> The architect should ensure that the proposed design is aligned with 
> industry best practices and the solution is well optimized.
>
> Create, Review and validate the design by engaging with the respective 

Re: $$Excel-Macros$$ Finacial Excel Work Books

[Hilary Lomotey]

Hi RK,

i dont think there is such a thing, however I believe for such stuff you
have to build a model from scratch. if one knows exactly how these
processes run, then it can be built

On Thu, Aug 16, 2012 at 3:58 PM, RK  wrote:

> **
> Hi Vijay,
>
> Thx. I had seen the website before writing in our group, however did not
> find anything that could help me with my day to day financial accounting
> (journal entries, ledgers, trial balances, P&L & Balance sheet.
>
> Rgds,
> Roopesh Kapur
> E:roopesh.ka...@gmail.com
> --
> *From: * "P.VIJAYKUMAR" 
> *Sender: * excel-macros@googlegroups.com
> *Date: *Thu, 16 Aug 2012 21:09:36 +0530
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *$$Excel-Macros$$ Finacial Excel Work Books
>
> Hi, Roopesh,
>
> For Financial excel sheets you can visit www.exinfm.com which has about
> 100 free excel sheets catering fianancial topics.
>
>
> Regards,
> P.VIJAY KUMAR
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Embed Video in excel

[yogananda muthaiah]

Hi ,

do you want to download videos from youtube by html or via excel

On Thu, Aug 16, 2012 at 8:39 PM, Hilary Lomotey  wrote:

> Hello Guys,
>
> kindly help out, am trying to embed a youtube video in excel but when i go
> thru the process the video does not download, i have also installed the
> below flash player and shockwave player but its wont load, pls see attached.
>
> i went to developer tab
> selected more controls
> selected shockwave
> had a plus sign and dragged it across
> right clicked got to properties
> went to youtube and copied the address and placed it in the movie
> properties
> after exit in the design mode but
> movie wont load
>
>
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 



Regards
Yogananda Muthaiah
Ph : 973 123 7267

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Finacial Excel Work Books

[RK]

Hi Vijay,

Thx. I had seen the website before writing in our group, however did not find 
anything that could help me with my day to day financial accounting (journal 
entries, ledgers, trial balances, P&L & Balance sheet.


Rgds,
Roopesh Kapur
E:roopesh.ka...@gmail.com

-Original Message-
From: "P.VIJAYKUMAR" 
Sender: excel-macros@googlegroups.com
Date: Thu, 16 Aug 2012 21:09:36 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Finacial Excel Work Books

Hi, Roopesh,

For Financial excel sheets you can visit www.exinfm.com which has about 100
free excel sheets catering fianancial topics.


Regards,
P.VIJAY KUMAR

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.



-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ Finacial Excel Work Books

[P.VIJAYKUMAR]

Hi, Roopesh,

For Financial excel sheets you can visit www.exinfm.com which has about 100
free excel sheets catering fianancial topics.


Regards,
P.VIJAY KUMAR

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ Embed Video in Excel

[P.VIJAYKUMAR]

Hello Hilary,

To Get the video Loaded in in Excel 2007. First Save the file in Excel
97-2003 Version. Then in the properties of the embedded video you will get
a custom tab in which you specify the URL or the path of the video.Then
exit the design mode.Now you will have your video playing in Excel. Enjoy.


Regards,
VIJAY KUMAR

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ Embed Video in excel

[Hilary Lomotey]

Hello Guys,

kindly help out, am trying to embed a youtube video in excel but when i go
thru the process the video does not download, i have also installed the
below flash player and shockwave player but its wont load, pls see attached.

i went to developer tab
selected more controls
selected shockwave
had a plus sign and dragged it across
right clicked got to properties
went to youtube and copied the address and placed it in the movie properties
after exit in the design mode but
movie wont load

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.




Embeded Video in excel.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

RE: $$Excel-Macros$$ Tips for working on huge data in excel 2007

[Amit Desai (MERU)]

Thanks for all your help dear friends..

Best Regards,
Amit

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of NOORAIN ANSARI
Sent: 16 August 2012 17:33
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Tips for working on huge data in excel 2007

You can do the following to speed up your workbook.


1). Save your file in .xlsb (Binary Format) to reduce size.
2).Remove unnecessary formatting.
3) Use Index Match instead of Vlookup()
4).Set Calculation Manual (Calculate only when required)
5).Use Name Ranges.
6).Sort your data
[https://mail.google.com/mail/u/0/images/cleardot.gif]

On Wed, Aug 15, 2012 at 7:18 PM, Amit Desai (MERU) 
mailto:amit.de...@merucabs.com>> wrote:
Dear Friends,

I need to work on huge data in excel 2007. Whenever I use any formula it 
generally slows down & keeps on calculating on every move.

Please provide me tips/suggestion for improving performance.

Best Regards,
Amit



Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.
--
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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.

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to 
excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.





--
With Regards,
Noorain Ansari
http://noorainansari.com
http://excelvbaclinic.com


--
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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.

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to 
excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.




Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of 

$$Excel-Macros$$ Financial Accounting

[RK]

Hi Everyone,
 
Does anyone have any excel workbook that can cater to end to end financial 
accounting of a business.
 
Regards,
Roopesh Kapur

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Cell show blank but in it show formula

[amar takale]

Hi Pravin,
Formula is not work I will try

On Thu, Aug 16, 2012 at 6:50 PM, Pravin Gunjal  wrote:

> Dear Amar
>
> You may use the same formula
>
> =IFERROR(INDEX(INDIRECT($D$2),C10),"")
>
> *With regards,
>
> **Pravin Gunjal**
> *
>
>
> On Thu, Aug 16, 2012 at 5:18 PM, amar takale  wrote:
>
>> Thanks to all very much.One question ask to all there are custom
>> formatting then error will disappear in cell?Is it right? I used index
>> formula in my sheet but it show reference.
>> I attached sheet here Pl see all.
>>
>> On Thu, Aug 16, 2012 at 4:17 PM, Kuldeep Singh 
>> wrote:
>>
>>>
>>> You're Great Noorain Sir.
>>>
>>> Regards,
>>> Kuldeep Singh
>>> Phone.: +91-120-4763789, Extn.: 789
>>> naukrikuld...@gmail.com || www.naukri.com
>>> *Please* *Consider the environment. Please don't print this e-mail
>>> unless you really need to.*
>>>
>>> On Thu, Aug 16, 2012 at 4:12 PM, NOORAIN ANSARI <
>>> noorain.ans...@gmail.com> wrote:
>>>
 Dear Amar,

 In case of 2003 Version
 You can also use..

 =IF(ISERROR(VLOOKUP(F5,$B$4:$D$9,3,0)),"",VLOOKUP(F5,$B$4:$D$9,3,0))
 Or

 =IF(ISNA(VLOOKUP(F5,$B$4:$D$9,3,0)),"",VLOOKUP(F5,$B$4:$D$9,3,0))



 On Thu, Aug 16, 2012 at 3:39 PM, amar takale wrote:

>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not
> allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook.
> Forum owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google
> Groups "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



 --
 With Regards,
 Noorain Ansari
 http:// 
 noorainansari.com
 http:// 
 excelvbaclinic.com


  --
 Join official facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES (1120+ 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.

 6) Jobs posting is not allowed.

 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups "MS EXCEL AND VBA MACROS" group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.

>>>  --
>>> Join official facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES (1120+ 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.
>>>
>>> 6) Jobs posting is not allowed.
>>>
>>> 7) Sharing copy

Re: $$Excel-Macros$$ Chart Update Within Date Data Range

[dguillett1]

Do you want to average the LAST 5 years and the last 9 years from the LAST date 
in col A as you add data to the bottom?
You need to give a complete explanation and EXAMPLES.

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

From: amar takale 
Sent: Thursday, August 16, 2012 3:40 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Chart Update Within Date Data Range

Hi dguillett Sir,
I will send file Pls see attached file.


On Tue, Aug 14, 2012 at 10:06 PM, dguillett1  wrote:

  The macro I gave you answers the question in the post of being able to change 
the chart NAME.
  If  you want something else, send me the file again and a complete 
explanation.

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

  From: amar takale 
  Sent: Tuesday, August 14, 2012 12:18 AM
  To: excel-macros@googlegroups.com 
  Subject: Re: $$Excel-Macros$$ Chart Update Within Date Data Range

  Dear Guillett Sir
  I am confused about this code,I put this code but what changes in sheet,I am 
not under stand.Pls in attached sheet solved problem if possible.I think in to 
cell from date & Last date input through data validation & when I change range 
date then update chart between that date range.
  Thanks for reply
  Amar


  On Mon, Aug 13, 2012 at 7:08 PM, dguillett1  wrote:

Sub namechart()
For Each c In ActiveSheet.ChartObjects
c.Name = InputBox("Change the chart name " & c.Name)
Next c
End Sub

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

From: amar takale 
Sent: Monday, August 13, 2012 1:58 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Chart Update Within Date Data Range

I will Attached file Pls solved me problem


On Fri, Aug 10, 2012 at 3:35 PM, NOORAIN ANSARI  
wrote:

  after typing = in Formula bar, Please select I2 cell then press Enter 



  On Fri, Aug 10, 2012 at 3:33 PM, Imran khan  wrote:

Hi Noorain, 

I am not able do it. When i am selecting Chart title, when typing =, it 
remains = only  



On Fri, Aug 10, 2012 at 3:15 PM, NOORAIN ANSARI 
 wrote:

  Hi Imran,

  First you select Chart Title then goto Formula Bar, Type = and select 
Cell "I2"

  Hope it will help to you. 

  On Fri, Aug 10, 2012 at 3:11 PM, Imran khan  wrote:

Hi Noorain, 

How we write formula in Text Box, as you write " Jan to May" 
(='Dynamic Char 2'$I$2). Could you please guide us. Can we do simply put = and 
then go to cell?

Regards,
Imran 



On Fri, Aug 10, 2012 at 3:02 PM, NOORAIN ANSARI 
 wrote:

  Dear Amar,

  Please find attached Sample file, hope it will fulfill you 
expectation.



  -- 
  With Regards,
  Noorain Ansari
  http://noorainansari.com
  http://excelvbaclinic.com 



  On Fri, Aug 10, 2012 at 2:19 PM, amar takale 
 wrote:

Dear sir,
I have One Chart File with Data,I want to if I changed Date 
from... to. (In particular two cell start & End date) Then automatically 
changed chart Range & Update Chart that within Date range.
Pls send me Example file Then I will use that in my excel

Thank Sir
Amar -- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ 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. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not 
allowed.
 
NOTE : Don't ever post personal or confidential data in a 
workbook. Forum owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the 
Google Groups "MS EXCEL AND VBA MACROS" group.
To post to this group, send email to 
excel-macros@googlegroups.com.

To unsubscribe from this group, send email to 
mailto:excel-macros%2bunsubscr...@googlegroups.com.
 
  

Re: $$Excel-Macros$$ Cell show blank but in it show formula

[Pravin Gunjal]

Dear Amar

You may use the same formula

=IFERROR(INDEX(INDIRECT($D$2),C10),"")

*With regards,

**Pravin Gunjal**
*


On Thu, Aug 16, 2012 at 5:18 PM, amar takale  wrote:

> Thanks to all very much.One question ask to all there are custom
> formatting then error will disappear in cell?Is it right? I used index
> formula in my sheet but it show reference.
> I attached sheet here Pl see all.
>
> On Thu, Aug 16, 2012 at 4:17 PM, Kuldeep Singh wrote:
>
>>
>> You're Great Noorain Sir.
>>
>> Regards,
>> Kuldeep Singh
>> Phone.: +91-120-4763789, Extn.: 789
>> naukrikuld...@gmail.com || www.naukri.com
>> *Please* *Consider the environment. Please don't print this e-mail
>> unless you really need to.*
>>
>> On Thu, Aug 16, 2012 at 4:12 PM, NOORAIN ANSARI > > wrote:
>>
>>> Dear Amar,
>>>
>>> In case of 2003 Version
>>> You can also use..
>>>
>>> =IF(ISERROR(VLOOKUP(F5,$B$4:$D$9,3,0)),"",VLOOKUP(F5,$B$4:$D$9,3,0))
>>> Or
>>>
>>> =IF(ISNA(VLOOKUP(F5,$B$4:$D$9,3,0)),"",VLOOKUP(F5,$B$4:$D$9,3,0))
>>>
>>>
>>>
>>> On Thu, Aug 16, 2012 at 3:39 PM, amar takale wrote:
>>>

  --
 Join official facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES (1120+ 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.

 6) Jobs posting is not allowed.

 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups "MS EXCEL AND VBA MACROS" group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.



>>>
>>>
>>>
>>> --
>>> With Regards,
>>> Noorain Ansari
>>> http:// 
>>> noorainansari.com
>>> http:// 
>>> excelvbaclinic.com
>>>
>>>
>>>  --
>>> Join official facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES (1120+ 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.
>>>
>>> 6) Jobs posting is not allowed.
>>>
>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>>
>>  --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ 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.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND 

Re: $$Excel-Macros$$ Chart Update Within Date Data Range

[dguillett1]

and a complete explanation.

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

From: amar takale 
Sent: Thursday, August 16, 2012 3:40 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Chart Update Within Date Data Range

Hi dguillett Sir,
I will send file Pls see attached file.


On Tue, Aug 14, 2012 at 10:06 PM, dguillett1  wrote:

  The macro I gave you answers the question in the post of being able to change 
the chart NAME.
  If  you want something else, send me the file again and a complete 
explanation.

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

  From: amar takale 
  Sent: Tuesday, August 14, 2012 12:18 AM
  To: excel-macros@googlegroups.com 
  Subject: Re: $$Excel-Macros$$ Chart Update Within Date Data Range

  Dear Guillett Sir
  I am confused about this code,I put this code but what changes in sheet,I am 
not under stand.Pls in attached sheet solved problem if possible.I think in to 
cell from date & Last date input through data validation & when I change range 
date then update chart between that date range.
  Thanks for reply
  Amar


  On Mon, Aug 13, 2012 at 7:08 PM, dguillett1  wrote:

Sub namechart()
For Each c In ActiveSheet.ChartObjects
c.Name = InputBox("Change the chart name " & c.Name)
Next c
End Sub

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

From: amar takale 
Sent: Monday, August 13, 2012 1:58 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Chart Update Within Date Data Range

I will Attached file Pls solved me problem


On Fri, Aug 10, 2012 at 3:35 PM, NOORAIN ANSARI  
wrote:

  after typing = in Formula bar, Please select I2 cell then press Enter 



  On Fri, Aug 10, 2012 at 3:33 PM, Imran khan  wrote:

Hi Noorain, 

I am not able do it. When i am selecting Chart title, when typing =, it 
remains = only  



On Fri, Aug 10, 2012 at 3:15 PM, NOORAIN ANSARI 
 wrote:

  Hi Imran,

  First you select Chart Title then goto Formula Bar, Type = and select 
Cell "I2"

  Hope it will help to you. 

  On Fri, Aug 10, 2012 at 3:11 PM, Imran khan  wrote:

Hi Noorain, 

How we write formula in Text Box, as you write " Jan to May" 
(='Dynamic Char 2'$I$2). Could you please guide us. Can we do simply put = and 
then go to cell?

Regards,
Imran 



On Fri, Aug 10, 2012 at 3:02 PM, NOORAIN ANSARI 
 wrote:

  Dear Amar,

  Please find attached Sample file, hope it will fulfill you 
expectation.



  -- 
  With Regards,
  Noorain Ansari
  http://noorainansari.com
  http://excelvbaclinic.com 



  On Fri, Aug 10, 2012 at 2:19 PM, amar takale 
 wrote:

Dear sir,
I have One Chart File with Data,I want to if I changed Date 
from... to. (In particular two cell start & End date) Then automatically 
changed chart Range & Update Chart that within Date range.
Pls send me Example file Then I will use that in my excel

Thank Sir
Amar -- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ 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. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not 
allowed.
 
NOTE : Don't ever post personal or confidential data in a 
workbook. Forum owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the 
Google Groups "MS EXCEL AND VBA MACROS" group.
To post to this group, send email to 
excel-macros@googlegroups.com.

To unsubscribe from this group, send email to 
mailto:excel-macros%2bunsubscr...@googlegroups.com.
 
 





  -- 
  Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
   

Re: $$Excel-Macros$$ Run-time error popup message

[Lokesh Loki]

Hi Experts,

May i know the reason why my query has been not yet resolved? Any think you
want information from my side or what? I am sending again and again
requests to the experts please resolve it but no buddy is replying. Please
let me know the reason.

Thanks
Lokesh.M

On Sun, Aug 12, 2012 at 9:50 PM, Lokesh Loki wrote:

> Hi Experts,
>
> Please resolve my small query from past 2 weeks i am requesting to the
> group to resolve it but till no buddy is replying to me. The query is
> almost finishing stage but it's not fully resolved getting some mismatch
> macro timings. So please response to my query.
>
> Being a member of group i am expecting a lot from you experts if my query
> is not possible to resolve i will quit my query.
>
> Please do the needful.
>
> Thanks & Regards
> Lokesh.M
>
>
> On Sat, Aug 11, 2012 at 4:28 PM, Lokesh Loki wrote:
>
>> Hi All,
>>
>> Please help me to get the macro timings.
>>
>> Regards
>> Lokesh.M
>>
>>
>> On Thu, Aug 9, 2012 at 7:45 AM, Lokesh Loki wrote:
>>
>>> Hello Rajan,
>>>
>>> Please do the needful. It's very urgent for me brother.
>>>
>>> Regards
>>> Lokesh.M
>>>
>>>
>>> On Wed, Aug 8, 2012 at 8:09 AM, lokesh  wrote:
>>>
  Hello Rajan,

 ** **

 I have placed your code and I confirmed that for 1 day the macro timing
 is calculating 28:00:00 hrs instead of 4:00:00 hrs and it is not
 calculating the 1st to 6th dates macro timings.

 ** **

 And the macro timings for 1 day is 4:00:00 hrs and 2nd day is 8:00:00
 hrs same this should be followed up to 31 working days. So please check and
 do the needful.

 ** **

 Please find the below some of them examples and let me know for any
 doubts.

 ** **

 *(No fo working days * 4:00:00 + Production time)= Production timings
 + Macro timings*

 * *

 *(Range= R3*4:00:00+Q3)*

 ** **

 4:00:00

 4:00:00

 4:00:00

 Production time

 No of working days 

 Production timings + Macro Timings

 Production time

 No of working days 

 Production timings + Macro Timings

 Production time

 No of working days 

 Production timings + Macro Timings

 1:30:51

 1

 5:30:51

 1:30:51

 2

 9:30:51

 1:30:51

 3

 13:30:51

 1:10:25

 1

 5:10:25

 1:10:25

 2

 9:10:25

 1:10:25

 3

 13:10:25

 0:30:20

 1

 4:30:20

 0:30:20

 2

 8:30:20

 0:30:20

 3

 12:30:20

 1:05:01

 1

 5:05:01

 1:05:01

 2

 9:05:01

 1:05:01

 3

 13:05:01

 1:16:40

 1

 5:16:40

 1:16:40

 2

 9:16:40

 1:16:40

 3

 13:16:40

 ** **

  Please find the attached excel sheet for your reference.

 Regards

 Lokesh.M

 --
 Join official facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES (1120+ 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.

 6) Jobs posting is not allowed.

 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups "MS EXCEL AND VBA MACROS" group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.



>>>
>>>
>>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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 

Re: $$Excel-Macros$$ [█ ▆ ▅ ▃ ▂★AVERAGEIF & AVERAGEIFS★▂ ▃ ▅ ▆ █]

[dguillett1]

Homework?

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

From: Kuldeep Singh 
Sent: Thursday, August 16, 2012 2:08 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ [█ ▆ ▅ ▃ ▂★AVERAGEIF & AVERAGEIFS★▂ ▃ ▅ ▆ █]


Hi Experts, 

What is the correct use of AVERAGEIF & AVERAGEIFS. Kindly share more example 
with Excel Sheet.


Regards,
Kuldeep Singh

Back Office Executive (MIS)
Info Edge India Limited (naukri.com)
-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ 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. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
 
 

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ How can i reduce file size of a Excel file

[Rakesh Kumar Sharma]

Dear Noorain/ Amresh,


Thank u so much for great helping.


On Thu, Aug 16, 2012 at 4:21 PM, NOORAIN ANSARI wrote:

> Dear Rakesh,
>
> You can also set high priority of Excel exe file
> See attached screen shot.
>
>
> On Thu, Aug 16, 2012 at 4:15 PM, NOORAIN ANSARI 
> wrote:
>
>> Dear Rakesh,
>>
>> You can do the following to speed up your workbook.
>>
>>
>>
>>
>>
>> 1). Save your file in .xlsb (Binary Format) to reduce size.
>>
>> 2).Remove unnecessary formatting.
>>
>> 3) Use Index Match instead of Vlookup()
>>
>> 4).Set Calculation Manual (Calculate only when required)
>>
>> 5).Use Name Ranges.
>> 6).Sort your data
>>
>>
>> --
>> With Regards,
>> Noorain Ansari
>> http:// 
>> noorainansari.com
>> http:// 
>> excelvbaclinic.com
>>
>>
>> On Thu, Aug 16, 2012 at 1:01 PM, Rakesh Kumar Sharma <
>> rakeshks@gmail.com> wrote:
>>
>>> Hi Experts,
>>>
>>> I have a sheet of 70MB. I am facing problem when using formulas &
>>> filters. It gets slow. I am using Excel 2010. Is there any way to prevent
>>> to being slow process or any format where i can work on a reduced file size.
>>>
>>>
>>>
>>>
>>>
>>>
>>> --
>>> Regards,
>>>
>>> Rakesh Kumar Sharma
>>> Contact: +91-9971024741
>>>
>>>
>>>  --
>>> Join official facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES (1120+ 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.
>>>
>>> 6) Jobs posting is not allowed.
>>>
>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>>
>>>
>>>
>>
>>
>>
>>
>>
>
>
> --
> With Regards,
> Noorain Ansari
> http:// 
> noorainansari.com
> http:// 
> excelvbaclinic.com
>
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
Regards,

Rakesh Kumar Sharma
Contact: +91-9971024741

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a wor

Re: $$Excel-Macros$$ plz solve problem

[NOORAIN ANSARI]

Parvesh, Please share your workbook..

On Wed, Aug 15, 2012 at 10:59 PM, PRAVESH KUMAR wrote:

> Hi All,
> >
> >
> > please find attached file and solve my problem urgent.
> >
> >
> > Thanks
> >
> > Pravesh
> >
>
>
> --
>
>
> *Thanks & Regards*
>
> *Pravesh Kumar*
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>


-- 
With Regards,
Noorain Ansari
http:// 
noorainansari.com
http:// 
excelvbaclinic.com

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Tips for working on huge data in excel 2007

[NOORAIN ANSARI]

You can do the following to speed up your workbook.





1). Save your file in .xlsb (Binary Format) to reduce size.

2).Remove unnecessary formatting.

3) Use Index Match instead of Vlookup()

4).Set Calculation Manual (Calculate only when required)

5).Use Name Ranges.
6).Sort your data


On Wed, Aug 15, 2012 at 7:18 PM, Amit Desai (MERU)
wrote:

>  Dear Friends,
>
> ** **
>
> I need to work on huge data in excel 2007. Whenever I use any formula it
> generally slows down & keeps on calculating on every move.
>
> ** **
>
> Please provide me tips/suggestion for improving performance.
>
> ** **
>
> Best Regards,
>
> Amit
>
> ** **
>
> --
> Disclaimer: This message and its attachments contain confidential
> information and may also contain legally privileged information. This
> message is intended solely for the named addressee. If you are not the
> addressee indicated in this message (or authorized to receive for
> addressee), you may not copy or deliver any part of this message or its
> attachments to anyone or use any part of this message or its attachments.
> Rather, you should permanently delete this message and its attachments (and
> all copies) from your system and kindly notify the sender by reply e-mail.
> Any content of this message and its attachments that does not relate to the
> official business of Meru Cab Company Pvt. Ltd. must be taken not to have
> been sent or endorsed by any of them. Email communications are not private
> and no warranty is made that e-mail communications are timely, secure or
> free from computer virus or other defect.
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
With Regards,
Noorain Ansari
http:// 
noorainansari.com
http:// 
excelvbaclinic.com

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Cell show blank but in it show formula

[amar takale]

Thanks to all very much.One question ask to all there are custom formatting
then error will disappear in cell?Is it right? I used index formula in my
sheet but it show reference.
I attached sheet here Pl see all.

On Thu, Aug 16, 2012 at 4:17 PM, Kuldeep Singh wrote:

>
> You're Great Noorain Sir.
>
> Regards,
> Kuldeep Singh
> Phone.: +91-120-4763789, Extn.: 789
> naukrikuld...@gmail.com || www.naukri.com
> *Please* *Consider the environment. Please don't print this e-mail unless
> you really need to.*
>
> On Thu, Aug 16, 2012 at 4:12 PM, NOORAIN ANSARI 
> wrote:
>
>> Dear Amar,
>>
>> In case of 2003 Version
>> You can also use..
>>
>> =IF(ISERROR(VLOOKUP(F5,$B$4:$D$9,3,0)),"",VLOOKUP(F5,$B$4:$D$9,3,0))
>> Or
>>
>> =IF(ISNA(VLOOKUP(F5,$B$4:$D$9,3,0)),"",VLOOKUP(F5,$B$4:$D$9,3,0))
>>
>>
>>
>> On Thu, Aug 16, 2012 at 3:39 PM, amar takale wrote:
>>
>>>
>>>  --
>>> Join official facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES (1120+ 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.
>>>
>>> 6) Jobs posting is not allowed.
>>>
>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>>
>>>
>>>
>>
>>
>>
>> --
>> With Regards,
>> Noorain Ansari
>> http:// 
>> noorainansari.com
>> http:// 
>> excelvbaclinic.com
>>
>>
>>  --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ 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.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for vio

Re: $$Excel-Macros$$ [█ ▆ ▅ ▃ ▂★AVERAGEIF & AVERAGEIFS★▂ ▃ ▅ ▆ █]

[Vijayendra Rao]

Hi,

Please find attached file with example.

Regards,
Vijayendra

2012/8/16 Amresh Maurya 

> check below link. i hope it will help you.
>
>
> http://www.xlninja.com/2012/08/15/average-averageif-and-averageifs-functions-in-excel/
>
>
> Reagrds
> Amresh
>
>
> On Thu, Aug 16, 2012 at 1:03 PM, amar takale  wrote:
>
>> Hi Amresh,
>> Can you give example file.I also not understand what is different between.
>> Thanks for help
>>
>> On Thu, Aug 16, 2012 at 12:52 PM, Amresh Maurya > > wrote:
>>
>>> Hi ,
>>>
>>>  it works like sumif and sumifs..
>>>
>>> we used it for find average value with criteria
>>>
>>> [image: Inline image 1]
>>>
>>>
>>> Regards
>>> Amresh
>>>
>>> On Thu, Aug 16, 2012 at 12:38 PM, Kuldeep Singh >> > wrote:
>>>

 Hi Experts,

 What is the correct use of AVERAGEIF & AVERAGEIFS. Kindly share more
 example with Excel Sheet.

 Regards,
 Kuldeep Singh
 Back Office Executive (MIS)
 Info Edge India Limited (naukri.com)

 --
 Join official facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES (1120+ 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.

 6) Jobs posting is not allowed.

 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups "MS EXCEL AND VBA MACROS" group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.



>>>
>>>  --
>>> Join official facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES (1120+ 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.
>>>
>>> 6) Jobs posting is not allowed.
>>>
>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>>
>>>
>>>
>>
>> --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ 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.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles.

Re: $$Excel-Macros$$ Cell show blank but in it show formula

[Kuldeep Singh]

You're Great Noorain Sir.

Regards,
Kuldeep Singh
Phone.: +91-120-4763789, Extn.: 789
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*

On Thu, Aug 16, 2012 at 4:12 PM, NOORAIN ANSARI wrote:

> Dear Amar,
>
> In case of 2003 Version
> You can also use..
>
> =IF(ISERROR(VLOOKUP(F5,$B$4:$D$9,3,0)),"",VLOOKUP(F5,$B$4:$D$9,3,0))
> Or
>
> =IF(ISNA(VLOOKUP(F5,$B$4:$D$9,3,0)),"",VLOOKUP(F5,$B$4:$D$9,3,0))
>
>
>
> On Thu, Aug 16, 2012 at 3:39 PM, amar takale  wrote:
>
>>
>>  --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ 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.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>
>
>
> --
> With Regards,
> Noorain Ansari
> http:// 
> noorainansari.com
> http:// 
> excelvbaclinic.com
>
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ How can i reduce file size of a Excel file

[NOORAIN ANSARI]

Dear Rakesh,

You can do the following to speed up your workbook.





1). Save your file in .xlsb (Binary Format) to reduce size.

2).Remove unnecessary formatting.

3) Use Index Match instead of Vlookup()

4).Set Calculation Manual (Calculate only when required)

5).Use Name Ranges.
6).Sort your data


-- 
With Regards,
Noorain Ansari
http:// 
noorainansari.com
http:// 
excelvbaclinic.com


On Thu, Aug 16, 2012 at 1:01 PM, Rakesh Kumar Sharma  wrote:

> Hi Experts,
>
> I have a sheet of 70MB. I am facing problem when using formulas & filters.
> It gets slow. I am using Excel 2010. Is there any way to prevent to being
> slow process or any format where i can work on a reduced file size.
>
>
>
>
>
>
> --
> Regards,
>
> Rakesh Kumar Sharma
> Contact: +91-9971024741
>
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Cell show blank but in it show formula

[NOORAIN ANSARI]

Dear Amar,

In case of 2003 Version
You can also use..

=IF(ISERROR(VLOOKUP(F5,$B$4:$D$9,3,0)),"",VLOOKUP(F5,$B$4:$D$9,3,0))
Or

=IF(ISNA(VLOOKUP(F5,$B$4:$D$9,3,0)),"",VLOOKUP(F5,$B$4:$D$9,3,0))



On Thu, Aug 16, 2012 at 3:39 PM, amar takale  wrote:

>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
With Regards,
Noorain Ansari
http:// 
noorainansari.com
http:// 
excelvbaclinic.com

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ [█ ▆ ▅ ▃ ▂★AVERAGEIF & AVERAGEIFS★▂ ▃ ▅ ▆ █]

[Amresh Maurya]

check below link. i hope it will help you.

http://www.xlninja.com/2012/08/15/average-averageif-and-averageifs-functions-in-excel/


Reagrds
Amresh

On Thu, Aug 16, 2012 at 1:03 PM, amar takale  wrote:

> Hi Amresh,
> Can you give example file.I also not understand what is different between.
> Thanks for help
>
> On Thu, Aug 16, 2012 at 12:52 PM, Amresh Maurya 
> wrote:
>
>> Hi ,
>>
>> it works like sumif and sumifs..
>>
>> we used it for find average value with criteria
>>
>> [image: Inline image 1]
>>
>>
>> Regards
>> Amresh
>>
>> On Thu, Aug 16, 2012 at 12:38 PM, Kuldeep Singh 
>> wrote:
>>
>>>
>>> Hi Experts,
>>>
>>> What is the correct use of AVERAGEIF & AVERAGEIFS. Kindly share more
>>> example with Excel Sheet.
>>>
>>> Regards,
>>> Kuldeep Singh
>>> Back Office Executive (MIS)
>>> Info Edge India Limited (naukri.com)
>>>
>>> --
>>> Join official facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES (1120+ 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.
>>>
>>> 6) Jobs posting is not allowed.
>>>
>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>>
>>>
>>>
>>
>>  --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ 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.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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 o

Re: $$Excel-Macros$$ Cell show blank but in it show formula

[Deba Ranjan]

Dear Amar,

Use Iferror before the desire formula.

 you can use: =IFERROR(VLOOKUP(F5,$B$4:$D$9,3,0),"")


Thanks & Regards,
*Deba Ranjan P*





On Thu, Aug 16, 2012 at 3:39 PM, amar takale  wrote:

>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ Cell show blank but in it show formula

[amar takale]

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.




cell blank with hide formula.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Excellent Track record in Training & placing Freshers as ORACLE DBAs/APPS DBAs

[Amresh Maurya]

pls follow Group Rules.

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

Regards
Amresh

On Thu, Aug 16, 2012 at 2:04 PM, srinivas  wrote:

> Excellent Track record in Training & placing Freshers as ORACLE DBAs/APPS
> DBAs,
> Fresh batch starts from 22nd  August 2012, for details or demo class
> Contact : ORAFACT@Hitech City,Hyderabad (limited Intake)
> Cell#9032719222/333
>
> List of some of the MNC's where our Trainees were placed / working @
>
>
> • ORACLE Corporation,
> • AT&T,
> • IBM,
> • GENPACT,
> • Intelligroup,
> • Sierra Atlantic,
> • Fujitsu Consulting,
> • Apps Associates,
> • Enrich IT,
> • Tech Mahindra,
> • Accenture,
> • Logical Apps,
> • ADP,
> • Bodh TreeConsulting,
> • Zensar,
> • Wipro,
> • Infosys etc.,
>
> Also we are direct placement partners for Oracle Corp, AT & T and IBM.
>
> ** **
>
> ** **
>
> * **Basically its a 3 Months of training in which we cover ***
>
>  *linux***
>
> *SQL***
>
> *Core DBA(9i, 10g, 11g) versions and***
>
> *ORACLE APPS(11i and R12) versions.***
>
>  **
>
> *Timings  : Evening 2hrs of  teaching class and ***
>
> * You can do Lab practice at your flexible timings our
> Lab will be opened 24/7 hours.*
>
> * *
>
> 1.  24hours Lab, Weekly Exams, Interview tips, Mock-interviews and
> Placement Assistance.
>
> 2.  Excellent Classrooms with A/C & Projector
>
> 3.  High-end Servers ( Configuration: 4GB/8GB/16GB RAM, Dual/Quad/i3
> Intel Processor & 500GB/1TB hard disk )
>
> 4.  World-class Computer Lab (A/C), 40KVA UPS & 500KVA Generator.
>
> 5.  4MBPS Internet Leased Line for Internet Access.
>
> 6.  Trainer Mr.Venkat Venu having 19years of experience / 7 years
> with Oracle Corp Singapore & India. Also handled quite number corporate
> trainings.**
>
> * *
>
> ** **
>
> *Batch starts from** ** 22nd  August 2012 ….   DON'T MISS THIS OPPORTUNITY
> * *
> * **
>
> *Limited intake….So Hurry up***
>
>  *Please walk-in for more details and contact***
>
> *Mr.Khan/ Mr.Ganesh***
>
>  **
>
> *Plot no.532, Uptown Cyber bad Building,***
>
> *A-Block, 2nd, 3rd ,4th Floor, 100 Feet Road,***
>
> *Ayyappa society, Madhapur-581***
>
> *Hyderabad, India.***
>
> *www.orafact.com* **
>
> *040-6 454 44 45, 9032719222/333***
>
> ** **
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ How can i reduce file size of a Excel file

[Amresh Maurya]

Hi ,

clear  Unnecessary formatting.delete unused columns
save as file type in Microsoft Binary workbook.

i hope it will help you.

Regards
Amresh

On Thu, Aug 16, 2012 at 1:08 PM, Rakesh Kumar Sharma  wrote:

> Dear Kuldeep,
>
> It's too large  size
>
>
> On Thu, Aug 16, 2012 at 1:03 PM, Kuldeep Singh wrote:
>
>>
>> Hi Rakesh,
>>
>> Please Share a sample worksheet.
>>
>> Regards,
>> Kuldeep Singh
>>
>> On Thu, Aug 16, 2012 at 1:01 PM, Rakesh Kumar Sharma <
>> rakeshks@gmail.com> wrote:
>>
>>> Hi Experts,
>>>
>>> I have a sheet of 70MB. I am facing problem when using formulas &
>>> filters. It gets slow. I am using Excel 2010. Is there any way to prevent
>>> to being slow process or any format where i can work on a reduced file size.
>>>
>>>
>>>
>>>
>>>
>>>
>>> --
>>> Regards,
>>>
>>> Rakesh Kumar Sharma
>>> Contact: +91-9971024741
>>>
>>>
>>>  --
>>> Join official facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES (1120+ 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.
>>>
>>> 6) Jobs posting is not allowed.
>>>
>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>>
>>>
>>>
>>
>>
>>
>>  --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ 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.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>
>
>
> --
> Regards,
>
> Rakesh Kumar Sharma
> Contact: +91-9971024741
>
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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) Do

Re: $$Excel-Macros$$ How can i reduce file size of a Excel file

[Rakesh Kumar Sharma]

Dear Kuldeep,

It's too large  size

On Thu, Aug 16, 2012 at 1:03 PM, Kuldeep Singh wrote:

>
> Hi Rakesh,
>
> Please Share a sample worksheet.
>
> Regards,
> Kuldeep Singh
>
> On Thu, Aug 16, 2012 at 1:01 PM, Rakesh Kumar Sharma <
> rakeshks@gmail.com> wrote:
>
>> Hi Experts,
>>
>> I have a sheet of 70MB. I am facing problem when using formulas &
>> filters. It gets slow. I am using Excel 2010. Is there any way to prevent
>> to being slow process or any format where i can work on a reduced file size.
>>
>>
>>
>>
>>
>>
>> --
>> Regards,
>>
>> Rakesh Kumar Sharma
>> Contact: +91-9971024741
>>
>>
>>  --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ 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.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>
>
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
Regards,

Rakesh Kumar Sharma
Contact: +91-9971024741

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ [█ ▆ ▅ ▃ ▂★AVERAGEIF & AVERAGEIFS★▂ ▃ ▅ ▆ █]

[amar takale]

Hi Amresh,
Can you give example file.I also not understand what is different between.
Thanks for help

On Thu, Aug 16, 2012 at 12:52 PM, Amresh Maurya wrote:

> Hi ,
>
> it works like sumif and sumifs..
>
> we used it for find average value with criteria
>
> [image: Inline image 1]
>
>
> Regards
> Amresh
>
> On Thu, Aug 16, 2012 at 12:38 PM, Kuldeep Singh 
> wrote:
>
>>
>> Hi Experts,
>>
>> What is the correct use of AVERAGEIF & AVERAGEIFS. Kindly share more
>> example with Excel Sheet.
>>
>> Regards,
>> Kuldeep Singh
>> Back Office Executive (MIS)
>> Info Edge India Limited (naukri.com)
>>
>> --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ 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.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.


<>

Re: $$Excel-Macros$$ How can i reduce file size of a Excel file

[Kuldeep Singh]

Hi Rakesh,

Please Share a sample worksheet.

Regards,
Kuldeep Singh

On Thu, Aug 16, 2012 at 1:01 PM, Rakesh Kumar Sharma  wrote:

> Hi Experts,
>
> I have a sheet of 70MB. I am facing problem when using formulas & filters.
> It gets slow. I am using Excel 2010. Is there any way to prevent to being
> slow process or any format where i can work on a reduced file size.
>
>
>
>
>
>
> --
> Regards,
>
> Rakesh Kumar Sharma
> Contact: +91-9971024741
>
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ How can i reduce file size of a Excel file

[koul . ashish]

Save the file in .xlsb format

Sent on my BlackBerry® from Vodafone

-Original Message-
From: Rakesh Kumar Sharma 
Sender: excel-macros@googlegroups.com
Date: Thu, 16 Aug 2012 13:01:54 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ How can i reduce file size of a Excel file

Hi Experts,

I have a sheet of 70MB. I am facing problem when using formulas & filters.
It gets slow. I am using Excel 2010. Is there any way to prevent to being
slow process or any format where i can work on a reduced file size.






-- 
Regards,

Rakesh Kumar Sharma
Contact: +91-9971024741

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.



-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ How can i reduce file size of a Excel file

[Rakesh Kumar Sharma]

Hi Experts,

I have a sheet of 70MB. I am facing problem when using formulas & filters.
It gets slow. I am using Excel 2010. Is there any way to prevent to being
slow process or any format where i can work on a reduced file size.






-- 
Regards,

Rakesh Kumar Sharma
Contact: +91-9971024741

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ [█ ▆ ▅ ▃ ▂★AVERAGEIF & AVERAGEIFS★▂ ▃ ▅ ▆ █]

[Amresh Maurya]

Hi ,

it works like sumif and sumifs..

we used it for find average value with criteria

[image: Inline image 1]


Regards
Amresh

On Thu, Aug 16, 2012 at 12:38 PM, Kuldeep Singh wrote:

>
> Hi Experts,
>
> What is the correct use of AVERAGEIF & AVERAGEIFS. Kindly share more
> example with Excel Sheet.
>
> Regards,
> Kuldeep Singh
> Back Office Executive (MIS)
> Info Edge India Limited (naukri.com)
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.


<>

$$Excel-Macros$$ [█ ▆ ▅ ▃ ▂★AVERAGEIF & AVERAGEIFS★▂ ▃ ▅ ▆ █]

[Kuldeep Singh]

Hi Experts,

What is the correct use of AVERAGEIF & AVERAGEIFS. Kindly share more
example with Excel Sheet.

Regards,
Kuldeep Singh
Back Office Executive (MIS)
Info Edge India Limited (naukri.com)

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.