+ Reply to Thread
Results 1 to 2 of 2

Aggregate Function

  1. #1
    Forum Contributor
    Join Date
    02-10-2013
    Location
    Wolverhampton
    MS-Off Ver
    Excel 2010
    Posts
    101

    Aggregate Function

    Hi, I have data of about 10,000 rows, I want to aggregate the data so that all identical rows (exact codes) are aggregated, with the average of the cost calculated, can someone please help, I have attached the spreadsheet containing the data below.

    Book1.xlsx

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,406

    Re: Aggregate Function

    Try Pivot table
    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)

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