date:20101008

Re: $$Excel-Macros$$ How to find consodated sale data of previous 3 months

2010-10-08 Thread SUMIT VYAS

Dear

one colum set structure :- month = jan-2008  jan-2009 jan-2010

then use use pivot table

On Sat, Oct 9, 2010 at 10:34 AM, Kal xcel  wrote:

> Hi Worawat,
>
> Thanks for your advice. But I can't use pivot table in this scenario.
> Because lot of other issues attached with this.
>
> Thanks
>
> Kalyan
>
> On Sat, Oct 9, 2010 at 3:43 AM, worawat kh  wrote:
>
>> Hi Kalyan
>>
>> You can use pivot table to solve this ,
>> better than use many excel function
>>
>>
>> Worawat
>>
>> 2010/10/8, Kal xcel :
>>  > Dear Experts,
>> >
>> > I want to extract last 3 months consolidated sale data based on current
>> > month.
>> >
>> > I have attached the file with my query.
>> >
>> > Thanks in advance
>> >
>> > Kalyan
>> >
>> > --
>> >
>> --
>> > 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
>> >
>>
>>
>> --
>>
>>
>>
>>
>> Moo Moo'
>> I have much time for give you
>>
>> --
>>
>> --
>> 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/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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Re: How to find consodated sale data of previous 3 months

2010-10-08 Thread Kal xcel

Thanks Alpesh,

Got the file, checking.

Thanks once again

Kalyan

On Sat, Oct 9, 2010 at 10:38 AM, Kal xcel  wrote:

> Hi Alpesh,
>
> please help me that how to get that file.
>
> Thanks
>
> Kalyan
>
>   On Sat, Oct 9, 2010 at 6:57 AM, pesh  wrote:
>
>> Kalyan,
>>
>> Please find the file: How+to+find+data+of+previous+month.xlsx uploaded
>> to the Files section of this group.
>> I believe it should meet your needs.
>>
>> Thanks.
>> Alpesh
>>
>> On Oct 8, 4:38 am, Kal xcel  wrote:
>> > Dear Experts,
>> >
>> > I want to extract last 3 months consolidated sale data based on current
>> > month.
>> >
>> > I have attached the file with my query.
>> >
>> > Thanks in advance
>> >
>> > Kalyan
>> >
>> >  How to find data of previous month.xlsx
>> > 360KViewDownload
>>
>> --
>>
>> --
>> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Re: How to find consodated sale data of previous 3 months

2010-10-08 Thread Kal xcel

Hi Alpesh,

please help me that how to get that file.

Thanks

Kalyan

On Sat, Oct 9, 2010 at 6:57 AM, pesh  wrote:

> Kalyan,
>
> Please find the file: How+to+find+data+of+previous+month.xlsx uploaded
> to the Files section of this group.
> I believe it should meet your needs.
>
> Thanks.
> Alpesh
>
> On Oct 8, 4:38 am, Kal xcel  wrote:
> > Dear Experts,
> >
> > I want to extract last 3 months consolidated sale data based on current
> > month.
> >
> > I have attached the file with my query.
> >
> > Thanks in advance
> >
> > Kalyan
> >
> >  How to find data of previous month.xlsx
> > 360KViewDownload
>
> --
>
> --
> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ How to find consodated sale data of previous 3 months

2010-10-08 Thread Kal xcel

Hi Worawat,

Thanks for your advice. But I can't use pivot table in this scenario.
Because lot of other issues attached with this.

Thanks

Kalyan

On Sat, Oct 9, 2010 at 3:43 AM, worawat kh  wrote:

> Hi Kalyan
>
> You can use pivot table to solve this ,
> better than use many excel function
>
>
> Worawat
>
> 2010/10/8, Kal xcel :
>  > Dear Experts,
> >
> > I want to extract last 3 months consolidated sale data based on current
> > month.
> >
> > I have attached the file with my query.
> >
> > Thanks in advance
> >
> > Kalyan
> >
> > --
> >
> --
> > 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
> >
>
>
> --
>
>
>
>
> Moo Moo'
> I have much time for give you
>
> --
>
> --
> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Job Opening for Excel and VBA

2010-10-08 Thread SUMIT VYAS

Dear Ayush,


Thanks for you,

1) excel group
2) help all time
3) touch you every
4) help find job


you are great person in this world.


regard

Sumit Vyas



On Fri, Oct 8, 2010 at 9:20 PM, Ayush  wrote:

> Dear Group,
>
> There is a opening for one person with the following skill to work as
> Sub contractor.
>
> Basic Skill set: (Mandatory) Advance knowledge of xl and VBA Marco
> Advance Skill Set: (Optional) Exposure to PM methodology & Quality
> Systems
>
> Qualifications: MCA/BE
>
> Company Name :- STMicroelectronics
> Location :- Greater Noida
> Job Type :- Contractual.
>
> Please let me know if somebody known to you is interested.
> Send me the resume at jainayus...@gmail.com.
>
> Thanks.
>
> 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/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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Re: How to find consodated sale data of previous 3 months

2010-10-08 Thread pesh

Kalyan,

Please find the file: How+to+find+data+of+previous+month.xlsx uploaded
to the Files section of this group.
I believe it should meet your needs.

Thanks.
Alpesh

On Oct 8, 4:38 am, Kal xcel  wrote:
> Dear Experts,
>
> I want to extract last 3 months consolidated sale data based on current
> month.
>
> I have attached the file with my query.
>
> Thanks in advance
>
> Kalyan
>
>  How to find data of previous month.xlsx
> 360KViewDownload

-- 
--
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

Re: $$Excel-Macros$$ How to find consodated sale data of previous 3 months

2010-10-08 Thread worawat kh

Hi Kalyan

You can use pivot table to solve this ,
better than use many excel function


Worawat

2010/10/8, Kal xcel :
> Dear Experts,
>
> I want to extract last 3 months consolidated sale data based on current
> month.
>
> I have attached the file with my query.
>
> Thanks in advance
>
> Kalyan
>
> --
> --
> 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
>


-- 




Moo Moo'
I have much time for give you

-- 
--
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

$$Excel-Macros$$ Getting a cell value to change when it is in an Indirect function

2010-10-08 Thread David Stubbs

Hi Guys,

So I a simple indirect function that looks into another file (the name
of which is in my sheet in cell I1) and find the value in cell A3 of
the sheet in that file called Output. This is that function:

=INDIRECT("["&$I$1&".xls]Output!A3")

However, when i drag this formula down the reference A3 remains the
same instead of become A4, A5 etc etc, as the formula is dragged down.
How can i modify my formula so when i drag it across and down the A3
reference section changes accordingly?

Any help is gratefully appreciated

David

-- 
--
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

Re: $$Excel-Macros$$ dynamic range (table_array) in vlookup formule

2010-10-08 Thread Ramkesh Maurya

Dear Carlo,

Select Range Q:R i.e. both entire col and vlookup is enough

Regards
Ramkesh

On Thu, Oct 7, 2010 at 5:48 PM, cg  wrote:

> Hi everybody
> I’ve a big trouble but maybe, for you is an easy trouble.
>
> I’m working on excel2003.
> I’ve to compare two values, in the same pivot table, using vlookup.
> My problem is that, the table_array, must be dynamic.
> Sometimes the range is: SheetTest!$Q$1:$R$10; other times, could be !$Q
> $70:$R$100 or other..
> How can I create dinamically the range “SheetTest!$Q$1:$R$10” in the
> VLOOKUP formule?
> I tried to use =INDIRECT(“SheetTest!$Q$1);
> The problem is how to write the “:” ecc…
> VLOOKUP(“test”; INDIRECT(“SheetTest!” & $Q$1): INDIRECT(“SheetTest!” &
> $Q$1)…..;)
> But it’s wrong.
> How can I do?
> Many thanks
> Carlo
>
> --
>
> --
> 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
>



-- 

Ramkesh
9990260398

-- 
--
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

$$Excel-Macros$$ Re: Losing weight

2010-10-08 Thread fill brain

hi sir,

i think you can't find solution that problem by excel..:)) (mmm...
maybe your finger can lose a little weight) but i can advice to you
zumba...:))
it will be more useful than excel.

ohh and i have a problem with my hair.. i am starting to lose it.. if
someone have any excel program.. about that...

-- 
--
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

$$Excel-Macros$$ Job Opening for Excel and VBA

2010-10-08 Thread Ayush

Dear Group,

There is a opening for one person with the following skill to work as
Sub contractor.

Basic Skill set: (Mandatory) Advance knowledge of xl and VBA Marco
Advance Skill Set: (Optional) Exposure to PM methodology & Quality
Systems

Qualifications: MCA/BE

Company Name :- STMicroelectronics
Location :- Greater Noida
Job Type :- Contractual.

Please let me know if somebody known to you is interested.
Send me the resume at jainayus...@gmail.com.

Thanks.

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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ DELETE OF A VALUE DELTES THAT FROM EVERY SHEET

2010-10-08 Thread krishna mummina

Hey Dude,

Do this,

Select the Cell which you want to delete and Ctrl+Select Every Sheet, then
press Delete.

I hope it will helpful.

Regards,
Krrish

On Fri, Oct 8, 2010 at 6:40 PM, sudheer lolla  wrote:

> Hi guys
>
> I Have a column "xyz"  which is there in every sheet of the workbook
> and the column number in sheet A is 1 ,sheet B is 2,sheet C is 1
>
> If i delete a value from that column "xyz" in sheet A,the deleted cell has
> to be deleted from these B,C sheets
> But the vice-versa should not happen i.e Delete of a cell in column "xyz"
> of sheet B or C should not delete from A
> For me sheet A is a base sheet
>
>
> "DELETE REFLECTS ALL SHEETS IS WHAT I NEEDED"
>
> I will be very thankful to this community if i get some answer.
>
> Thanks
> sudheer.L
>
> --
>
> --
> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Losing weight

2010-10-08 Thread Shimmy

Hi Excellers, I am having a problem, I am trying to lose some weight,
it is for tha reason that I would like to request anyone of you to
send me a template that I can use to check my weight, either in excel
of access format- diet tips could come in handy alongside that
template. Preferably the tips should be in either PDF format or on a
word processor.

Your  help in this regard would come in handy.

Thank you in advance!

-- 
--
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

Re: $$Excel-Macros$$ Column hide from excel

2010-10-08 Thread Vishal Angre

Thank you

On Fri, Oct 8, 2010 at 6:07 PM, عمر  wrote:

>  See this
>
> http://www.youtube.com/watch?v=CrX6353lSx4
>
>
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-mac...@googlegroups.com] *On Behalf Of *Vishal Angre
> *Sent:* Friday, October 08, 2010 12:34 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Column hide from excel
>
>
>
>
>
> 4 column(A,B,C,D) in atteched excel,  please tell me how to do this
> --
> With Regards,
> *Vishal K. Angre*
> E-mail :  visha...@gmail.com
>  vishal.k.an...@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/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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>



-- 
Thanking You

Vishal K. Angre

-- 
--
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

$$Excel-Macros$$ HELP

2010-10-08 Thread abhishek krishna

Hi Guys,

I am running a variance between two numbers and am unable to get the proper 
condition required.

In the file attached in Clmn E it is working correct if there are numbers in 
Clmn B. But if B is zero then the formula should show a red arrow (if there is 
a number in Clmn A)


Hope someone can help.

Thanks in advance

Thanks 
Abhishek


-- 
--
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


file.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ DELETE OF A VALUE DELTES THAT FROM EVERY SHEET

2010-10-08 Thread sudheer lolla

Hi guys

I Have a column "xyz"  which is there in every sheet of the workbook
and the column number in sheet A is 1 ,sheet B is 2,sheet C is 1

If i delete a value from that column "xyz" in sheet A,the deleted cell has
to be deleted from these B,C sheets
But the vice-versa should not happen i.e Delete of a cell in column "xyz" of
sheet B or C should not delete from A
For me sheet A is a base sheet


"DELETE REFLECTS ALL SHEETS IS WHAT I NEEDED"

I will be very thankful to this community if i get some answer.

Thanks
sudheer.L

-- 
--
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

Re: $$Excel-Macros$$ Column hide from excel

2010-10-08 Thread Vishal Angre

Dear Sumit

only  4 column(A,B,C,D) in atteched excel  how to hide column E,F,H.

thank & regard

Vishal

On Fri, Oct 8, 2010 at 5:08 PM, SUMIT VYAS  wrote:

> Dear Vishal
>
> This trick is VBA inst log file.
>
>
> Private Sub Worksheet_Change(ByVal Target As Range)
> If Target.Cells.Count = 1 Then
> If Target.Value <> "" Then
> If Target.Column = 3 And Target.Row > 1 Then
> Target(1, -1) = Format(Now, "dd-mmm- hh:mm:ss")
> Target(1, 0) = Application.UserName
> End If
> End If
> End If
> End Sub
>
> But One Bug :-modify data any time change your log
>
> sugg :- please enter option on entry then enter protect row
>
>
> Thanks 7 Regards
>
> Sumit
>
>
>
>
> On Fri, Oct 8, 2010 at 4:03 PM, Vishal Angre wrote:
>
>>
>>
>> 4 column(A,B,C,D) in atteched excel,  please tell me how to do this
>> --
>> With Regards,
>> *Vishal K. Angre*
>> E-mail :  visha...@gmail.com
>>  vishal.k.an...@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/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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>



-- 
Thanking You

Vishal K. Angre

-- 
--
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

RE: $$Excel-Macros$$ Column hide from excel

2010-10-08 Thread عمر

See this

http://www.youtube.com/watch?v=CrX6353lSx4

 

 

From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Vishal Angre
Sent: Friday, October 08, 2010 12:34 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Column hide from excel

 



4 column(A,B,C,D) in atteched excel,  please tell me how to do this
-- 
With Regards,
Vishal K. Angre 
E-mail :  visha...@gmail.com 
 vishal.k.an...@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/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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Column hide from excel

2010-10-08 Thread SUMIT VYAS

Dear Vishal

This trick is VBA inst log file.


Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count = 1 Then
If Target.Value <> "" Then
If Target.Column = 3 And Target.Row > 1 Then
Target(1, -1) = Format(Now, "dd-mmm- hh:mm:ss")
Target(1, 0) = Application.UserName
End If
End If
End If
End Sub

But One Bug :-modify data any time change your log

sugg :- please enter option on entry then enter protect row


Thanks 7 Regards

Sumit




On Fri, Oct 8, 2010 at 4:03 PM, Vishal Angre wrote:

>
>
> 4 column(A,B,C,D) in atteched excel,  please tell me how to do this
> --
> With Regards,
> *Vishal K. Angre*
> E-mail :  visha...@gmail.com
>  vishal.k.an...@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/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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Column hide from excel

2010-10-08 Thread Vishal Angre

4 column(A,B,C,D) in atteched excel,  please tell me how to do this
-- 
With Regards,
*Vishal K. Angre*
E-mail :  visha...@gmail.com
 vishal.k.an...@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/pages/discussexcelcom/160307843985936?v=wall&ref=ts


ctv_.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Conditional Sum or Sumproduct.

2010-10-08 Thread C.G.Kumar

THANKS. BUT IT SERVE THE PURPOSE PARTIALLY...IN ADDITION I HAVE TO CONSIDER
ONLY FY 2009-10 WHEREAS FORMULA TAKES BEYOND 31/03/2010.3


IS IT POSSIBLE TO REVISE THE FORMULA.


REGARDS,

C.G.KUMAR

On Fri, Oct 8, 2010 at 2:19 PM, ashish koul  wrote:

> check the atatchment see if it helps
>
>
>
> On Fri, Oct 8, 2010 at 12:18 PM, Chandra Gupt Kumar <
> kumar.bemlmum...@gmail.com> wrote:
>
>>  Objective is to calculate Sale for the financial year 2009-10 (April
>> 2009 – March 2010 )for each staff no. Data are in sheet named ‘DATA’ in
>> different column. It Starts with Staff No. then Start Date, End Date, Sale
>> Type, and Amount (*It is* *Sale per month during start and end period)*.
>>
>>
>>
>> 1.   For example : if we have to calculate sale made by staff no.9465
>> during financial Year 2009-10, we see staff no.9465 and start with
>> identifying April 09 sale is at Row no 8 & monthly sale were 12850.00 (cell
>> E8) for April to June 10. Further, from July 09 to March 10, sale were 29100
>> per month. So, total sale for the financial Year should come : 12850*3(
>> April – June 09)  +29100*9( July – March 10) =300450.00. Output required
>> against this staff no is 300450.00
>>
>> 2.   Next if we calculate for Staff no.17442 , it comes 0 (Zero).
>> Because last data for him is for the period 01/07/2005 to 31/10/2007.
>>
>> 3.   If we proceed to calculate for Staff No.17822, output should be
>> 118200.00 . This is calculated in following manner; he sold for 9750  per
>> month from 01/10/2008 to 30/09/2009 ,since we are determining only for April
>> 09 to March 10, we will consider 9750 for 6 months i.e. April 09- September
>> 09.  Further, sale for the period 01/10/2009 to 31/12/ is/expected to
>> 9950.00. We again have to consider only period for April 09 to March 10, and
>> hence sale is :9950*6 (for October to March 10). Total sale by Staff No.
>> 17822 is 118200.00 {(9750*6(April-Sep09 months)  +9950*6(Sept 09-March 10) =
>> 118200.)
>>
>>
>>
>> Hope it helps you to solve the crux .
>>
>>
>>
>>
>>
>> Regards,
>>
>>
>>
>> C.G.Kumar
>>
>> AMW-2
>>
>>
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-mac...@googlegroups.com] *On Behalf Of *Aindril De
>> *Sent:* Friday, October 08, 2010 11:35 AM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ Conditional Sum or Sumproduct.
>>
>>
>>
>> Hi C.G.,
>>
>>
>>
>> Could you please elaborate more on what condition you would like to put in
>> here?
>>
>>
>>
>> Regards,
>>
>> Andy
>>
>> On Fri, Oct 8, 2010 at 10:34 AM, C.G.Kumar 
>> wrote:
>>
>> I am looking for conditional sum i.e. sum based on criteria. But neither
>> Sumproduct nor SUMIFS and Pivot serve the purpose.
>>
>> Attached sample file . Hope you will be able to solve the crux.
>>
>>
>>
>>
>> Regards,
>>
>>
>>
>> C.G.Kumar
>>
>>
>>
>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>>
>> http://www.facebook.com/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/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 follo

Re: $$Excel-Macros$$ Rupee symbol on PC

2010-10-08 Thread Aindril De

Hi,

I accidentally found an answer to the question put up by N Shivkumar. So
wanted to share the same, though I am sure most of you must have found the
solution to this. Following are the steps:

1) Select the column/cell where you want to have the format with the
new ` rupee
symbol.
2) Change the format of the cell to Currency.
3) Go to Cell Format -> Choose Custom and paste the following:
[>999]"` "##\,##\,##\,##0.00;[>9]"` "##\,##\,##0.00;`##,##0.00
4) Change the font of the column/cell selected to Rupee Fordian.
And thats all you need.

You can now use the format painter to replicate this same format across
wherever required.

Cheers,
Andy


On Wed, Sep 8, 2010 at 12:14 PM, N.Shivkumar  wrote:

> Thanx a lot I would like to know how to have the new symbol in the below
> mentioned format :
>
> [>999]"Rs. "##\,##\,##\,##0.00;[>9]"Rs.
> "##\,##\,##0.00;Rs.##,##0.00
> N.SHIVKUMAR
>
>  --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
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

RE: $$Excel-Macros$$ Conditional Sum or Sumproduct.

2010-10-08 Thread Chandra Gupt Kumar

Objective is to calculate Sale for the financial year 2009-10 (April 2009 -
March 2010 )for each staff no. Data are in sheet named 'DATA' in different
column. It Starts with Staff No. then Start Date, End Date, Sale Type, and
Amount (It is Sale per month during start and end period).

 

1.   For example : if we have to calculate sale made by staff no.9465
during financial Year 2009-10, we see staff no.9465 and start with
identifying April 09 sale is at Row no 8 & monthly sale were 12850.00 (cell
E8) for April to June 10. Further, from July 09 to March 10, sale were 29100
per month. So, total sale for the financial Year should come : 12850*3(
April - June 09)  +29100*9( July - March 10) =300450.00. Output required
against this staff no is 300450.00

2.   Next if we calculate for Staff no.17442 , it comes 0 (Zero).
Because last data for him is for the period 01/07/2005 to 31/10/2007. 

3.   If we proceed to calculate for Staff No.17822, output should be
118200.00 . This is calculated in following manner; he sold for 9750  per
month from 01/10/2008 to 30/09/2009 ,since we are determining only for April
09 to March 10, we will consider 9750 for 6 months i.e. April 09- September
09.  Further, sale for the period 01/10/2009 to 31/12/ is/expected to
9950.00. We again have to consider only period for April 09 to March 10, and
hence sale is :9950*6 (for October to March 10). Total sale by Staff No.
17822 is 118200.00 {(9750*6(April-Sep09 months)  +9950*6(Sept 09-March 10) =
118200.)

 

Hope it helps you to solve the crux .

 

 

Regards,

 

C.G.Kumar

AMW-2

 

From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Aindril De
Sent: Friday, October 08, 2010 11:35 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Conditional Sum or Sumproduct.

 

Hi C.G.,

 

Could you please elaborate more on what condition you would like to put in
here?

 

Regards,

Andy

On Fri, Oct 8, 2010 at 10:34 AM, C.G.Kumar 
wrote:

I am looking for conditional sum i.e. sum based on criteria. But neither
Sumproduct nor SUMIFS and Pivot serve the purpose.

Attached sample file . Hope you will be able to solve the crux.

 

 
Regards,

 

C.G.Kumar

 

 

-- 

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

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/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/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/pages/discussexcelcom/160307843985936?v=wall&ref=ts


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

$$Excel-Macros$$

2010-10-08 Thread shrinivas shevde


Dear All

Please help me on given  problem

Problem

I have many sheet in File(more than 30)

In Shhet 1 ,C4 =B4

In Sheet 2 C4=B4 of sheet2 + C4 of sheet 1

If I copy paste this pformula in sheet 3 it will take as

C4= B4 of Sheet 3+C4 of sheet 1 but actually I want 

C4= B4 of Sheet 3+C4 of sheet 2 (That is Previous sheet)

 

Currently I can not copy paste this formula  I have to write it 

 

Can Any one help me

 



shrinivas


  

-- 
--
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


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

Re: $$Excel-Macros$$ How to find consodated sale data of previous 3 months

Re: $$Excel-Macros$$ Re: How to find consodated sale data of previous 3 months

Re: $$Excel-Macros$$ Re: How to find consodated sale data of previous 3 months

Re: $$Excel-Macros$$ How to find consodated sale data of previous 3 months

Re: $$Excel-Macros$$ Job Opening for Excel and VBA

$$Excel-Macros$$ Re: How to find consodated sale data of previous 3 months

Re: $$Excel-Macros$$ How to find consodated sale data of previous 3 months

$$Excel-Macros$$ Getting a cell value to change when it is in an Indirect function

Re: $$Excel-Macros$$ dynamic range (table_array) in vlookup formule

$$Excel-Macros$$ Re: Losing weight

$$Excel-Macros$$ Job Opening for Excel and VBA

Re: $$Excel-Macros$$ DELETE OF A VALUE DELTES THAT FROM EVERY SHEET

$$Excel-Macros$$ Losing weight

Re: $$Excel-Macros$$ Column hide from excel

$$Excel-Macros$$ HELP

$$Excel-Macros$$ DELETE OF A VALUE DELTES THAT FROM EVERY SHEET

Re: $$Excel-Macros$$ Column hide from excel

RE: $$Excel-Macros$$ Column hide from excel

Re: $$Excel-Macros$$ Column hide from excel

$$Excel-Macros$$ Column hide from excel

Re: $$Excel-Macros$$ Conditional Sum or Sumproduct.

Re: $$Excel-Macros$$ Rupee symbol on PC

RE: $$Excel-Macros$$ Conditional Sum or Sumproduct.

$$Excel-Macros$$

24 matches

Site Navigation

Mail list logo

Footer information