+ Reply to Thread
Results 1 to 4 of 4

Grouping data

  1. #1
    Registered User
    Join Date
    12-27-2022
    Location
    Cluj Romania
    MS-Off Ver
    2019
    Posts
    4

    Grouping data

    hello guys,
    i have the following exercise: build a report that shows the number of contracts for which payments were recorded and the average number of payments recorded on these contracts, depending on the method of payment and the county of the contract.
    im new to this field so any help will be much appreciated, any explcations regarding the steps also.
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,054

    Re: Grouping data

    The way the forum works is like this.... we provide you with help... for free, for fun. We don't get paid by you, or indeed by anyone.

    In return we expect you to do the bulk of the work.

    Read the yellow banner (top) about sample sheets. We want 10-20 rows, not tens of thousands.

    You have told us NOTHING about what you expect to see, or where you expect to see it.

    Please prepare and upload a sample sheet that MEETS our guidelines, complete with expecte results.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    12-27-2022
    Location
    Cluj Romania
    MS-Off Ver
    2019
    Posts
    4

    Re: Grouping data

    hello,
    Got it, i'll try to make it simple.

  4. #4
    Registered User
    Join Date
    09-10-2013
    Location
    indonesian
    MS-Off Ver
    O365
    Posts
    44

    Re: Grouping data

    hi glen
    could you help me
    i'm facing some problem with my formula
    1st capture is result of my formula, but the second capture is what i expected result
    i hope you can help me
    thanks in advance
    grouping #1.png

    grouping #2.png
    Attached Files Attached Files

+ 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. Replies: 1
    Last Post: 11-06-2020, 05:45 PM
  2. Replies: 6
    Last Post: 01-24-2019, 04:19 AM
  3. Replies: 0
    Last Post: 12-10-2015, 08:24 AM
  4. Replies: 4
    Last Post: 07-26-2014, 02:35 AM
  5. Replies: 6
    Last Post: 06-07-2012, 09:32 AM
  6. Want to get a Series with Grouping and Sub-Grouping based on 2 criterias.
    By e4excel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-02-2011, 05:46 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