+ Reply to Thread
Results 1 to 3 of 3

Check duplicate values and combine cell values to form a single entry

  1. #1
    Registered User
    Join Date
    07-20-2011
    Location
    Kerala, India
    MS-Off Ver
    Excel 2013
    Posts
    93

    Thumbs up Check duplicate values and combine cell values to form a single entry

    Hi! Am using Windows 7 (SP1); MS Office 2013

    I have duplicate Invoice numbers in column A and Taxable amount in column B and Tax in column C. I wish to avoid duplicate Invoice numbers, but the amounts in Taxable amount column values and Tax values should be added, so that I get a single entry of invoice number with added values of Taxable amount and Tax amount.

    i.e.:
    If the content or figure in column A are same
    the simultaneous values in column B should be added and the total should be displayed on the last column of column E
    and the simultaneous values in column C should be added and the total should be displayed on the last column of column F

    Eg: Cell A1,A2,A3 are same
    D3 should display "1"(Invoice No.)
    Then B1,B2,B3 should be added and total should be displayed on E3
    and C1,C2,C3 should be added and total should be displayed on F3

    Please go through the attached excel sheet for more clarification

    Thank you
    Attached Files Attached Files

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Check duplicate values and combine cell values to form a single entry

    You can do with a pivot table, see attached.
    Attached Files Attached Files

  3. #3
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    2,367

    Re: Check duplicate values and combine cell values to form a single entry

    Maybe, put this on D1 and copied down as necessary:
    =IF(COUNTIF($A$1:$A$22,A1)<2,"",IF(COUNTIF($A$1:A1,A1)=COUNTIF($A$1:$A$22,A1),INDEX(A:A,SUMPRODUCT(MAX(($A$1:A1=A1)*ROW($A$1:A1)))),""))

    And put this on E1 and copied down and cross:
    =IF(SUMIFS(B$1:B$22;$A$1:$A$22;$D1)=0;"";SUMIFS(B$1:B$22;$A$1:$A$22;$D1))
    Attached Files Attached Files
    Last edited by azumi; 11-21-2018 at 02:40 AM.

+ 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. Combine duplicate values into single Cell with different source data
    By Yuvaraaj in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-03-2016, 01:15 PM
  2. [SOLVED] Combine duplicate values into single cell
    By Yuvaraaj in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-03-2016, 07:05 AM
  3. [SOLVED] Combine values from multiple cells into one cell, then delete duplicate lines
    By Ocean Zhang in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2015, 07:01 PM
  4. [SOLVED] Need Urgent help on Adjacent values of Duplicate column values should be be in single row.
    By anto_01 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-11-2012, 09:55 PM
  5. Merge duplicate row cells, but combine unique cell values (Macro)
    By jcornale in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-08-2012, 06:40 PM
  6. Replies: 2
    Last Post: 02-20-2012, 06:06 PM
  7. how to check the duplicate data entry in form?
    By jay11 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-18-2010, 01:59 PM

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