Results 1 to 2 of 2

merge duplicate data and summing value with average price

Threaded View

  1. 09-17-2021, 06:47 AM #1
    Alaa-A
    Alaa-A is offline
    Forum Contributor
    Join Date
    05-24-2021
    Location
    Palestine
    MS-Off Ver
    2019
    Posts
    284

    merge duplicate data and summing value with average price

    hi
    first this is a simple data , but my real data are about 8000 rows and they are increasable .
    so what I want merge duplicate items based on COL B with considering in COL I should take the average price for duplicate item in sheet DATA after calculate the average and put in COL J should multiply in COL I , and the result in COL K in sheet stock . about columns E,F if repeates for duplicate item should merge with comma .
    note : it should create whole data in sheet stock and if they change in sheet data should update in sheet stock
    sheet data
    by the isuued another forum https://www.mrexcel.com/board/thread.../#post-5755157
    any help I appreciate that .
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] merge data and summing values & create report
    By ABDELFATTA in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-14-2021, 04:12 AM
  2. [SOLVED] merge data and summing values for across multiple sheets
    By Alaa-A in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-31-2021, 07:44 AM
  3. [SOLVED] Calculate the average price of each product for each day from data table
    By mireg in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-04-2019, 08:16 AM
  4. Deleting Duplicate Data in Two Cells and Summing the Data
    By lassday in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-15-2016, 10:57 AM
  5. Excel 2007 : Merge duplicate data
    By jeffrowhm in forum Excel General
    Replies: 1
    Last Post: 02-10-2010, 12:40 PM
  6. Displaying and summing data with duplicate data fields
    By thefarbeyond in forum Excel General
    Replies: 3
    Last Post: 06-07-2009, 12:45 PM
  7. calculate/convert volume price to monthly average price
    By Bultgren in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-14-2006, 05:40 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1