Re: $$Excel-Macros$$ Formula help

2014-01-18 Thread Kantilal Badale 
PFA

CA Kantilal Badale
9822250393



On Sat, Jan 18, 2014 at 5:08 PM, Shaikh Iqbal  wrote:

> Dear Export,
>
>
> I want a formula as per attached 3 slab condition wise earning.
>
>
>
>
>
>
>
>
>
>
>
>
>
> Regards,
>
> Iqbal
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.


earning Solved.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ PICK THE PRICES BASING ON START DATE

2014-01-16 Thread Kantilal Badale 
PFA



CA Kantilal Badale
9822250393



On Fri, Jan 17, 2014 at 1:52 AM, Yahya Muhammad  wrote:

> Hi Naidu
>
> Please find the attachment.
>
>
>
>
> On Thu, Jan 16, 2014 at 7:14 PM, Grkrishna Naidu wrote:
>
>> Dear Experts
>>
>> I need your help to solve the issue
>>
>> I have have a  master data under following heads
>>
>> PRODUCT CODE,  PRODUCT NAME , START DATE,  MRP, PTS, PTR
>>
>>
>> I NEED THE OUTPUT  DATA ( I.E., MRP,PTS & PTR ) ON BASING THE START DATE.
>>
>>
>> THNKS IN ADVANCE
>> RADHA KRISHNA G.
>> 9912567932
>>
>>
>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.


price picking with start date (Solution).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Vlookup - Price List

2013-11-13 Thread Kantilal Badale 
PFA with range changed from 23rd  to 100th lines. It is working fine.
Alternatively you can use named range to make it more easy (Solution
Attached )

As far as benefits / limitations are concerned array solutions are very
powerful compared to non array. But I personally prefer array solutions
only if non array solution is not available.

Regards



On Tue, Nov 12, 2013 at 10:12 AM, Bill Q  wrote:

> Kantila,
>
> Thanks for your effort. I appreciate it and everyone else's
> contribution. I have a question
>
> I want to add to this. So, I looked at the code and notice that you have
> defined everything to end at line 23 (except for the last past that says
> 22?). That's fine, I thought I could change it all manually to say 100
> lines then just populated as need be. However it is not working according
> to logic. Any explanation as to what I am doing wrong ? Also, what are the
> benefits (or limitations) of a non-array solution compared to what Ravinder
> proposed ?
>
> Thank You.
>
>
> On Monday, November 11, 2013 11:21:08 PM UTC-5, kantila...@gmail.comwrote:
>
>> PFA
>> Non array solution
>>
>> CA Kantilal Badale
>>
>>
>> On Tue, Nov 12, 2013 at 7:33 AM, Bill Q  wrote:
>>
>>> PERECT Ravinder !
>>>
>>> MANY thanks !
>>>
>>>
>>> On Monday, 11 November 2013 02:01:37 UTC-5, ravinder negi wrote:
>>>
>>>> pfa
>>>>
>>>>
>>>>
>>>> *From:* excel-...@googlegroups.com [mailto:excel-...@googlegroups.com] *On
>>>> Behalf Of *Bill Q
>>>>
>>>> *Sent:* Sunday, November 10, 2013 10:55 PM
>>>> *To:* excel-...@googlegroups.com
>>>>
>>>> *Subject:* $$Excel-Macros$$ Vlookup - Price List
>>>>
>>>>
>>>>
>>>> Hi Guys,
>>>>
>>>>
>>>>
>>>> This seems simple and I am pretty certain that it is - but I am
>>>> stumped. Please refer to attached.
>>>>
>>>>
>>>>
>>>> - This is a simple price list estimator.
>>>>
>>>> - There are 2 worksheets. (1 = work, that you work from) (2 = static
>>>> information/vlookup table)
>>>>
>>>>
>>>>
>>>> I cannot figure out how to return values based on 3 input criteria.
>>>>
>>>>
>>>>
>>>> The 2 examples in "work" were manually entered in by me (including
>>>> the correct price result in yellow).
>>>>
>>>>
>>>>
>>>> I obviously would like this to be automated. I was thinking vlookup,
>>>> but not sure how to do this with multiple criteria.
>>>>
>>>>
>>>>
>>>> Anyone ?
>>>>
>>>>
>>>>
>>>> Thanks !
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>>> https://www.facebook.com/discussexcel
>>>>
>>>> FORUM RULES
>>>>
>>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>>> will not get quick attention or may not be answered.
>>>> 2) Don't post a question in the thread of another member.
>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>> measure.
>>>> 4) Acknowledge the responses you receive, good or bad.
>>>> 5) Jobs posting is not allowed.
>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>
>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>>> and members are not responsible for any loss.
>>>> ---
>>>> You received this message because you are subscribed to the Google
>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to excel-macros...@googlegroups.com.
>>>> To post to this group, send email to excel-...@googlegroups.com.
>>>>
>>>> Visit this group at http://groups.google.com/group/excel-macros.
>>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>>
>>>>  --
>>> Are you =EXP(E:RT) or =

Re: $$Excel-Macros$$ Vlookup - Price List

2013-11-11 Thread Kantilal Badale 
PFA
Non array solution

CA Kantilal Badale


On Tue, Nov 12, 2013 at 7:33 AM, Bill Q  wrote:

> PERECT Ravinder !
>
> MANY thanks !
>
>
> On Monday, 11 November 2013 02:01:37 UTC-5, ravinder negi wrote:
>
>> pfa
>>
>>
>>
>> *From:* excel-...@googlegroups.com [mailto:excel-...@googlegroups.com] *On
>> Behalf Of *Bill Q
>>
>> *Sent:* Sunday, November 10, 2013 10:55 PM
>> *To:* excel-...@googlegroups.com
>>
>> *Subject:* $$Excel-Macros$$ Vlookup - Price List
>>
>>
>>
>> Hi Guys,
>>
>>
>>
>> This seems simple and I am pretty certain that it is - but I am stumped.
>> Please refer to attached.
>>
>>
>>
>> - This is a simple price list estimator.
>>
>> - There are 2 worksheets. (1 = work, that you work from) (2 = static
>> information/vlookup table)
>>
>>
>>
>> I cannot figure out how to return values based on 3 input criteria.
>>
>>
>>
>> The 2 examples in "work" were manually entered in by me (including
>> the correct price result in yellow).
>>
>>
>>
>> I obviously would like this to be automated. I was thinking vlookup, but
>> not sure how to do this with multiple criteria.
>>
>>
>>
>> Anyone ?
>>
>>
>>
>> Thanks !
>>
>>
>>
>>
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros...@googlegroups.com.
>> To post to this group, send email to excel-...@googlegroups.com.
>>
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or

Re: $$Excel-Macros$$ Re: Repair File

2013-03-19 Thread Kantilal Badale 
Thanks Prakash,

I tried following steps before sharing the file. But could not recover the
file

Kantilal Badale




On Tue, Mar 19, 2013 at 2:46 PM, Prakash  wrote:

>
> Hello Kantilal,
>
> Have you tried to repair the file at your end? If no then try to repair it
> first and share the result.
>
> You can repair the file by following below steps:
>
>1. On the *File* menu, click Open.
>2. In the Open dialog box, select the file you want to open, and click
>the arrow next to the Open button.
>3. Click *Open and Repair*, and then choose which method you want to
>use to recover your workbook.
>
>
> Methods for recovering data from damaged workbooks are explained here:
> Link<http://office.microsoft.com/en-us/excel-help/repairing-corrupted-files-in-excel-HA001034656.aspx>
>
> Additionally, there are so many 3rd party excel repair 
> software<http://www.repair-excel-file.com/download-xls-repair-software.php>out
>  there. Just download the free demo version and see what they can do for
> you.
>
> On Tuesday, March 12, 2013 1:30:35 PM UTC+5:30, kantila...@gmail.comwrote:
>>
>> Deal All experts,
>>
>>
>> Please help me to repair attached file.
>>
>> Kantilal Badale
>>
>>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: Fw: Re: $$Excel-Macros$$ IF Doubt - Query

2013-02-19 Thread Kantilal Badale 
See whether it works

Kantilal Badale

On Wed, Feb 20, 2013 at 11:02 AM, Kenil Gala  wrote:

>
> I have changed the example, hope if it helps.
> Pls help
>
> Thanks in adv.
> --- On *Wed, 2/20/13, Abhishek Jain * wrote:
>
>
> From: Abhishek Jain 
> Subject: Re: $$Excel-Macros$$ IF Doubt - Query
> To: excel-macros@googlegroups.com
> Date: Wednesday, February 20, 2013, 10:27 AM
>
>
> Your query is not very clear. Could you be a little more specific?
>
> Thanks,
>
> On Wed, Feb 20, 2013 at 10:11 AM, Kenil Gala 
> http://mc/compose?to=keni...@yahoo.com>
> > wrote:
>
>
>
>
> Hi group, Pls help.
>
> I have a small query for solving IF Function.
> i want the the answer which is in between the two given values.
>
> Pls Help
> Thanks in adv.
>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to 
> excel-macros+unsubscr...@googlegroups.com<http://mc/compose?to=excel-macros%2bunsubscr...@googlegroups.com>
> .
> To post to this group, send email to 
> excel-macros@googlegroups.com<http://mc/compose?to=excel-macros@googlegroups.com>
> .
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@goo

Re: $$Excel-Macros$$ Help with Formula Destination

2012-08-06 Thread Kantilal Badale 
Try CTRL+[ ] from formula cell

CA Kantilal Badale
E-Hall, First Floor,
B. J. Market,
Jalgaon.(Maharashtra)
9822250393





On Mon, Aug 6, 2012 at 10:08 PM, Sam Mathai Chacko wrote:

> =HYPERLINK("#"&CELL("address",Sheet3!A1),Sheet3!A1)
>
> Regards
>
> Sam Mathai Chacko
>
>
> On Mon, Aug 6, 2012 at 9:41 PM, ashish koul  wrote:
>
>> =HYPERLINK("#'"&SUBSTITUTE(CELL("address",Sheet2!A3),"!","'!"),Sheet2!A3)
>>
>>
>>
>>
>> On Mon, Aug 6, 2012 at 7:09 PM, Ashish Pradhan wrote:
>>
>>>
>>> Hello
>>>
>>> I have many cells with formulae in them in Sheet "Main"
>>>
>>> For Example:
>>>
>>> ='Staff Bonus'!E67
>>>
>>> Is there a simpler way to go to the Sheet "Staff Bonus" and cell "E67"
>>> from the "Main" sheet which contains this formulae?
>>>
>>> I think I was able to do this much earlier, but either I am mistaken or
>>> have simply forgotten. Any help / clarification would ease my work a lot
>>> and be highly appreciated.
>>>
>>> Just as an additional piece of information, I use Excel 2003 (SP3)
>>>
>>> --
>>> Thanks
>>>
>>> Ashish Pradhan
>>>
>>> --
>>> Join official facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES (1120+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> 6) Jobs posting is not allowed.
>>>
>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>>
>>>
>>>
>>
>>
>>
>> --
>> *Regards*
>> * *
>> *Ashish Koul*
>>
>>
>>  *Visit*
>> *http://www.excelvbamacros.com/*
>> *http://www.accessvbamacros.com/*
>>
>> P Before printing, think about the environment.
>>
>>
>>
>>  --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>
>
>
> --
> Sam Mathai Chacko
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discu

Re: $$Excel-Macros$$ a vlookup type function

2012-07-31 Thread Kantilal Badale 
Try Sumifs

CA Kantilal Badale



On Wed, Aug 1, 2012 at 1:28 AM, colmkav  wrote:

> Hi, I need a vlookup type function to return the value but only where more
> than 1 field are the same
>
> eg
>
> client dateDebt
> Jane  4/5/12   £50
> Jabe   2/5/12   £22
>
> So I want to get the debt value where Jane is the client and the date is
> 2.5.12 (ie £22)
>
> how can I achieve this?
>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>

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

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

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

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

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

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

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

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

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




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

Re: $$Excel-Macros$$ Urgent help needed please

2012-02-28 Thread Kantilal Badale 
Try Sumif




Kantilal Badale




On Mon, Feb 27, 2012 at 6:02 PM, Arpita kapoor wrote:

>  Hi,
>
> Can anyone please help me with a simple formula for the below data set.
> All I need is to a sum of all the figures (+/-) except for those which are
> =><1/-1
>
>0.47 0.40 0.26 1.05 0.21 2.50 0.05 -0.03 -0.07 -0.08 -0.31 -0.48 -0.65
> -0.66 -0.80 -11.26
>
> I don't seem to get it, I am sorry if it sounds very trivial, but any help
> will be appreciated,
>
> Thanks alot
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

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

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

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

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

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

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

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

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


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

$$Excel-Macros$$ Excel on Mobile

2011-05-03 Thread Kantilal Badale 
Dear All Experts

I am using HTC Incredible S Mobile (Android)

Please suggest me which application to download for using excel on mobile
with maximum features

Thanks in advance

Kantilal K Badale

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

Fwd: $$Excel-Macros$$ Help Required

2011-01-08 Thread Kantilal Badale 
Thanks so much Ashish & Manoj


Kantilal

-- Forwarded message --
From: Manoj kumar 
Date: Fri, Jan 7, 2011 at 9:25 AM
Subject: Re: $$Excel-Macros$$ Help Required
To: excel-macros@googlegroups.com


Hi Ashish,

ur macro function is awesome man... this can help me in those cases where we
have large string.. :))

Hi Kantilal, pasted below is another formula through which can fulfill the
same requirement...

=SUBSTITUTE(TRIM(B4 & " " & C4 & " " & D4 & " " & E4 & " " & F4 & " " & G4 &
" " & H4 & " " & I4), " ", ",")



Regards,
Manoj Kumar



On Fri, Jan 7, 2011 at 6:23 AM, ashish koul  wrote:

>
> check the attachement
>
>
>
> On Thu, Jan 6, 2011 at 7:49 PM, Kantilal Badale  > wrote:
>
>> Dear Friends,
>>
>> Please suggest solution for attached file
>>
>> Thanks
>>
>> Kantilal
>>
>> --
>>
>> --
>> 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
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com <http://akoul.blogspot.com/>
> *akoul*.wordpress.com <http://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 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/discussexcel

$$Excel-Macros$$ Help Required

2011-01-06 Thread Kantilal Badale 
Dear Friends,

Please suggest solution for attached file

Thanks

Kantilal

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


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

Fwd: $$Excel-Macros$$ Need ans for 3 que

2010-12-20 Thread Kantilal Badale 
Use conditional formatting to highlight cell containing formula


Kantilal





-- Forwarded message --
From: ashish koul 
Date: Sun, Dec 19, 2010 at 11:52 AM
Subject: Re: $$Excel-Macros$$ Need ans for 3 que
To: excel-macros@googlegroups.com


use this function


Function checkformula(x As Range)
checkformula = x.HasFormula

End Function

check the attachment



On Sun, Dec 19, 2010 at 1:49 AM, hanumant shinde wrote:

>  hey deepak,
>
> thanks man but any idea about 1st que?
>
>
> 1. how can i get to know if a specific cell has formula or normal value?
> i.e if A1 has value or formula?
>
>
> *From:* Rohan Young 
>
> *To:* excel-macros@googlegroups.com
> *Sent:* Fri, 17 December, 2010 9:49:55 AM
>
> *Subject:* Re: $$Excel-Macros$$ Need ans for 3 que
>
>  Hi Hanumant,
>
> Just hit Ctrl+F go to option and in look in set the criteria on Values u
> will get that
>
> bye for now
>
> Deepak (ROHAN)
> 9818247278
>
> On Thu, Dec 16, 2010 at 3:45 PM, hanumant shinde 
> wrote:
>
>> hey guys,
>>
>> need some help here.
>>
>> 1. how can i get to know if a specific cell has formula or normal value?
>>
>> 2. can we unzip folder or file using excel maco?
>>
>> 3. if a specific cell has formula whose value is lets say "shinde" how can
>> i
>> find it.
>>
>> i.e lets say A1 has value as "shinde"(its not fomula its normal string)
>> B1=A1 (its a formula)
>> now i want to find shinde in col B but its formula so i cant find it even
>> by
>> Ctrl + F
>> so what shud b the code to find "shinde" in col B.
>>
>> thanks
>> hanumant
>>
>>
>>
>> --
>>
>> --
>> 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
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.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/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.

Fwd: $$Excel-Macros$$ cumulative sum in pivot table

2010-12-18 Thread Kantilal Badale 
Hi Alisha,

Find attached file saved in excel 2003.

Regards

Kantilal

-- Forwarded message --
From: alisha malhotra 
Date: Wed, Dec 15, 2010 at 6:44 PM
Subject: Re: $$Excel-Macros$$ cumulative sum in pivot table
To: excel-macros@googlegroups.com


Hi Kantilal,

Thanks for your reply. Could you please save this attachment in excel 2003?
Is that possible in excel 2003?

Regards,
Alisha


On Thu, Dec 9, 2010 at 5:56 AM, Kantilal Badale
wrote:

>
>
> check the attachment see if it helps .
>
> Kantilal  Badale
>
>
>
>
>  On Tue, Dec 7, 2010 at 4:06 PM, alisha malhotra <
> alisha.malhotr...@gmail.com> wrote:
>
>> Hi Group,
>>
>> I have one pivot table. In that  I want to show the cumulative sum.
>> e.g.
>> Qtr1 sale:- 10 units
>> Qtr2 sale:- 20 units
>> Qtr3 sale:- 10 units
>> Qtr4 sale:- 30 units
>> now i want to show the sale of qtr1 and qtr2 i.e. 30 units after  qtr2 and
>> similarly after qtr3 cumulative sum of qtr1,2 and 3 i.e. 40 units  and so
>> on.
>>
>> How can I do this? Can anyone help me please?
>>
>> Thanks & Regards,
>> Alisha malhotra
>>
>> --
>>
>> --
>> 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

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


Cumulative sum in pivot.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ cumulative sum in pivot table

2010-12-08 Thread Kantilal Badale 
check the attachment see if it helps .

Kantilal  Badale




On Tue, Dec 7, 2010 at 4:06 PM, alisha malhotra  wrote:

> Hi Group,
>
> I have one pivot table. In that  I want to show the cumulative sum.
> e.g.
> Qtr1 sale:- 10 units
> Qtr2 sale:- 20 units
> Qtr3 sale:- 10 units
> Qtr4 sale:- 30 units
> now i want to show the sale of qtr1 and qtr2 i.e. 30 units after  qtr2 and
> similarly after qtr3 cumulative sum of qtr1,2 and 3 i.e. 40 units  and so
> on.
>
> How can I do this? Can anyone help me please?
>
> Thanks & Regards,
> Alisha malhotra
>
> --
>
> --
> 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


Cumulative sum in pivot.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Separate the values in different columns

2010-06-21 Thread Kantilal Badale 
Attached Required Formula

Kantilal Badale

On Tue, Jun 15, 2010 at 11:05 AM, Saurabh Patel <
saurabh.pa...@in.aegisglobal.com> wrote:

>  Hi All,
>
>
>
> Required help in attached file
>
>
>
> *Regards,
> Saurabh Patel*
>
>
>
>
> DISCLAIMER:The information contained in this electronic message and in any 
> attachments to this message is
>confidential, legally privileged and intended only for the person 
> or entity to which this electronic
>message is addressed. If you are not the intended recipient, 
> please notify the system manager and
>you are hereby notified that any distribution, copying, review, 
> retransmission, dissemination or
>other use of this electronic transmission or the information 
> contained in it is strictly prohibited.
>Please accordingly also note that any views or opinions presented 
> in this email are solely those of
>the author and may not represent those of the Company or bind the 
> Company. This message has been
>scanned for viruses and dangerous content by Mail Scanner, and is 
> believed to be clean.
>The Company accepts no liability for any damage caused by any 
> virus transmitted by this email.
>
>
> --
>
> --
> 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

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


Seperate Solution.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Attendance

2010-05-08 Thread Kantilal Badale 
Hi all,

Please suggest solution for attached sheet

Thanks

Kantilal

-- 
--
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 6,800 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


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