+ Reply to Thread
Results 1 to 6 of 6

A formula template

  1. #1
    Registered User
    Join Date
    08-23-2008
    Location
    India
    Posts
    2

    A formula template

    hi.

    I have a very interesting problem here and its solution, if possible, culd be very beneficial.

    ok the question is like this. i have a spread sheet which u can consider to be that of Classes in a center. So i have different batches and diff no. of students in different batches. AT the bottom of each batch i take the total of each column, based on certain conditions, month wise. Different batches months coincide on the same sheet so that the totals for all batches for any month all fall in one column at various rows.

    This formula for totals is same for all batches except that it works on a different range for various batches in the same column (for any one month). If there are 25 batches in a sheet, then every time i feel i need to modify this formula, i need to make changes at all those 25 places.

    What i want to know and do is this.
    Is it possible for me to create a formula template in some cell. The take that formula from there to all the various 25 places in the sheet. Find a dynamic way to calculate the range for each of those 25 batches which is automatically lifted by this formula and the results calculated. This would be tremendously beneficial because the next time i need to make some modification in the formula, i would be able to modify it at just one place and all changes would be accomplished automatically.

    the formula template shud be sth like this (the formula itself is not important, it cud be anything). (if(iscount(RANGE),"",if(......) that i may place in just one cell. then place this formula at the various places reqd. and the RANGE be dynamically calculated (or Lifted) from a given cell against each Batch. If i insert or delete rows the RANGE shud be automatically modified as well.

    i do have a my excel file but i am not able to upload it as its size exceeds 100kb, which is the limit to upload the xls file on this forum. Any help on that as well ?

    I hope i have been able to express myself well enuff for u to understand the problem. Hope to get a reply to this very interesting and very useful problem.

    Thanks All & have a great day,
    Ajay.

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320
    what size when zipped?

  3. #3
    Registered User
    Join Date
    08-23-2008
    Location
    India
    Posts
    2

    Ok here's my zipped file, thanks mr. martin

    pls find attaehed the zip xls file i am using for my example. Thanks to a tip from mr. martin.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    01-07-2013
    Location
    Arrhus, Denmark
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: A formula template

    Hi

    Did you solve the problem. I would like to know the solution!

    Lars

  5. #5
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: A formula template

    idamkjar,

    This thread is over 4 yrs old and not likely to get a reply. Why dont you post your question in a new thread? You will surely receive faster responses that way.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  6. #6
    Registered User
    Join Date
    01-07-2013
    Location
    Arrhus, Denmark
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: A formula template

    You are probably right :-)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Formula for bond price
    By Dracan in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 04-15-2014, 11:17 AM
  2. Replies: 7
    Last Post: 07-13-2008, 10:14 PM
  3. Reset Formula without Editing Formula?
    By Ogey in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-27-2007, 08:44 PM
  4. Conditional formula question
    By odditie in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-27-2007, 09:47 PM
  5. How do I subsitute part of a formula linked to another workbook?
    By Scej12 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-03-2007, 10:10 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1