+ Reply to Thread
Results 1 to 4 of 4

payment days Table

  1. #1
    Registered User
    Join Date
    12-01-2008
    Location
    istanbul
    Posts
    8

    Question payment days Table

    Hi all,

    I will be happy if anyone can help me with creating an excel file that sums the total payments in each currency for every second week tuesday unit by unit ?

    let me explain on a sample case:

    I have 2 production unit : A; B
    They make payments to suppliers on certain periods : p1, p2..
    The payments are on variable and different currencies : EUR, SEK, USD, CHF,AUD..

    I explained the sample case table in attached excel sheet. My question is "how can i create the summary table easily and quickly by excel?"

    currently I am calculating it by a simple excel formula (vlookup) that I need to change the range for each time. It s very time consuming and easy to make mistakes..

    thanks in advance, cheers
    Attached Files Attached Files
    Last edited by amygdalus; 11-19-2009 at 04:17 AM. Reason: make the question more clear

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,222

    Re: payment days Table

    Hi and welcome to the board

    Why not change a bit your data layout and use a Pivot table ? - see attached
    Attached Files Attached Files
    Quoting entire posts clutters the forum and makes threads hard to read !

  3. #3
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Excel for Windows & Mac - all versions.
    Posts
    26,437

    Re: payment days Table

    Hi,

    You'd be better advised to list your data as in the attached Sheet3. See table starting in B36.

    Then simply analyse the data with a pivot table - see I37

    HTH
    Attached Files Attached Files
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Registered User
    Join Date
    12-01-2008
    Location
    istanbul
    Posts
    8

    Re: payment days Table

    that s great! i love you guys..

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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