Re: $$Excel-Macros$$ copy data without opening file

[ankur]

hi hanumant

you may find this to be useful

http://spreadsheetpage.com/index.php...a_closed_file/
 [image: Reply With
Quote]

Have A Nice Time & Enjoy Life

Regards:
CMA Ankur Pandey
(Someone Different)

I'm not the best but i'm not like the rest~~


On Tue, Jul 5, 2011 at 12:40 AM, hanumant shinde wrote:

> Hi friends,
>
> is there any way where we can copy data from closed workbook "A" and paste
> it
> into workbook "B" which is open?
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

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

Re: $$Excel-Macros$$ count unique values

[ankur]

*hi

*

all of these are array formulas

The following formulas will return the number of distinct items in the range
B2:B11. .

The following formula is the longest but most flexible. It will properly
count a list that contains a mix of numbers, text strings, and blank cells.

=SUM(IF(FREQUENCY(IF(LEN(B2:B11)>0,MATCH(B2:B11,B2:B11,0),""),
IF(LEN(B2:B11)>0,MATCH(B2:B11,B2:B11,0),""))>0,1))

If your data does not have any blank entries, you can use the simpler
formula below.

=SUM(1/COUNTIF(B2:B11,B2:B11))

If your data does have embedded blank cells within the full range, you can
use the following array formula:

=SUM(1/IF(B2:B11="",1,(COUNTIF(B2:B11,B2:B11-COUNTBLANK(B2:$B11)

If your data has *only* numeric values or blank cells (no string text
entries), you can use the following formula:

=SUM(N(FREQUENCY(B2:B11,B2:B11)>0))

Have A Nice Time & Enjoy Life

Regards:
CMA Ankur Pandey
(Someone Different)

I'm not the best but i'm not like the rest~~


On Tue, Jul 5, 2011 at 10:37 AM, Dilip Pandey  wrote:

> Nice explanation Haseeb (HTH).. !!
>
> Regards,
> DILIPandey
>
>
> On Tue, Jul 5, 2011 at 12:34 AM, Haseeb Avarakkan <
> haseeb.avarak...@gmail.com> wrote:
>
>> Hello AIren,
>>
>> Consider B1:B6 we have these values;
>>
>> B1=1
>> B2=1
>> B3=Blank
>> B4=A
>> B5=Blank
>> B6=Blank
>>
>> =SUMPRODUCT((B1:B6<>"")/**COUNTIF(B1:B6,B1:B6&""))
>>
>> Firstly take (B1:B6<>"")
>>
>> This will check B2:B30 is blank or not, If it is blank will give FALSE, if
>> not will give TRUE. So will get like this
>>
>> {TRUE;TRUE;FALSE;TRUE;FALSE;FALSE}
>>
>> First 2 cells are not blank;3rd one is blank, 4th one is not blank;5th &
>> 6th are blank
>>
>> COUNTIF(B1:B6,B1:B6&"")
>>
>> This will count B1:B6 against the same range B1:B6. So will get the count
>> of the occurances of each values in the range.
>>
>> If you are adding *&"" *this will add a non zero length text value to the
>> every cells. So blank will become a non zero length text value. If you are
>> not adding &"" this will give you a #DIVO/0! error. Because all the count of
>> blank cells will count as 0
>>
>> Without &"", the array will be,
>>
>> [2;2;0;1;0;0}
>>
>> With &"", the array will be,
>>
>> {2;2;3;1;3;3}
>>
>> See, All blank cells is changed to 3, count of all the blank cells in the
>> range.
>>
>> First 2 cells counts are 2 (First cell value & 2nd cell value should be
>> same);3rd one is blank;4th ones count is 1;5th & 6th cells are blank
>>
>> So, the Arry in SUMP will become;
>>
>> SUMPRODUCT({TRUE;TRUE;FALSE;TRUE;FALSE;FALSE}/{2;2;3;1;3;3})
>>
>> TRUE will converted to 1
>> FALSE will to 0
>>
>> So, here;
>>
>> {1/2;1/2;0/3;1/1;0/3;0/3}
>>
>> Which is;
>>
>> {0.5;0.5;0;1;0;0}
>>
>> {0.5+0.5+0+1+0+0}
>>
>> =2
>>
>> See the below link more about SUMPRODUCT;
>>
>> http://www.xldynamic.com/source/xld.SUMPRODUCT.html
>>
>> HTH
>> Haseeb
>>
>>
>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Thanks & Regards,
>
> DILIP KUMAR PANDEY, mvp
>MBA,B.Com(Hons),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 62, India
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

<><><><><><><><><><><><

RE: $$Excel-Macros$$ Request for instruction

[Rajan_Verma]

See the below web site ..

 

http://www.exceluser.com/explore/sumproduct_12.htm

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ankur
Sent: Tuesday, July 05, 2011 11:18 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Request for instruction

 

hi sant ram 
plz check links below
for sumproduct

http://chandoo.org/wp/2009/11/10/excel-sumproduct-formula/

for array formulas

http://www.cpearson.com/excel/ArrayFormulas.aspx

for substitute

http://www.excelitems.com/2010/05/substitute-function.html


Have A Nice Time & Enjoy Life

Regards:
CMA Ankur Pandey
(Someone Different)

I'm not the best but i'm not like the rest~~



On Mon, Jul 4, 2011 at 11:43 PM, Sant Ram  wrote:

Hey,


please  provide the SUMPRODUCT , SUBSTITUTE and ARRAY formula's  

how to use and instruction


-- 
Regards,
Santy C

-- 

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

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

 

-- 

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

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

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

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

Re: $$Excel-Macros$$ Request for instruction

[ankur]

*hi sant ram
plz check links below
for sumproduct

http://chandoo.org/wp/2009/11/10/excel-sumproduct-formula/

for array formulas

http://www.cpearson.com/excel/ArrayFormulas.aspx

for substitute

http://www.excelitems.com/2010/05/substitute-function.html


*Have A Nice Time & Enjoy Life

Regards:
CMA Ankur Pandey
(Someone Different)

I'm not the best but i'm not like the rest~~


On Mon, Jul 4, 2011 at 11:43 PM, Sant Ram  wrote:

> Hey,
>
>
> please  provide the SUMPRODUCT , SUBSTITUTE and ARRAY formula's
>
> how to use and instruction
>
>
> --
> Regards,
> Santy C
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

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

Re: $$Excel-Macros$$ need required for data validation value query

[ankur]

*hi rajan
thnks for such nice helps ...
due to size & sensitive data in file i cant upload them

cant be there any vba codes for auto change in data validation list one by
one , and the result which came ,get pasted in other sheets.this is what
i needed...

i just want results get pasted in other sheet, by auto change of data
validation.

like this
first a macro change the data validation , and then paste the value in other
sheet in front of data validation value( by using lookup or vlookup function
ofcourse)and then repeat this process till the end of data validation
list .u can  use  combo box for this.also...

*
*

*Have A Nice Time & Enjoy Life

Regards:
CMA Ankur Pandey
(Someone Different)

I'm not the best but i'm not like the rest~~


On Mon, Jul 4, 2011 at 9:29 PM, Rajan_Verma wrote:

> You should attached all Sheets so that I can Link Main Sheet with each
> other.
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of ankur
> Sent: Monday, July 04, 2011 2:06 PM
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ need required for data validation value query
>
> Have A Nice Time & Enjoy Life
>
> Regards:
> CMA Ankur Pandey
> (Someone Different)
>
> I'm not the best but i'm not like the rest~~
>
>
>
> On Mon, Jul 4, 2011 at 12:08 PM, ankur  wrote:
> > file attachedagain forget to attach file Have A Nice Time & Enjoy
> > Life
> >
> > Regards:
> > CMA Ankur Pandey
> > (Someone Different)
> >
> > I'm not the best but i'm not like the rest~~
> >
> >
> >
> > On Mon, Jul 4, 2011 at 11:53 AM, ankur  wrote:
> >> thnks rajan this is what i needed
> >> this is really very nice of youit ease my work load...
> >>
> >> now one more queryin attached file...sheet "gents report"cell
> >> C2 value should get pasted in sheet "gents"...in the front of row
> >> having staff no..
> >>  example is shown..if income tax calculation show "error"...ignore
> >> that data for pasting ..
> >>
> >> Have A Nice Time & Enjoy Life
> >>
> >> Regards:
> >> CMA Ankur Pandey
> >> (Someone Different)
> >>
> >> I'm not the best but i'm not like the rest~~
> >>
> >>
> >>
> >> On Sat, Jul 2, 2011 at 5:40 PM, Rajan_Verma 
> wrote:
> >>> See if it helps
> >>>
> >>> -Original Message-
> >>> From: excel-macros@googlegroups.com
> >>> [mailto:excel-macros@googlegroups.com]
> >>> On Behalf Of ankur
> >>> Sent: Friday, July 01, 2011 5:17 PM
> >>> To: excel-macros
> >>> Subject: Re: $$Excel-Macros$$ need required for data validation
> >>> value query
> >>>
> >>> sorry , i forget to attach a sample file in my query..
> >>> Have A Nice Time & Enjoy Life
> >>>
> >>> Regards:
> >>> CMA Ankur Pandey
> >>> (Someone Different)
> >>>
> >>> I'm not the best but i'm not like the rest~~
> >>>
> >>>
> >>>
> >>> On Fri, Jul 1, 2011 at 5:14 PM, ankur  wrote:
>  hi ayush/ all members
> 
>   i have one data validation list, which is required in formula to
>  get a result i want the all results  corresponding to each
>  value in different sheet or in different column in one click any
>  macro code is there ?
> 
>  thanks in advance
> 
>  Have A Nice Time & Enjoy Life
> 
>  Regards:
>  CMA Ankur Pandey
>  (Someone Different)
> 
>  I'm not the best but i'm not like the rest~~
> 
>  --
>  ---
>  ---
>  
>  Some important links for excel users:
>  1. Follow us on TWITTER for tips tricks and links :
>  http://twitter.com/exceldailytip 2. Join our LinkedIN group @
>  http://www.linkedin.com/groups?gid=1871310
>  3. Excel tutorials at http://www.excel-macros.blogspot.com
>  4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel
>  Tips and Tricks at http://exceldailytip.blogspot.com
> 
>  To post to this group, send email to excel-macros@googlegroups.com
> 
>  <><><><><><><><><><><><><><><><><><><><><><>
>  Like our page on facebook , Just follow below link
>  http://www.facebook.com/discussexcel
> 
> >>>
> >>> --
> >>> 
> >>> 
> >>> --
> >>> Some important links for excel users:
> >>> 1. Follow us on TWITTER for tips tricks and links :
> >>> http://twitter.com/exceldailytip 2. Join our LinkedIN group @
> >>> http://www.linkedin.com/groups?gid=1871310
> >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel
> >>> Tips and Tricks at http://exceldailytip.blogspot.com
> >>>
> >>> To post to this group, send email to excel-macros@googlegroups.com
> >>>
> >>> <><><><><><><><><><><><><><><><><><><><><><>
> >>> Like our page on facebook , Just follow below link
> >>> http://www.facebook.com/discussexcel
> >>>
> >>> --
> >>> 

Re: $$Excel-Macros$$ count unique values

[Dilip Pandey]

Nice explanation Haseeb (HTH).. !!

Regards,
DILIPandey

On Tue, Jul 5, 2011 at 12:34 AM, Haseeb Avarakkan <
haseeb.avarak...@gmail.com> wrote:

> Hello AIren,
>
> Consider B1:B6 we have these values;
>
> B1=1
> B2=1
> B3=Blank
> B4=A
> B5=Blank
> B6=Blank
>
> =SUMPRODUCT((B1:B6<>"")/**COUNTIF(B1:B6,B1:B6&""))
>
> Firstly take (B1:B6<>"")
>
> This will check B2:B30 is blank or not, If it is blank will give FALSE, if
> not will give TRUE. So will get like this
>
> {TRUE;TRUE;FALSE;TRUE;FALSE;FALSE}
>
> First 2 cells are not blank;3rd one is blank, 4th one is not blank;5th &
> 6th are blank
>
> COUNTIF(B1:B6,B1:B6&"")
>
> This will count B1:B6 against the same range B1:B6. So will get the count
> of the occurances of each values in the range.
>
> If you are adding *&"" *this will add a non zero length text value to the
> every cells. So blank will become a non zero length text value. If you are
> not adding &"" this will give you a #DIVO/0! error. Because all the count of
> blank cells will count as 0
>
> Without &"", the array will be,
>
> [2;2;0;1;0;0}
>
> With &"", the array will be,
>
> {2;2;3;1;3;3}
>
> See, All blank cells is changed to 3, count of all the blank cells in the
> range.
>
> First 2 cells counts are 2 (First cell value & 2nd cell value should be
> same);3rd one is blank;4th ones count is 1;5th & 6th cells are blank
>
> So, the Arry in SUMP will become;
>
> SUMPRODUCT({TRUE;TRUE;FALSE;TRUE;FALSE;FALSE}/{2;2;3;1;3;3})
>
> TRUE will converted to 1
> FALSE will to 0
>
> So, here;
>
> {1/2;1/2;0/3;1/1;0/3;0/3}
>
> Which is;
>
> {0.5;0.5;0;1;0;0}
>
> {0.5+0.5+0+1+0+0}
>
> =2
>
> See the below link more about SUMPRODUCT;
>
> http://www.xldynamic.com/source/xld.SUMPRODUCT.html
>
> HTH
> Haseeb
>
>
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Thanks & Regards,

DILIP KUMAR PANDEY, mvp
   MBA,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India

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

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

Re: $$Excel-Macros$$ Re: and the Microsoft MVP award goes to Ashish Koul :)

[Vasant]

Hey Ashish,

Congrats!,
You deserve it



On Tue, Jul 5, 2011 at 3:47 AM, bpascal123  wrote:
> Ayush,
> I wish you well.
> Congrats to Ashish!
> Pascal
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links : 
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Regards

Vasant

skype Id: vasantjob
vasant...@gmail.com

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

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

$$Excel-Macros$$ Job

[ashish koul]

Recruiter Email: gunjan.chaphe...@careernet.co.in


Experience required for the Job: 2 - 6 years
Job Location: Bengaluru/Bangalore


Dear Candidate,

We came across your profile on one of the job portal and found it
interesting and prospective for one of our key clients.

In further to this, we would like to discuss an opening with DELL Global
Aanlytics Bangalore,
(www.dell.com ), Bangalore.

Job Description:

Postion : Business Analyst / Sr. Business Analyst/ Advisor

Role : Individual Contributer

Exp : 2 – 6 yrs.

Location : Bangalore.

Work hours : 2PM – 11PM.

Skills :

- SAS BASE/ SAS Macro / SAS SQL
- Should have good experience in Data Analytics, Reporting, Data Modeling,
Data mining.
- Hands on experience on Advance Excel (Pivot tables,Excel Lookups, Macros,
etc )
- Excellent communication skills.

Basic responsibility :

Developing business solution by performing data analysis and developing
reports as per requirement using SAS and Excel.

Kindly let us know your views, so that we can discuss further details on
this. Meanwhile send across your updated profile and the following details

1)Total Experience:
2) Current CTC:
3) Expected CTC:
4) Notice Period:
5) Current Company
6) Working in current company since:
7) Employment (Contract/Permanent) :
8) Ready to Relocate to Bangalore:


Would appreciate if you pass this information to your colleagues and
friends, who might be interested in this opening.

Looking forward to hear from you soon.

Regards,
Gunjan Chaphekar I Associate Consultant
CareerNet Consulting
Salarpuria Soft Zone, 4th Floor, 'A' Block, 'B' Wing
80/1, 80/2 Outer Ring Road, Belandur Post, Bangalore - 560103.
Direct: +91-80-66550097;
Email: gunjan.chaphe...@careernet.co.in
URL: www.careernet.co.in
Blog: http://blog.careernet.co.in/
Bangalore | Chennai | Delhi | Hyderabad | Mumbai | Pune



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

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

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

$$Excel-Macros$$ Job

[ashish koul]

Recruiter  - Email – sunit...@synovaindia.com

Experience required for the Job: 4 - 6 years
Job Location: Noida


Dear Candidate,

Hi

Urgent requirement for “VB/VBA†with Synova Innovative Technologies Pvt.
Ltd for one of our CMML5 Client, for Noida.

Skill - “VB/VBAâ€
Location - Noida
Education - Any
Experience - 4 To 6 Years

Plz apply only if you can join in max 15-20 days.

If you are interested please send your Updated resume with the below
mentioned details –

Total Experience -
Relevant Experience -
Current CTC -
Expected CTC -
Notice Period -

For more about Synova ïƒ  www.synovaindia.com
About Synova
Synova is a US based IT Solutions Company with about 3000 employees
worldwide. We are a ISO: 9001-2000 certified company with NASSCOM
registration. We are dedicated to providing an exceptional standard of
service and care to our customers as well as our employees. At Synova, we
take pride in our ability to efficiently fulfill the staffing needs of our
clients. Synova has gained added value through recognition of superb
quality, credibility, and competency in its ability to provide outstanding
services on a national level to many of the Fortune 500 companies. We have
our presence in USA, Hong Kong, Brazil, China and India.

Thanks & Regards
Sunitha Vijay
Executive-Talent Acquisition
Contact Nos 40254343 Ext: 4372 Direct: 40254372
Synova Innovative Technologies Pvt Ltd
Regd. Office: Survey No 7(P), 93(P),
Electronic City Phase - II Begur Hobli,
Bangalore – 560100
Email – sunit...@synovaindia.com
URL – www.synovaindia.com
|India|USA|China|Brazil|Hongkong|Singapore|

-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

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

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

Re: $$Excel-Macros$$ Macro for find any possible combination of numbers from given numbers to a given total

[Markkim]

Hi!  siti Vi

I tried to download the example workbook but no file found 

could you send me the file if you can please???  

Thanks


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

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

Re: $$Excel-Macros$$ Macro for find any possible combination of numbers from given numbers to a given total

[Markkim]

Well, I haven't tried but looks like it's exactly what I want

Thanks Million

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

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

Re: $$Excel-Macros$$ workbook location on status bar

[netuser501]

thanx,

Venkat solution is most practical for 2007 since it works on all
workbooks that work and don't work with vba code.
I guess the vba code for this is for Excel 2003?

Pascal

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

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

$$Excel-Macros$$ Re: and the Microsoft MVP award goes to Ashish Koul :)

[bpascal123]

Ayush,
I wish you well.
Congrats to Ashish!
Pascal

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

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

$$Excel-Macros$$ JOB MS Excel Expert (Macro / VBA)

[Sant Ram]

 MS Excel Expert (Macro / VBA)
2 Opening(s)
Shanti Consultants
  *
*
   Summary

  *Experience:*

3 - 6 Years
 *Location:*

Delhi, Delhi/NCR, Noida
 *Compensation:*

Rupees 3,00,000 - 6,00,000
 *Education:*

UG - B.Sc - Computers,BCA - Computers PG - PG Diploma - Computers
 *Industry Type:*

Oil and Gas/ Power/Infrastructure/Energy
 *Role:*

Information Systems(MIS)-Mgr
 *Functional Area:*

Systems, EDP, MIS
 *Posted Date:*

30 Jun
 Desired Candidate Profile Only Male Candite Need to Apply.Must Be Expert In
MS Excel with 4 - 5 Years of experience having excellent knowledge of MS
Excel,Macro,Visual Basic,Business Intelligence& Data Analysis.Job Location-
Noida Job Description Expert in advanced excel,Macro & Visual Basic. Usage
of excel in various MIS reports for data capture and related use.Need To
Manage Macro,Macro Creations.Do Data Analysis,Business
Intelligence,Operations analysis.
*Keywords:* MS Excel Expert Macro,Visual Basic, 3 - 6 yrs, Data
Analysis,Business Intelligence,Operations analysis., Noida
Company Profile A global leader in various sectors including shipbuilding,
offshore, engineering and construction, wind power, power and control
systems.Job location is at Noida . Contact Details
 *Company Name:*

Shanti Consultants
 *Website:*

Not Mentioned
 *Executive Name:*

Ms. Vineeta Goel
 *Address:*

Not Mentioned
 *Email Address:*

info_...@shanticonsultants.in
 *Telephone:*

9311171489,9311371489


Regards,

Santy C




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

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

$$Excel-Macros$$ copy data without opening file

[hanumant shinde]

Hi friends,

is there any way where we can copy data from closed workbook "A" and paste it 
into workbook "B" which is open?

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

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

Re: $$Excel-Macros$$ count unique values

[Haseeb Avarakkan]

Hello AIren,
 
Consider B1:B6 we have these values;
 
B1=1
B2=1
B3=Blank
B4=A
B5=Blank
B6=Blank
 
=SUMPRODUCT((B1:B6<>"")/COUNTIF(B1:B6,B1:B6&""))
 
Firstly take (B1:B6<>"")
 
This will check B2:B30 is blank or not, If it is blank will give FALSE, if 
not will give TRUE. So will get like this
 
{TRUE;TRUE;FALSE;TRUE;FALSE;FALSE}
 
First 2 cells are not blank;3rd one is blank, 4th one is not blank;5th & 6th 
are blank
 
COUNTIF(B1:B6,B1:B6&"")
 
This will count B1:B6 against the same range B1:B6. So will get the count of 
the occurances of each values in the range.
 
If you are adding *&"" *this will add a non zero length text value to the 
every cells. So blank will become a non zero length text value. If you are 
not adding &"" this will give you a #DIVO/0! error. Because all the count of 
blank cells will count as 0
 
Without &"", the array will be,
 
[2;2;0;1;0;0}
 
With &"", the array will be,
 
{2;2;3;1;3;3}
 
See, All blank cells is changed to 3, count of all the blank cells in the 
range.
 
First 2 cells counts are 2 (First cell value & 2nd cell value should be 
same);3rd one is blank;4th ones count is 1;5th & 6th cells are blank
 
So, the Arry in SUMP will become;
 
SUMPRODUCT({TRUE;TRUE;FALSE;TRUE;FALSE;FALSE}/{2;2;3;1;3;3})
 
TRUE will converted to 1
FALSE will to 0
 
So, here;
 
{1/2;1/2;0/3;1/1;0/3;0/3}
 
Which is;
 
{0.5;0.5;0;1;0;0}
 
{0.5+0.5+0+1+0+0}
 
=2
 
See the below link more about SUMPRODUCT;
 
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
 
HTH
Haseeb
 
 
 

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

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

Re: $$Excel-Macros$$ XBRL in Excel

[Mehul Mukati]

this was exactly what i'm thinking of building. anyone wants to work
together on this time-sensitive project then email me at
mehul.muk...@gmail.com

regards ... mehul

On Mon, Jul 4, 2011 at 6:21 PM, tikku  wrote:

> Dear All,
>
> Did anybody build a XBRL Creator in Excel to create a Instance
> Documents for MCA filings.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

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

$$Excel-Macros$$ Request for instruction

[Sant Ram]

Hey,


please  provide the SUMPRODUCT , SUBSTITUTE and ARRAY formula's

how to use and instruction


-- 
Regards,
Santy C

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

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

Re: $$Excel-Macros$$ count unique values

[Sant Ram]

Hey,

try my attachment

i think my formula is very simple so please try


Regards,
Santy C

On Mon, Jul 4, 2011 at 10:13 PM, Haseeb Avarakkan <
haseeb.avarak...@gmail.com> wrote:

> Hello,
>
> If you want to count the unique numbres in a range, use this with just
> Enter, *doesn't require* Control+Shift+Enter.
>
> =SUM(SIGN(FREQUENCY(A:A,A:A)))
>
> HTH
> Haseeb
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Regards,
Santy

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

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


Santy C.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Re: and the Microsoft MVP award goes to Ashish Koul :)

[Sant Ram]

Hey Boss,

Congratulation.



On Sun, Jul 3, 2011 at 8:15 PM, ashish koul  wrote:

> Thank You All..
>
> On Sat, Jul 2, 2011 at 10:37 AM, Brajesh Kumar Porwal <
> brajeshkumarpor...@gmail.com> wrote:
>
>> *Congratulations Ashish keep it uppp-- *
>> ***
>> *
>> *-- *
>> *--
>> One Team One Dream One Goal
>>
>> Warm Regards,
>> Brajesh Kumar Porwal
>> E-Mail :- brajeshkumarpor...@gmail.com
>> 7503020750,
>> "We can't Spell S_ccess without U"
>>
>> Life is Very beautiful !!!
>> ¨`•.•´¨) Always
>> `•.¸(¨`•.•´¨) Keep
>> (¨`•.•´¨)¸.•´ Smiling!
>> `•.¸.•´.
>> *
>>
>>
>> On Sat, Jul 2, 2011 at 10:10 AM, Suriya  wrote:
>>
>>> Congrats Ashish Ji..
>>>
>>> You are really a MVP
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>
>>
>>
>>  --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com 
> http://akoul.posterous.com/
>  *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> P Before printing, think about the environment.
>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Regards,
Santy C

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

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

RE: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - June'11

[Ahmed galal]

Congratulations Ashish, you deserve it.



Best regards,

 

Ahmed
galal Mohamed

Procurement
Engineer



Head
Office : SQUARE Engineering Firm

Tel   :(202) 2402 8846

Fax  :(202) 2405 0476

Mobile :(010) 9 62 60 61

Website : http://www.square.com.eg

31 Lebanon St. Mohandsen,
Giza, Egypt

 

From: jainayus...@gmail.com
Date: Mon, 4 Jul 2011 22:48:33 +0530
Subject: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - June'11
To: excel-macros@googlegroups.com





Hello Everyone,

Ashish Koul has been selected as 'Most Helpful Member' for the month of June'11
He has posted 53 posts in June 2011 and helped many people through his 
expertise. He has been consistent contributor to this excel forum and achieved 
this recognition from last seven months consecutively.This is really awesome. 
He is awarded Microsoft MVP 2011 award for his voluntary contribution. 


 
   Thanks to Rajan, Venkat and other folks for helping excel enthusiasts !! 
keep it up !!
 
   Let see who becomes next MVP..
 
   Keep posting.
 



Regards
Ayush Jain
Group Manager



-- 

--

Some important links for excel users:

1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip

2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310

3. Excel tutorials at http://www.excel-macros.blogspot.com

4. Learn VBA Macros at http://www.quickvba.blogspot.com

5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 

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

 

<><><><><><><><><><><><><><><><><><><><><><>

Like our page on facebook , Just follow below link

http://www.facebook.com/discussexcel
  

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

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

Re: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - June'11

[Dilip Pandey]

Congratulations Ashish...!! you Rock  :)


Regards,
DILIPandey

On 7/4/11, Ayush Jain  wrote:
>>
>>  Hello Everyone,
>>
>> Ashish Koul has been selected as 'Most Helpful Member' for the month of
>> June'11
>> He has posted 53 posts in June 2011 and helped many people through his
>> expertise. He has been consistent contributor to this excel forum and
>> achieved this recognition from last seven months consecutively.This is
>> really awesome. He is awarded Microsoft MVP 2011 award for his voluntary
>> contribution.
>>
>
>Thanks to Rajan, Venkat and other folks for helping excel enthusiasts !!
> keep it up !!
>
>Let see who becomes next MVP..
>
>Keep posting.
>
>
>>  Regards
>> Ayush Jain
>> Group Manager
>>
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>


-- 
Thanks & Regards,

DILIP KUMAR PANDEY, mvp
   MBA,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India

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

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

Re: $$Excel-Macros$$ count unique values

[Dilip Pandey]

Hi Airen,

This is the beauty of SumProduct function.
Below is the explanation:-

If you evaluate the formula in parts, you will get following look:
=SUMPRODUCT(({TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE})/{7;4;4;6;7;7;4;4;6;2;4;1;7;4;4;6;7;7;4;4;6;1;7;4;4;6;2;4;6})

To obtain above look, first select (B2:B30<>"") in formula and press
F9 and then select COUNTIF(B2:B30,B2:B30&"") in formula and press F9.

Now, if you see the first part of the formula, it is checking if any
value between B2 to B30 is blank or not. After this, the second part
of formula is checking the repeat counts of values with in B2 to B30 (
I am assuming you know the working of countif function).
If we include both of above functions in sumproduct, then Sumproduct
picks up the values which are not blank and Not repeated values as a
combination.

I hope this clarifies to some extent. :)

Best Regards,
DILIPandey


On 7/4/11, airen  wrote:
> Hi,
> i want to count unique values in a selection. I got this formula on
> net =SUMPRODUCT((B2:B30<>"")/COUNTIF(B2:B30,B2:B30&"")) but i dont
> know how it works. So please help me understand this formula.
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>


-- 
Thanks & Regards,

DILIP KUMAR PANDEY, mvp
   MBA,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India

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

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

$$Excel-Macros$$ Ashish Koul : Most Helpful Member - June'11

[Ayush Jain]

>
>  Hello Everyone,
>
> Ashish Koul has been selected as 'Most Helpful Member' for the month of
> June'11
> He has posted 53 posts in June 2011 and helped many people through his
> expertise. He has been consistent contributor to this excel forum and
> achieved this recognition from last seven months consecutively.This is
> really awesome. He is awarded Microsoft MVP 2011 award for his voluntary
> contribution.
>

   Thanks to Rajan, Venkat and other folks for helping excel enthusiasts !!
keep it up !!

   Let see who becomes next MVP..

   Keep posting.


>  Regards
> Ayush Jain
> Group Manager
>

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

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

RE: $$Excel-Macros$$ How Can I Clear Content & Autofill

[Ahmed galal]

Excellent ashish, it's work nowthanks a lot



Best regards,

 

Ahmed
galal Mohamed

Procurement
Engineer



Head
Office : SQUARE Engineering Firm

Tel   :(202) 2402 8846

Fax  :(202) 2405 0476

Mobile :(010) 9 62 60 61

Website : http://www.square.com.eg

31 Lebanon St. Mohandsen,
Giza, Egypt

 

Date: Mon, 4 Jul 2011 22:18:37 +0530
Subject: Re: $$Excel-Macros$$ How Can I Clear Content & Autofill
From: koul.ash...@gmail.com
To: excel-macros@googlegroups.com

try this code-
 

Private Sub Worksheet_Change(ByVal Target As Range)
Dim cell As Range
Dim abc As Range
If Target.Column = 19 Then
Set abc = Range("s" & Target.Row & ":s" & Target.Row + Target.Rows.Count)

 

For Each cell In abc
Select Case cell.Value
Case "A"
cell.EntireRow.Interior.Color = RGB(192, 192, 192)
Case "B"
cell.EntireRow.Interior.Color = RGB(0, 0, 255)
Case "C"
cell.EntireRow.Interior.Color = RGB(255, 255, 0)
Case Else
cell.EntireRow.Interior.Color = xlNone
End Select
Next cell
End If
End Sub


 
On Mon, Jul 4, 2011 at 9:44 PM, Ahmed galal  wrote:




I'll explain what the problem:-try to pull + for cell to auto fill code like 
"A" into 3 cells down it will return error, also if u select more than one cell 
including codes and delete selection contents it returns error also.







Date: Mon, 4 Jul 2011 21:27:49 +0530
Subject: Re: $$Excel-Macros$$ How Can I Clear Content & Autofill
From: koul.ash...@gmail.com

To: excel-macros@googlegroups.com 




try this see if it helps 



Private Sub Worksheet_Change(ByVal Target As Range)


If Target.Column = 19 And Target.Count = 1 Then


Select Case Target.Value
Case "A"
Target.EntireRow.Interior.Color = RGB(192, 192, 192)


Case "B"
Target.EntireRow.Interior.Color = RGB(0, 0, 255)


Case "C"
Target.EntireRow.Interior.Color = RGB(255, 255, 0)
Case Else


Target.EntireRow.Interior.Color = xlNone
End Select
End If
End Sub



On Mon, Jul 4, 2011 at 7:51 PM, Ahmed galal  wrote:



Hi all 
I choose a specific Column Such as X Column and when one cell change it's 
return a value in another cell in another column.
now i need to make Auto-fill or Clear Content to act on all row content, plz 
see the attachment




Best regards,

 
Ahmed galal Mohamed
Procurement Engineer

Head Office : SQUARE Engineering Firm
Tel   :(202) 2402 8846
Fax  :(202) 2405 0476
Mobile :(010) 9 62 60 61

Website : http://www.square.com.eg
31 Lebanon St. Mohandsen, Giza, Egypt


 

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip

2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com

4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com


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

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


-- 

Regards
 
Ashish Koul
akoul.blogspot.com
http://akoul.posterous.com/


akoul.wordpress.com
My Linkedin Profile
 

P Before printing, think about the environment.
 

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip

2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com

4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com


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

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




-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip

2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com

4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com


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

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


-- 


Regards
 
Ashish Koul
akoul.blogspot.com
http://akoul.posterous.com/


akoul.wordpress.com
My Linkedin Profile
 

P Before printing, think about the environment.
 




-- 

--

Some important links for excel users:

1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip

2. Join our 

Re: $$Excel-Macros$$ count unique values

[Haseeb Avarakkan]

Hello,
 
If you want to count the unique numbres in a range, use this with just 
Enter, *doesn't require* Control+Shift+Enter.
 
=SUM(SIGN(FREQUENCY(A:A,A:A)))
 
HTH
Haseeb

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

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

Re: $$Excel-Macros$$ and the Microsoft MVP award goes to Ashish Koul :)

[seraj alam]

Hi Ashish,

Many many congrats...


With best wishesh,
Seraj Alam




On Mon, Jul 4, 2011 at 9:40 PM, Hari  wrote:

> Thanks for getting the award. Even though, i am very new to this group,
> I proudly wishes to keep this spirit high always,
> Have a nice day
>
> with best wishes,
>
>
> Regards,
> Hari
>
> On 1 July 2011 21:25, Ayush  wrote:
>
>> Dear Group,
>> I am extremely happy to share a good news with you. One of our dearest
>> group member 'Ashish Koul' is awarded Microsoft MVP award on 1st July for
>> his exceptional MS Excel skills and voluntary contribution.
>> He is well deserving for the award and I am very happy and proud of his
>> recognition. The guy has been top poster in the group from last 7-8 months.
>>  Let see who becomes the next MVP from the group. The group has now three
>> active MVPs.
>>
>> Dear Ashish,
>> Many Many congratulations for the award.I am very proud of you to be part
>> of this group.
>> Keep your valuable contribution to the group. I wish your long association
>> with this group.
>> Cheers !!
>> Best Regards,
>> Ayush Jain
>> Group Manager
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Yours,
>
> Hari.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

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

Re: $$Excel-Macros$$ How Can I Clear Content & Autofill

[ashish koul]

try this code-


Private Sub Worksheet_Change(ByVal Target As Range)
Dim cell As Range
Dim abc As Range
If Target.Column = 19 Then
Set abc = Range("s" & Target.Row & ":s" & Target.Row + Target.Rows.Count)


For Each cell In abc
Select Case cell.Value
Case "A"
cell.EntireRow.Interior.Color = RGB(192, 192, 192)
Case "B"
cell.EntireRow.Interior.Color = RGB(0, 0, 255)
Case "C"
cell.EntireRow.Interior.Color = RGB(255, 255, 0)
Case Else
cell.EntireRow.Interior.Color = xlNone
End Select
Next cell
End If
End Sub



On Mon, Jul 4, 2011 at 9:44 PM, Ahmed galal  wrote:

>  I'll explain what the problem:-
> try to pull + for cell to auto fill code like "A" into 3 cells down it will
> return error, also if u select more than one cell including codes and delete
> selection contents it returns error also.
>
>
> Date: Mon, 4 Jul 2011 21:27:49 +0530
> Subject: Re: $$Excel-Macros$$ How Can I Clear Content & Autofill
> From: koul.ash...@gmail.com
> To: excel-macros@googlegroups.com
>
>
> try this see if it helps
>
>  Private Sub Worksheet_Change(ByVal Target As Range)
>
> If Target.Column = 19 And Target.Count = 1 Then
>
> Select Case Target.Value
> Case "A"
> Target.EntireRow.Interior.Color = RGB(192, 192, 192)
>
> Case "B"
> Target.EntireRow.Interior.Color = RGB(0, 0, 255)
>
> Case "C"
> Target.EntireRow.Interior.Color = RGB(255, 255, 0)
> Case Else
>
> Target.EntireRow.Interior.Color = xlNone
> End Select
> End If
> End Sub
>
>
> On Mon, Jul 4, 2011 at 7:51 PM, Ahmed galal  wrote:
>
>  *Hi all*
> I choose a specific Column Such as X Column and when one cell change it's
> return a value in another cell in another column.
> now i need to make Auto-fill or Clear Content to act on all row content,
> plz see the attachment
>
>
> Best regards,
>
>
>
> *Ahmed galal Mohamed*
>
> Procurement Engineer
>
> Head Office : SQUARE Engineering Firm
> Tel   :(202) 2402 8846
> Fax  :(202) 2405 0476
> Mobile :(010) 9 62 60 61
> Website : http://www.square.com.eg
> 31 Lebanon St. Mohandsen, Giza, Egypt
>
>
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com 
> http://akoul.posterous.com/
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> P Before printing, think about the environment.
>
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutori

Re: $$Excel-Macros$$ Help what the hell is wrong with my pivot table?

[ashish koul]

can you share the workbooks

On Mon, Jul 4, 2011 at 9:44 PM, Jorge Marques  wrote:

> Mmm i checked the range, and everything is ok, even if i open the pivot
> workbook and choose the source range again, it gives the same error when i
> do refresh data :(, gives #NAME, and also on the list formulas appears
> #NAME.
>
>
> 2011/7/4 ashish koul 
>
>> have you changed name of a name range used in the formula
>>
>>
>> On Mon, Jul 4, 2011 at 9:23 PM, Jorge Marques wrote:
>>
>>> Hi guys, i have a pivot table that is feeded through another workbook,
>>> then i calculate the rest of the pivot with the option "Calculated fields"
>>> but i have a problem, each time i open the 2 workbooks and make refresh, my
>>> calculated fields disappear leaving "#NAME" in the cells, and i have to do
>>> the formulas all over again.
>>>
>>> Anyone knows what is going on?1000 thanks
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>
>>
>> --
>> *Regards*
>> * *
>> *Ashish Koul*
>> *akoul*.*blogspot*.com 
>> http://akoul.posterous.com/
>> *akoul*.wordpress.com 
>> My Linkedin Profile 
>>
>>
>> P Before printing, think about the environment.
>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

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

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

RE: $$Excel-Macros$$ How Can I Clear Content & Autofill

[Ahmed galal]

I'll explain what the problem:-try to pull + for cell to auto fill code like 
"A" into 3 cells down it will return error, also if u select more than one cell 
including codes and delete selection contents it returns error also.


Date: Mon, 4 Jul 2011 21:27:49 +0530
Subject: Re: $$Excel-Macros$$ How Can I Clear Content & Autofill
From: koul.ash...@gmail.com
To: excel-macros@googlegroups.com

try this see if it helps
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 19 And Target.Count = 1 Then
Select Case Target.Value
Case "A"Target.EntireRow.Interior.Color = RGB(192, 192, 192)
Case "B"Target.EntireRow.Interior.Color = RGB(0, 0, 255)
Case "C"
Target.EntireRow.Interior.Color = RGB(255, 255, 0)Case Else
Target.EntireRow.Interior.Color = xlNoneEnd SelectEnd IfEnd Sub


On Mon, Jul 4, 2011 at 7:51 PM, Ahmed galal  wrote:








Hi allI choose a specific Column Such as X Column and when one cell change it's 
return a value in another cell in another column.
now i need to make Auto-fill or Clear Content to act on all row content, plz 
see the attachment




Best regards,

 

Ahmed
galal Mohamed

Procurement
Engineer



Head
Office : SQUARE Engineering Firm

Tel   :(202) 2402 8846

Fax  :(202) 2405 0476

Mobile :(010) 9 62 60 61

Website : http://www.square.com.eg

31 Lebanon St. Mohandsen,
Giza, Egypt

  




-- 

--

Some important links for excel users:

1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip

2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310

3. Excel tutorials at http://www.excel-macros.blogspot.com

4. Learn VBA Macros at http://www.quickvba.blogspot.com

5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 

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

 

<><><><><><><><><><><><><><><><><><><><><><>

Like our page on facebook , Just follow below link

http://www.facebook.com/discussexcel



-- 
Regards
 
Ashish Koul
akoul.blogspot.com
http://akoul.posterous.com/


akoul.wordpress.com
My Linkedin Profile
 

P Before printing, think about the environment.
 





-- 

--

Some important links for excel users:

1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip

2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310

3. Excel tutorials at http://www.excel-macros.blogspot.com

4. Learn VBA Macros at http://www.quickvba.blogspot.com

5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 

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

 

<><><><><><><><><><><><><><><><><><><><><><>

Like our page on facebook , Just follow below link

http://www.facebook.com/discussexcel
  

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

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

Re: $$Excel-Macros$$ Help what the hell is wrong with my pivot table?

[Jorge Marques]

Mmm i checked the range, and everything is ok, even if i open the pivot
workbook and choose the source range again, it gives the same error when i
do refresh data :(, gives #NAME, and also on the list formulas appears
#NAME.

2011/7/4 ashish koul 

> have you changed name of a name range used in the formula
>
>
> On Mon, Jul 4, 2011 at 9:23 PM, Jorge Marques wrote:
>
>> Hi guys, i have a pivot table that is feeded through another workbook,
>> then i calculate the rest of the pivot with the option "Calculated fields"
>> but i have a problem, each time i open the 2 workbooks and make refresh, my
>> calculated fields disappear leaving "#NAME" in the cells, and i have to do
>> the formulas all over again.
>>
>> Anyone knows what is going on?1000 thanks
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com 
> http://akoul.posterous.com/
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> P Before printing, think about the environment.
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

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

Re: $$Excel-Macros$$ and the Microsoft MVP award goes to Ashish Koul :)

[Hari]

Thanks for getting the award. Even though, i am very new to this group,
I proudly wishes to keep this spirit high always,
Have a nice day

with best wishes,


Regards,
Hari

On 1 July 2011 21:25, Ayush  wrote:

> Dear Group,
> I am extremely happy to share a good news with you. One of our dearest
> group member 'Ashish Koul' is awarded Microsoft MVP award on 1st July for
> his exceptional MS Excel skills and voluntary contribution.
> He is well deserving for the award and I am very happy and proud of his
> recognition. The guy has been top poster in the group from last 7-8 months.
>  Let see who becomes the next MVP from the group. The group has now three
> active MVPs.
>
> Dear Ashish,
> Many Many congratulations for the award.I am very proud of you to be part
> of this group.
> Keep your valuable contribution to the group. I wish your long association
> with this group.
> Cheers !!
> Best Regards,
> Ayush Jain
> Group Manager
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Yours,

Hari.

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

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

Re: $$Excel-Macros$$ Urgent Help required!!!!!!!!!!

[Dilip Pandey]

Hi Anshul,

As per the latest scenario provided by you, attached solution may help you.
Let me know if this works :)

Regards,
DILIPandey

On 7/4/11, Anshul Gupta  wrote:
> Hi All
>
> No boss this is also not working see i show you what excatly i want
>
> 202.718
> 198.724
> 200.178
> 202.867
> 195.514
> Total 1000.000
>
> this is i want that random unique numbers between 195.001 to 203.999 which
> always gives a total of 1000.000 after every total of 5 numbers
>
> Help me guy
>
> cheers!!!
> On Sun, Jul 3, 2011 at 12:40 PM, Rajan_Verma
> wrote:
>
>>  *See if it help*
>>
>> http://www.mrexcel.com/tip069.shtml
>>
>> ** **
>>
>> * *
>>
>> * *
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *karunanithi ramaswamy
>> *Sent:* Saturday, July 02, 2011 9:29 PM
>>
>> *To:* excel-macros@googlegroups.com
>>  *Subject:* RE: $$Excel-Macros$$ Urgent Help required!!
>>
>>   ** **
>>
>> Sir,
>>   Do u have any idea of auto filling magic squre for a particular sum
>> total.  Iam interested
>> to know it. Thanks if u could help.
>>-R.Karunanithi
>>
>> --- On *Sat, 7/2/11, Rajan_Verma * wrote:
>>
>>
>> From: Rajan_Verma 
>> Subject: RE: $$Excel-Macros$$ Urgent Help required!!
>> To: excel-macros@googlegroups.com
>> Date: Saturday, July 2, 2011, 8:25 PM
>>
>> *See if it helps*
>>
>> * *
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *Anshul Gupta
>> *Sent:* Saturday, July 02, 2011 7:39 PM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ Urgent Help required!!
>>
>>  
>>
>> Hi All.
>>
>> As m working in a import house for that i have to sales bills on daily
>> basis i just want a help that makes me easy to make that
>>
>> If someone tell that how to make 5 random numbers selection between
>> 197.001
>> to 203.999 which gives the total of 1000.000
>>
>> Please help meurgent guys
>>
>> Cheers 
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
> --
> --
> Some important links for

Re: $$Excel-Macros$$ Help what the hell is wrong with my pivot table?

[ashish koul]

have you changed name of a name range used in the formula

On Mon, Jul 4, 2011 at 9:23 PM, Jorge Marques  wrote:

> Hi guys, i have a pivot table that is feeded through another workbook,
> then i calculate the rest of the pivot with the option "Calculated fields"
> but i have a problem, each time i open the 2 workbooks and make refresh, my
> calculated fields disappear leaving "#NAME" in the cells, and i have to do
> the formulas all over again.
>
> Anyone knows what is going on?1000 thanks
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

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

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

RE: $$Excel-Macros$$ need required for data validation value query

[Rajan_Verma]

You should attached all Sheets so that I can Link Main Sheet with each
other.

-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ankur
Sent: Monday, July 04, 2011 2:06 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ need required for data validation value query

Have A Nice Time & Enjoy Life

Regards:
CMA Ankur Pandey
(Someone Different)

I'm not the best but i'm not like the rest~~



On Mon, Jul 4, 2011 at 12:08 PM, ankur  wrote:
> file attachedagain forget to attach file Have A Nice Time & Enjoy 
> Life
>
> Regards:
> CMA Ankur Pandey
> (Someone Different)
>
> I'm not the best but i'm not like the rest~~
>
>
>
> On Mon, Jul 4, 2011 at 11:53 AM, ankur  wrote:
>> thnks rajan this is what i needed
>> this is really very nice of youit ease my work load...
>>
>> now one more queryin attached file...sheet "gents report"cell
>> C2 value should get pasted in sheet "gents"...in the front of row 
>> having staff no..
>>  example is shown..if income tax calculation show "error"...ignore 
>> that data for pasting ..
>>
>> Have A Nice Time & Enjoy Life
>>
>> Regards:
>> CMA Ankur Pandey
>> (Someone Different)
>>
>> I'm not the best but i'm not like the rest~~
>>
>>
>>
>> On Sat, Jul 2, 2011 at 5:40 PM, Rajan_Verma 
wrote:
>>> See if it helps
>>>
>>> -Original Message-
>>> From: excel-macros@googlegroups.com 
>>> [mailto:excel-macros@googlegroups.com]
>>> On Behalf Of ankur
>>> Sent: Friday, July 01, 2011 5:17 PM
>>> To: excel-macros
>>> Subject: Re: $$Excel-Macros$$ need required for data validation 
>>> value query
>>>
>>> sorry , i forget to attach a sample file in my query..
>>> Have A Nice Time & Enjoy Life
>>>
>>> Regards:
>>> CMA Ankur Pandey
>>> (Someone Different)
>>>
>>> I'm not the best but i'm not like the rest~~
>>>
>>>
>>>
>>> On Fri, Jul 1, 2011 at 5:14 PM, ankur  wrote:
 hi ayush/ all members

  i have one data validation list, which is required in formula to 
 get a result i want the all results  corresponding to each 
 value in different sheet or in different column in one click any 
 macro code is there ?

 thanks in advance

 Have A Nice Time & Enjoy Life

 Regards:
 CMA Ankur Pandey
 (Someone Different)

 I'm not the best but i'm not like the rest~~

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

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

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

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

--

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

Re: $$Excel-Macros$$ How Can I Clear Content & Autofill

[ashish koul]

try this see if it helps

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Column = 19 And Target.Count = 1 Then

Select Case Target.Value
Case "A"
Target.EntireRow.Interior.Color = RGB(192, 192, 192)

Case "B"
Target.EntireRow.Interior.Color = RGB(0, 0, 255)

Case "C"
Target.EntireRow.Interior.Color = RGB(255, 255, 0)
Case Else

Target.EntireRow.Interior.Color = xlNone
End Select
End If
End Sub


On Mon, Jul 4, 2011 at 7:51 PM, Ahmed galal  wrote:

>  *Hi all*
> I choose a specific Column Such as X Column and when one cell change it's
> return a value in another cell in another column.
> now i need to make Auto-fill or Clear Content to act on all row content,
> plz see the attachment
>
>
> Best regards,
>
>
>
> *Ahmed galal Mohamed*
>
> Procurement Engineer
>
> Head Office : SQUARE Engineering Firm
> Tel   :(202) 2402 8846
> Fax  :(202) 2405 0476
> Mobile :(010) 9 62 60 61
> Website : http://www.square.com.eg
> 31 Lebanon St. Mohandsen, Giza, Egypt
>
>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

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

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

$$Excel-Macros$$ Help what the hell is wrong with my pivot table?

[Jorge Marques]

Hi guys, i have a pivot table that is feeded through another workbook,
then i calculate the rest of the pivot with the option "Calculated fields"
but i have a problem, each time i open the 2 workbooks and make refresh, my
calculated fields disappear leaving "#NAME" in the cells, and i have to do
the formulas all over again.

Anyone knows what is going on?1000 thanks

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

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

RE: $$Excel-Macros$$ need required for data validation value query

[Rajan_Verma]

Hi ankur
Attachment Not Found..

-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ankur
Sent: Monday, July 04, 2011 11:53 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ need required for data validation value query

thnks rajan this is what i needed
this is really very nice of youit ease my work load...

now one more queryin attached file...sheet "gents report"cell
C2 value should get pasted in sheet "gents"...in the front of row
having staff no..
 example is shown..if income tax calculation show "error"...ignore
that data for pasting ..

Have A Nice Time & Enjoy Life

Regards:
CMA Ankur Pandey
(Someone Different)

I'm not the best but i'm not like the rest~~



On Sat, Jul 2, 2011 at 5:40 PM, Rajan_Verma 
wrote:
> See if it helps
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of ankur
> Sent: Friday, July 01, 2011 5:17 PM
> To: excel-macros
> Subject: Re: $$Excel-Macros$$ need required for data validation value
query
>
> sorry , i forget to attach a sample file in my query..
> Have A Nice Time & Enjoy Life
>
> Regards:
> CMA Ankur Pandey
> (Someone Different)
>
> I'm not the best but i'm not like the rest~~
>
>
>
> On Fri, Jul 1, 2011 at 5:14 PM, ankur  wrote:
>> hi ayush/ all members
>>
>>  i have one data validation list, which is required in formula to get
>> a result i want the all results  corresponding to each value in
>> different sheet or in different column in one click any macro code is
>> there ?
>>
>> thanks in advance
>>
>> Have A Nice Time & Enjoy Life
>>
>> Regards:
>> CMA Ankur Pandey
>> (Someone Different)
>>
>> I'm not the best but i'm not like the rest~~
>>
>> --
>> --
>> 
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip 2. Join our LinkedIN group @
>> http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips
>> and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
> --
>

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

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

-- 

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

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

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

RE: $$Excel-Macros$$ Excel VBA for BOM

[Rajan_Verma]

What help do you need in this macro??

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rash
Sent: Monday, July 04, 2011 10:25 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Excel VBA for BOM

 

Hi,

With some more detailed explanation: 

I have data from col A till Col Y. Columns E to R are of no interest, So I
am hiding those columns. 

 

1. In Column 1 I have pos no 1 to 6. May increase till 1 to 10 in future.
(But these are not always sorted in ascending order, can be jumbled
sometimes like in row 137 to 142. Highlighted in Redcolor)

 

2. Between 1 to 6 in Col A, where ever there is change in component/ Sub
assy in Col S have to be highlighted in some color. Like rows 28 to 33 and
58  to 64, 137 to 142, etc. All Highlighted.

 

Hope this gives better clarification. Please find attached Excel sheet with
highlighted rows. 

 

 

 

 

-- 

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

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

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

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

Re: $$Excel-Macros$$ Recovery plz

[Venkatesan c]

Hi

just install the  software and just open that software and click Remove
Password...Before that you have to open

Locked VBA Book..

-- 
*Best Regards,*
*Venkat*
*
*
On Mon, Jul 4, 2011 at 6:32 PM, Chandra Shekar  wrote:

> How to use this software?
>
> Thanks,
>
> Chandra Shekar B
>
> On Fri, Dec 24, 2010 at 11:56 AM, Venkat  wrote:
>
>> Dear Saijt,
>>
>> Find below Link&Download Software &Install,It may Help you...
>>
>> http://www.excel-tool.com/vbarecovery.html
>>
>> *Best Regards,*
>> **
>> *Venkat CV*
>>
>> On Thu, Dec 23, 2010 at 12:42 PM, Vikas Chouhan wrote:
>>
>>> send ur file
>>>
>>> On Tue, Dec 21, 2010 at 10:45 PM, SAJID MEMON wrote:
>>>
 Dear All,

 I had made a project in excel and some macro made but i had protected
 with password and forget the password.
 How can i recover my VBA password.

 please give me some tips to accomplish my project.

 sajid memon

 --

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

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

 <><><><><><><><><><><><><><><><><><><><><><>
 Like our page on facebook , Just follow below link

 http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

>>>
>>>
>>>
>>> --
>>> One Team One Dream One Goal
>>>
>>> Warm Regards,
>>> *Vikas Chauhan*
>>> E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com,
>>> 9911868518,
>>> "We can't Spell S_*ccess *without U"
>>>
>>> Life is Very beautiful !!!
>>> ¨`•.•´¨) Always
>>> `•.¸(¨`•.•´¨) Keep
>>> (¨`•.•´¨)¸.•´ Smiling!
>>> `•.¸.•´.
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>>
>>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>>
>>
>>
>>
>> --
>> *Best Regards,*
>> *Venkat*
>> ) 91 99414 31925
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>>
>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



*
*
*
*

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

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

RE: $$Excel-Macros$$ Sumif across multiple worksheets

[Susan]

Dilip,

I apologize…… after recalculating my sheets I see that it worked J.

 

Thank you to everyone else..for your insights. 

 

Appreciate it!

 

Sunnie

 

 

 

From: Dilip Pandey [mailto:dilipan...@gmail.com] 
Sent: Monday, July 04, 2011 3:27 AM
To: excel-macros@googlegroups.com
Cc: sunni...@gmail.com
Subject: Re: $$Excel-Macros$$ Sumif across multiple worksheets

 

Hi Susan,

The result calculated is 2 which is correct as only two rows, mentioned
below, are having the results (i.e., 1) as per your criteria :-
row # 5 of sheet1  
row #16  of sheet 2

Now, some of our group members have also provided more power packed
formulas, using which you can get your query resolved.  cheers  :)

Regards
DILIPandey

On Sat, Jul 2, 2011 at 9:52 PM, Susan  wrote:

Hi Dilip,
The formula only returned the first sheet, I need it to sum all sheets
with reference to different ranges for the same criteria , and summing
different ranges.

I tried SUMPRODUCT(SUM(IF...
I tried SUM(IF and inserting a + before each proceeding IF

Neither of those worked.


What about using INDEX?  Thou I am not familiar with that formula...
also, how about VLOOKUP with SUM?

Thanks for your help.  Can you try to fix it again?

Sunnie :-)


On Jun 30, 11:26 pm, Dilip Pandey  wrote:
> Hi Sunnie,
>
> It can be sorted out using simple SUM function.  Look at the below
formula:-
>
>
{=SUM(IF(D2:D6=G3,E2:E6,""),IF(Sheet3!D11:D18=G3,Sheet3!E11:E18,""),IF(Sheet
2!D13:D23=G3,Sheet2!E13:E23,""))}
>
> It is an array formula, hence needs to be entered using key
> combination Ctrl+Shift+Enter.
>
> Nesting can be an issue if you use more references here.
>
> Let me know if this works.
>
> Thanks,
> DILIPandey
>

> On 7/1/11, Susan 1  wrote:
>
>
>
>
>
>
>
>
>
> > Hi,
> > I cannot figure out Excel won't let me select different ranges from
multiple
> > worksheets with same criteria ??
>
> > =SUMIF(D2:D6,"C Wagner",E2:E6)
>
> > This is what I'd like it to do:
>
> > =SUMIF(Sheet1!D2:D6,Sheet3!D11:D18,Sheet2!D13:D23,"C
> > Wagner",Sheet1!E2:E6+Sheet3!E11:E18+Sheet2!E13:E23)
>
> > I receive error:  I've entered few too arguments.
> > I did a search and found out that SUMIF cannot sum across multiple
> > worksheets like SUM can... why?
>
> > Can you help me?  Should I use VLOOKUP with SUM?
>
> > thanks,
> > Sunnie
>
> > --
> >

--
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310

> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com

>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> >http://www.facebook.com/discussexcel
>
> --
> Thanks & Regards,
>
> DILIP KUMAR PANDEY, mvp
>MBA,B.Com(Hons),BCA
> Mobile: +91 9810929744

> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 62, India
>
>  Fall_Session_Data(2).xls
> 68KViewDownload

--


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

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

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




-- 
Thanks & Regards,

DILIP KUMAR PANDEY, mvp  
   MBA,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India

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

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

$$Excel-Macros$$ How Can I Clear Content & Autofill

[Ahmed galal]

Hi allI choose a specific Column Such as X Column and when one cell change it's 
return a value in another cell in another column.now i need to make Auto-fill 
or Clear Content to act on all row content, plz see the attachment



Best regards,

 

Ahmed
galal Mohamed

Procurement
Engineer



Head
Office : SQUARE Engineering Firm

Tel   :(202) 2402 8846

Fax  :(202) 2405 0476

Mobile :(010) 9 62 60 61

Website : http://www.square.com.eg

31 Lebanon St. Mohandsen,
Giza, Egypt

  

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

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


AutoFill.xlsm
Description: Binary data

Re: $$Excel-Macros$$ count unique values

[NOORAIN ANSARI]

try it...

=sum(1/countif(B2:B30,B2:B30)) and press ctrl+shift+Enter

-- 
Thanks & regards,
Noorain Ansari
*http://noorain-ansari.blogspot.com/* 
On Mon, Jul 4, 2011 at 3:47 PM, airen  wrote:

> Hi,
> i want to count unique values in a selection. I got this formula on
> net =SUMPRODUCT((B2:B30<>"")/COUNTIF(B2:B30,B2:B30&"")) but i dont
> know how it works. So please help me understand this formula.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

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

Re: $$Excel-Macros$$ Regarding LME and Commodoties Updation

[ashish koul]

can you share the link

On Mon, Jul 4, 2011 at 12:52 PM, L.K. Modi  wrote:

> Dear Members,
>
> with reference to the above dear member i want a excel sheet. Earlier i
> have downloaded a sheet that updates automatically bse and nse prices.
> Similary is there any way by which when i would run macro the LME prices and
> Commodities Prices update automatically.
> May be its a challenging job because i have earlier asked ther query but no
> reply was there. But group having have people with master mind. Hope they
> wil solve this querry at earliest.
>
>
> Thanking You
>
> Regards
> LKModi
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

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

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

Re: $$Excel-Macros$$ count unique values

[ashish koul]

try this link

http://www.exceltip.com/st/Counting_Unique_Numeric_Values_or_Unique_Data_in_a_List_/818.html


Dave has explained it in detail

On Mon, Jul 4, 2011 at 6:15 PM, Venkatesan c  wrote:

> Hi,
>
> Attach Some data ..and send will try..
>
>
> *Best Regards,*
> *Venkat*
> *
> *
>
>
> On Mon, Jul 4, 2011 at 3:47 PM, airen  wrote:
>
>> Hi,
>> i want to count unique values in a selection. I got this formula on
>> net =SUMPRODUCT((B2:B30<>"")/COUNTIF(B2:B30,B2:B30&"")) but i dont
>> know how it works. So please help me understand this formula.
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *
> *
> *
> *
>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

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

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

Re: $$Excel-Macros$$ querry 5

[ashish koul]

try this

Option Base 1
Sub nemi()
Dim s(5) As String
Dim z As Long
s(1) = "Very Good"

s(2) = "Good"
s(3) = "Better"
s(4) = "Bad"
s(5) = "Very Bad"

For i = 1 To 5


On Error Resume Next
Sheets(1).ShowAllData
z = Sheets(1).Range("f65356").End(xlUp).Row + 1
Sheets(1).Range("$A$3:$e$" &
Sheets(1).Range("a3").End(xlDown).Row).AutoFilter Field:=5, Criteria1:=s(i)

Sheets(1).Range("$A$4:$e$" &
Sheets(1).Range("a3").End(xlDown).Row).SpecialCells(xlCellTypeVisible).Copy

Sheets(1).Range("f" & z).Select

ActiveSheet.Paste
Next i

End Sub


On Mon, Jul 4, 2011 at 6:54 PM, ankur  wrote:

> hi Nemi Gandhi
> use this formula in cell F4 of your table and than sort it by column F
> shortest to largestyou will  table as per your need
>
> *=IF(E4="Very Good",1,IF(E4="Good",2,IF(E4="Better",3,IF(E4="Bad",4,5*
>
> Have A Nice Time & Enjoy Life
>
> Regards:
> CMA Ankur Pandey
> (Someone Different)
>
> I'm not the best but i'm not like the rest~~
>
>
>
>
> On Mon, Jul 4, 2011 at 5:04 PM, Nemi Gandhi  wrote:
> > Formula needed please.
> >
> > --
> > Nemi Gandhi
> > 98204 92963
> >
> > --
> >
> --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> > http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials at http://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> >
> > To post to this group, send email to excel-macros@googlegroups.com
> >
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> > http://www.facebook.com/discussexcel
> >
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

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

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

Re: $$Excel-Macros$$ Sumif across multiple worksheets

[Dilip Pandey]

No worries Susan... you are always welcome..!!

Regards,
DILIPandey


On 7/4/11, Susan  wrote:
> Dilip,
>
> I apologize…… after recalculating my sheets I see that it worked J.
>
>
>
> Thank you to everyone else..for your insights.
>
>
>
> Appreciate it!
>
>
>
> Sunnie
>
>
>
>
>
>
>
> From: Dilip Pandey [mailto:dilipan...@gmail.com]
> Sent: Monday, July 04, 2011 3:27 AM
> To: excel-macros@googlegroups.com
> Cc: sunni...@gmail.com
> Subject: Re: $$Excel-Macros$$ Sumif across multiple worksheets
>
>
>
> Hi Susan,
>
> The result calculated is 2 which is correct as only two rows, mentioned
> below, are having the results (i.e., 1) as per your criteria :-
> row # 5 of sheet1
> row #16  of sheet 2
>
> Now, some of our group members have also provided more power packed
> formulas, using which you can get your query resolved.  cheers  :)
>
> Regards
> DILIPandey
>
> On Sat, Jul 2, 2011 at 9:52 PM, Susan  wrote:
>
> Hi Dilip,
> The formula only returned the first sheet, I need it to sum all sheets
> with reference to different ranges for the same criteria , and summing
> different ranges.
>
> I tried SUMPRODUCT(SUM(IF...
> I tried SUM(IF and inserting a + before each proceeding IF
>
> Neither of those worked.
>
>
> What about using INDEX?  Thou I am not familiar with that formula...
> also, how about VLOOKUP with SUM?
>
> Thanks for your help.  Can you try to fix it again?
>
> Sunnie :-)
>
>
> On Jun 30, 11:26 pm, Dilip Pandey  wrote:
>> Hi Sunnie,
>>
>> It can be sorted out using simple SUM function.  Look at the below
> formula:-
>>
>>
> {=SUM(IF(D2:D6=G3,E2:E6,""),IF(Sheet3!D11:D18=G3,Sheet3!E11:E18,""),IF(Sheet
> 2!D13:D23=G3,Sheet2!E13:E23,""))}
>>
>> It is an array formula, hence needs to be entered using key
>> combination Ctrl+Shift+Enter.
>>
>> Nesting can be an issue if you use more references here.
>>
>> Let me know if this works.
>>
>> Thanks,
>> DILIPandey
>>
>
>> On 7/1/11, Susan 1  wrote:
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> > Hi,
>> > I cannot figure out Excel won't let me select different ranges from
> multiple
>> > worksheets with same criteria ??
>>
>> > =SUMIF(D2:D6,"C Wagner",E2:E6)
>>
>> > This is what I'd like it to do:
>>
>> > =SUMIF(Sheet1!D2:D6,Sheet3!D11:D18,Sheet2!D13:D23,"C
>> > Wagner",Sheet1!E2:E6+Sheet3!E11:E18+Sheet2!E13:E23)
>>
>> > I receive error:  I've entered few too arguments.
>> > I did a search and found out that SUMIF cannot sum across multiple
>> > worksheets like SUM can... why?
>>
>> > Can you help me?  Should I use VLOOKUP with SUM?
>>
>> > thanks,
>> > Sunnie
>>
>> > --
>> >
> 
> --
>> > Some important links for excel users:
>> > 1. Follow us on TWITTER for tips tricks and links :
>> >http://twitter.com/exceldailytip
>> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
>
>> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
>> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
>> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
>>
>> > To post to this group, send email to excel-macros@googlegroups.com
>>
>> > <><><><><><><><><><><><><><><><><><><><><><>
>> > Like our page on facebook , Just follow below link
>> >http://www.facebook.com/discussexcel
>>
>> --
>> Thanks & Regards,
>>
>> DILIP KUMAR PANDEY, mvp
>>MBA,B.Com(Hons),BCA
>> Mobile: +91 9810929744
>
>> dilipan...@gmail.com
>> dilipan...@yahoo.com
>> New Delhi - 62, India
>>
>>  Fall_Session_Data(2).xls
>> 68KViewDownload
>
> --
>
> 
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
>
>
>
> --
> Thanks & Regards,
>
> DILIP KUMAR PANDEY, mvp
>MBA,B.Com(Hons),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 62, India
>
>


-- 
Thanks & Regards,

DILIP KUMAR PANDEY, mvp
   MBA,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India

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

Re: $$Excel-Macros$$ Urgent Help required!!!!!!!!!!

[Anshul Gupta]

Hi All

No boss this is also not working see i show you what excatly i want

202.718
198.724
200.178
202.867
195.514
Total 1000.000

this is i want that random unique numbers between 195.001 to 203.999 which
always gives a total of 1000.000 after every total of 5 numbers

Help me guy

cheers!!!
On Sun, Jul 3, 2011 at 12:40 PM, Rajan_Verma wrote:

>  *See if it help*
>
> http://www.mrexcel.com/tip069.shtml
>
> ** **
>
> * *
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *karunanithi ramaswamy
> *Sent:* Saturday, July 02, 2011 9:29 PM
>
> *To:* excel-macros@googlegroups.com
>  *Subject:* RE: $$Excel-Macros$$ Urgent Help required!!
>
>   ** **
>
> Sir,
>   Do u have any idea of auto filling magic squre for a particular sum
> total.  Iam interested
> to know it. Thanks if u could help.
>-R.Karunanithi
>
> --- On *Sat, 7/2/11, Rajan_Verma * wrote:
>
>
> From: Rajan_Verma 
> Subject: RE: $$Excel-Macros$$ Urgent Help required!!
> To: excel-macros@googlegroups.com
> Date: Saturday, July 2, 2011, 8:25 PM
>
> *See if it helps*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Anshul Gupta
> *Sent:* Saturday, July 02, 2011 7:39 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Urgent Help required!!
>
>  
>
> Hi All.
>
> As m working in a import house for that i have to sales bills on daily
> basis i just want a help that makes me easy to make that
>
> If someone tell that how to make 5 random numbers selection between 197.001
> to 203.999 which gives the total of 1000.000
>
> Please help meurgent guys
>
> Cheers 
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

Re: $$Excel-Macros$$ Recovery plz

[Chandra Shekar]

How to use this software?

Thanks,

Chandra Shekar B

On Fri, Dec 24, 2010 at 11:56 AM, Venkat  wrote:

> Dear Saijt,
>
> Find below Link&Download Software &Install,It may Help you...
>
> http://www.excel-tool.com/vbarecovery.html
>
> *Best Regards,*
> **
> *Venkat CV*
>
> On Thu, Dec 23, 2010 at 12:42 PM, Vikas Chouhan wrote:
>
>> send ur file
>>
>> On Tue, Dec 21, 2010 at 10:45 PM, SAJID MEMON wrote:
>>
>>> Dear All,
>>>
>>> I had made a project in excel and some macro made but i had protected
>>> with password and forget the password.
>>> How can i recover my VBA password.
>>>
>>> please give me some tips to accomplish my project.
>>>
>>> sajid memon
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>>
>>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>>
>>
>>
>>
>> --
>> One Team One Dream One Goal
>>
>> Warm Regards,
>> *Vikas Chauhan*
>> E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com,
>> 9911868518,
>> "We can't Spell S_*ccess *without U"
>>
>> Life is Very beautiful !!!
>> ¨`•.•´¨) Always
>> `•.¸(¨`•.•´¨) Keep
>> (¨`•.•´¨)¸.•´ Smiling!
>> `•.¸.•´.
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>>
>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>
>
>
> --
> *Best Regards,*
> *Venkat*
> ) 91 99414 31925
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

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

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

$$Excel-Macros$$ XBRL in Excel

[tikku]

Dear All,

Did anybody build a XBRL Creator in Excel to create a Instance
Documents for MCA filings.

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

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

Re: $$Excel-Macros$$ count unique values

[Venkatesan c]

Hi,

Attach Some data ..and send will try..


*Best Regards,*
*Venkat*
*
*


On Mon, Jul 4, 2011 at 3:47 PM, airen  wrote:

> Hi,
> i want to count unique values in a selection. I got this formula on
> net =SUMPRODUCT((B2:B30<>"")/COUNTIF(B2:B30,B2:B30&"")) but i dont
> know how it works. So please help me understand this formula.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*
*
*
*

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

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

$$Excel-Macros$$ XBRL in Excel

[Tarun Masani]

Dear All,

Did anybody build a XBRL Creator in Excel to create a Instance Documents for
MCA filings.

- Tarun Masani

-- 
Virus Warning: Although our firm has taken reasonable precautions to ensure
no viruses are present in this email, the firm cannot accept responsibility
for any loss or damage arising from the use of this email or attachment."

Always Welcome Others .. To Find Out Your Mistake, That Make you
Expert. –  Tarun Masani

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

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

Re: $$Excel-Macros$$ querry 5

[ankur]

hi Nemi Gandhi
use this formula in cell F4 of your table and than sort it by column F
shortest to largestyou will  table as per your need

*=IF(E4="Very Good",1,IF(E4="Good",2,IF(E4="Better",3,IF(E4="Bad",4,5*

Have A Nice Time & Enjoy Life

Regards:
CMA Ankur Pandey
(Someone Different)

I'm not the best but i'm not like the rest~~



On Mon, Jul 4, 2011 at 5:04 PM, Nemi Gandhi  wrote:
> Formula needed please.
>
> --
> Nemi Gandhi
> 98204 92963
>
> --
>
--
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

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

$$Excel-Macros$$ querry 5

[Nemi Gandhi]

Formula needed please.

-- 
Nemi Gandhi
98204 92963

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

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


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

$$Excel-Macros$$ count unique values

[airen]

Hi,
i want to count unique values in a selection. I got this formula on
net =SUMPRODUCT((B2:B30<>"")/COUNTIF(B2:B30,B2:B30&"")) but i dont
know how it works. So please help me understand this formula.

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

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

Re: $$Excel-Macros$$ Sumif across multiple worksheets

[Dilip Pandey]

Hi Susan,

The result calculated is 2 which is correct as only two rows, mentioned
below, are having the results (i.e., 1) as per your criteria :-
row # 5 of sheet1
row #16  of sheet 2

Now, some of our group members have also provided more power packed
formulas, using which you can get your query resolved.  cheers  :)

Regards
DILIPandey

On Sat, Jul 2, 2011 at 9:52 PM, Susan  wrote:

> Hi Dilip,
> The formula only returned the first sheet, I need it to sum all sheets
> with reference to different ranges for the same criteria , and summing
> different ranges.
>
> I tried SUMPRODUCT(SUM(IF...
> I tried SUM(IF and inserting a + before each proceeding IF
>
> Neither of those worked.
>
>
> What about using INDEX?  Thou I am not familiar with that formula...
> also, how about VLOOKUP with SUM?
>
> Thanks for your help.  Can you try to fix it again?
>
> Sunnie :-)
>
> On Jun 30, 11:26 pm, Dilip Pandey  wrote:
> > Hi Sunnie,
> >
> > It can be sorted out using simple SUM function.  Look at the below
> formula:-
> >
> >
> {=SUM(IF(D2:D6=G3,E2:E6,""),IF(Sheet3!D11:D18=G3,Sheet3!E11:E18,""),IF(Sheet2!D13:D23=G3,Sheet2!E13:E23,""))}
> >
> > It is an array formula, hence needs to be entered using key
> > combination Ctrl+Shift+Enter.
> >
> > Nesting can be an issue if you use more references here.
> >
> > Let me know if this works.
> >
> > Thanks,
> > DILIPandey
> >
> > On 7/1/11, Susan 1  wrote:
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > > Hi,
> > > I cannot figure out Excel won't let me select different ranges from
> multiple
> > > worksheets with same criteria ??
> >
> > > =SUMIF(D2:D6,"C Wagner",E2:E6)
> >
> > > This is what I'd like it to do:
> >
> > > =SUMIF(Sheet1!D2:D6,Sheet3!D11:D18,Sheet2!D13:D23,"C
> > > Wagner",Sheet1!E2:E6+Sheet3!E11:E18+Sheet2!E13:E23)
> >
> > > I receive error:  I've entered few too arguments.
> > > I did a search and found out that SUMIF cannot sum across multiple
> > > worksheets like SUM can... why?
> >
> > > Can you help me?  Should I use VLOOKUP with SUM?
> >
> > > thanks,
> > > Sunnie
> >
> > > --
> > >
> --
> > > Some important links for excel users:
> > > 1. Follow us on TWITTER for tips tricks and links :
> > >http://twitter.com/exceldailytip
> > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
> >
> > > To post to this group, send email to excel-macros@googlegroups.com
> >
> > > <><><><><><><><><><><><><><><><><><><><><><>
> > > Like our page on facebook , Just follow below link
> > >http://www.facebook.com/discussexcel
> >
> > --
> > Thanks & Regards,
> >
> > DILIP KUMAR PANDEY, mvp
> >MBA,B.Com(Hons),BCA
> > Mobile: +91 9810929744
> > dilipan...@gmail.com
> > dilipan...@yahoo.com
> > New Delhi - 62, India
> >
> >  Fall_Session_Data(2).xls
> > 68KViewDownload
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Thanks & Regards,

DILIP KUMAR PANDEY, mvp
   MBA,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India

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

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

$$Excel-Macros$$ Regarding LME and Commodoties Updation

[L.K. Modi]

Dear Members,

with reference to the above dear member i want a excel sheet. Earlier i have
downloaded a sheet that updates automatically bse and nse prices. Similary
is there any way by which when i would run macro the LME prices and
Commodities Prices update automatically.
May be its a challenging job because i have earlier asked ther query but no
reply was there. But group having have people with master mind. Hope they
wil solve this querry at earliest.


Thanking You

Regards
LKModi

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

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

Re: $$Excel-Macros$$ need required for data validation value query

[ankur]

Have A Nice Time & Enjoy Life

Regards:
CMA Ankur Pandey
(Someone Different)

I'm not the best but i'm not like the rest~~



On Mon, Jul 4, 2011 at 12:08 PM, ankur  wrote:
> file attachedagain forget to attach file
> Have A Nice Time & Enjoy Life
>
> Regards:
> CMA Ankur Pandey
> (Someone Different)
>
> I'm not the best but i'm not like the rest~~
>
>
>
> On Mon, Jul 4, 2011 at 11:53 AM, ankur  wrote:
>> thnks rajan this is what i needed
>> this is really very nice of youit ease my work load...
>>
>> now one more queryin attached file...sheet "gents report"cell
>> C2 value should get pasted in sheet "gents"...in the front of row
>> having staff no..
>>  example is shown..if income tax calculation show "error"...ignore
>> that data for pasting ..
>>
>> Have A Nice Time & Enjoy Life
>>
>> Regards:
>> CMA Ankur Pandey
>> (Someone Different)
>>
>> I'm not the best but i'm not like the rest~~
>>
>>
>>
>> On Sat, Jul 2, 2011 at 5:40 PM, Rajan_Verma  wrote:
>>> See if it helps
>>>
>>> -Original Message-
>>> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
>>> On Behalf Of ankur
>>> Sent: Friday, July 01, 2011 5:17 PM
>>> To: excel-macros
>>> Subject: Re: $$Excel-Macros$$ need required for data validation value query
>>>
>>> sorry , i forget to attach a sample file in my query..
>>> Have A Nice Time & Enjoy Life
>>>
>>> Regards:
>>> CMA Ankur Pandey
>>> (Someone Different)
>>>
>>> I'm not the best but i'm not like the rest~~
>>>
>>>
>>>
>>> On Fri, Jul 1, 2011 at 5:14 PM, ankur  wrote:
 hi ayush/ all members

  i have one data validation list, which is required in formula to get
 a result i want the all results  corresponding to each value in
 different sheet or in different column in one click any macro code is
 there ?

 thanks in advance

 Have A Nice Time & Enjoy Life

 Regards:
 CMA Ankur Pandey
 (Someone Different)

 I'm not the best but i'm not like the rest~~

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

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

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

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

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

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


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

Re: $$Excel-Macros$$ Protect : Charts, Shapes & Data

[Chandra Shekar]

Hi,
Please can u expalin in steps how to do this. Thanks!


On Tue, Jun 28, 2011 at 9:08 AM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:

> Hi,
>
> Thanks its working fine. Please can u explain in steps how to do this.
>
>   On Mon, Jun 27, 2011 at 6:59 PM, Sam Mathai Chacko 
> wrote:
>
>> Hi, please find attached the sample file
>>
>>   On Mon, Jun 27, 2011 at 12:17 PM, Chandra Shekar <
>> chandrashekarb@gmail.com> wrote:
>>
>>>  I did as per insturction still I can able to access button. Please can
>>> u send the file. Thanks!
>>>
>>>  On Fri, Jun 24, 2011 at 9:38 PM, GoldenLance wrote:
>>>
 I am blocked from attaching a file I guess. Not sure why.

 So here's how you do it.

 1. Hold CTRL and right-click on the button shape as well as the chart.
 Go to format and properties, and then uncheck the lock
 2. After deselecting the shapes, select only the button, again go to
 format and properties, and the CHECK the lock
 3. Select the data range of the chart. Right-click, and in the
 properties, UNCHECK the lock
 4. Now protect the sheet

 On Jun 24, 11:24 am, Chandra Shekar 
 wrote:
 > Any Ideas please. Thanks!
 >
 > On Wed, Jun 22, 2011 at 11:12 AM, Chandra Shekar <
 >
 >
 >
 >
 >
 >
 >
 > chandrashekarb@gmail.com> wrote:
 > > Hi Ashish,
 >
 > > Thanks for the reply. Still user can edit and change text or assign
 a new
 > > macro the textbox, but I want user not to edit text box and assign
 new macro
 > > to it. Just he need to click on that to generate reports. Thanks!
 >
 > >   On Tue, Jun 21, 2011 at 9:20 PM, ashish koul <
 koul.ash...@gmail.com>wrote:
 >
 > >> Try this
 > >> right click on image and chooze size and property the select don't
 move or
 > >> size with cells
 >
 > >> [image: image.png]
 >
 > >> On Tue, Jun 21, 2011 at 5:02 PM, Chandra Shekar <
 > >> chandrashekarb@gmail.com> wrote:
 >
 > >>> Hi,
 >
 > >>> In sheet1 how to protect shape("Click here to Generate Report")
 only. I
 > >>> need complete access to graph and data.
 >
 > >>> Thanks,
 >
 > >>> Chandra Shekar
 >
 > >>> --
 >
 > >>>
 --
 > >>> Some important links for excel users:
 > >>> 1. Follow us on TWITTER for tips tricks and links :
 > >>>http://twitter.com/exceldailytip
 > >>> 2. Join our LinkedIN group @
 http://www.linkedin.com/groups?gid=1871310
 > >>> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
 > >>> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
 > >>> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
 >
 > >>> To post to this group, send email to
 excel-macros@googlegroups.com
 >
 > >>> <><><><><><><><><><><><><><><><><><><><><><>
 > >>> Like our page on facebook , Just follow below link
 > >>>http://www.facebook.com/discussexcel
 >
 > >> --
 > >> *Regards*
 > >> * *
 > >> *Ashish Koul*
 > >> *akoul*.*blogspot*.com 
 > >>http://akoul.posterous.com/
 > >> *akoul*.wordpress.com 
 > >> My Linkedin Profile <
 http://in.linkedin.com/pub/ashish-koul/10/400/830>
 >
 > >> P Before printing, think about the environment.
 >
 > >>   --
 >
 > >>
 --
 > >> Some important links for excel users:
 > >> 1. Follow us on TWITTER for tips tricks and links :
 > >>http://twitter.com/exceldailytip
 > >> 2. Join our LinkedIN group @
 http://www.linkedin.com/groups?gid=1871310
 > >> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
 > >> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
 > >> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
 >
 > >> To post to this group, send email to excel-macros@googlegroups.com
 >
 > >> <><><><><><><><><><><><><><><><><><><><><><>
 > >> Like our page on facebook , Just follow below link
 > >>http://www.facebook.com/discussexcel
 >
 >
 >
 >  image.png
 > 44KViewDownload

 --

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

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

 <><><><><><><><><><><><>

Re: $$Excel-Macros$$ Excel Pop-ups

[Mahreen Ellahi]

Thanks  all, it worked.

Regards

On Sun, Jul 3, 2011 at 11:54 PM, STDEV(i)  wrote:

> please try:
> =
>  Sub ExpiryWarning()
> Dim dTable As Range, t As String
>Dim R As Long, N As Long, *I As Date*
>
>Set dTable = Cells(1).CurrentRegion
>N = dTable.Rows.Count
>
>For R = 2 To N
>   If IsDate(dTable(R, 14)) Then
>  I = dTable(R, 14) - Date
>  If I <= 15 Then
>  If I > 0 Then
>  dTable(R, 1).Resize(1, dTable.Columns.Count).Select
>  t = "Name  : " & dTable(R, 4) & vbCr & vbCr
> t = t & "Expiry Date : " & Format(dTable(R, 14), "dd-mmm-")
> & vbCr & vbCr
> t = t & "Number of days to expire : " & Format(I, "0") & vbCr
>  MsgBox t, 48, "Warning"
>  End If
>  End If
>   End If
>Next
> Cells(1).Activate
> End Sub
> =
>
>
> On Sun, Jul 3, 2011 at 7:16 PM, Mahreen Ellahi 
> wrote:
>
>> Hiii
>>
>> Thanks to ST Devi, I have reached up to this level , but the code shows
>> some error now. Can anybody plz help me out.
>>
>> Regards
>>
>>  -- Forwarded message --
>> From: Mahreen Ellahi 
>> Date: Sat, Jun 18, 2011 at 10:25 PM
>> Subject: $$Excel-Macros$$ Excel Pop-ups
>> To: excel-macros@googlegroups.com
>>
>>
>>  Hii
>>
>> I have a some data with limits expiry on different dates. I want to have
>> popup window to appear whenever the limit is about to expire like 15 to 30
>> days earlier. Can anyone help me for VBA coding.
>>
>> Regards
>> Mahreen
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>

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

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