+ Reply to Thread
Results 1 to 1 of 1

Macro to remove duplicate data? and to summarise a larger table with duplicates removed.

  1. #1
    Registered User
    Join Date
    05-31-2014
    Posts
    8

    Macro to remove duplicate data? and to summarise a larger table with duplicates removed.

    Hiya guys,

    I hope you are keeping well and the sun is out where you are..

    I am struggling a little with this one in that I am trying to create a summary sheet that updates when input data is added.

    I'm still learning many parts of excel and I'm unsure why the SUMIF function on occasion leaves duplicate data in.

    I have posted a similar conundrum before and some posters have kindly responded but I found that the solutions broke down in differing scenarios.

    I can live with the fact that I will need to correct the input data and am willing to just paste in corrected data when it has been validated via the data validation tab.

    Once this has been done, all I am seeking is for a subsequent process to start which updates a summary sheet with the sums correctly adding via the sumif function.

    I have left some instructions on the actual spreadsheet to help clarify my intended results.

    Many thanks in anticipation.

    Tutsyboy
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Macro to remove duplicate data? and to summarise a larger table with duplicates remove

    @tutsyboy

    how about reading the forumrules (specialy the rules about crossposting).

    http://www.mrexcel.com/forum/excel-q...s-removed.html
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ 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. Macro to remove duplicates (If duplicate meets all three criteria)
    By adw223 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-01-2013, 05:46 PM
  2. [SOLVED] Find Duplicates and remove the duplicate entry comparing two columns
    By retrospikz in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-04-2013, 03:17 AM
  3. [SOLVED] macro to remove and consolidate duplicate data
    By ad9051 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-23-2012, 09:50 PM
  4. macro to select table and remove duplicates problem.
    By 0lzi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-16-2011, 05:59 AM
  5. Remove Duplicates not removing all duplicate entries
    By Rick_Stanich in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-20-2008, 05:32 PM

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