Results 1 to 9 of 9

Compare 2 columns and sum frequency of duplicates

Threaded View

jntslvdrt Compare 2 columns and sum... 03-23-2015, 12:38 PM
mikeTRON Re: Compare 2 columns and sum... 03-23-2015, 01:58 PM
jntslvdrt Re: Compare 2 columns and sum... 03-23-2015, 02:04 PM
mikeTRON Re: Compare 2 columns and sum... 03-23-2015, 02:16 PM
jntslvdrt Re: Compare 2 columns and sum... 03-24-2015, 08:01 AM
jntslvdrt Re: Compare 2 columns and sum... 03-24-2015, 09:23 AM
mikeTRON Re: Compare 2 columns and sum... 03-24-2015, 11:36 AM
jntslvdrt Re: Compare 2 columns and sum... 03-24-2015, 01:10 PM
mikeTRON Re: Compare 2 columns and sum... 03-24-2015, 01:49 PM
  1. #8
    Registered User
    Join Date
    03-23-2015
    Location
    São Bernardo do Campo, Brazil
    MS-Off Ver
    2007
    Posts
    5

    Re: Compare 2 columns and sum frequency of duplicates

    Now I put more data. But now I want to sort who has more users under its name. Like the first one into the 4th and last pivottable Grant Rodgers he has only one user under his name... while Grady Payne has 3. So I want to filter in order to put Grady Payne and other like him (1+ users under his name). I made some attempts using filter but with no success...

    Sorry, Sample2 is the correct one
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Compare 2 columns and remove duplicates in both columns when found
    By 1dtms in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-11-2013, 02:19 AM
  2. [SOLVED] Macro to Compare Columns A & B and dispaly any duplicates in Columns C & D
    By robertguy in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-12-2013, 02:24 AM
  3. Compare two columns delete duplicates
    By camo090 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-16-2013, 03:59 PM
  4. Compare data across 7 columns for duplicates
    By rstellers in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-04-2010, 09:19 AM
  5. compare two columns and remove duplicates
    By Moni39 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-05-2005, 02:06 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