Results 1 to 4 of 4

Unique, without duplicates, and able to be counted in a pivot table...or another solution

Threaded View

  1. 11-11-2016, 01:04 PM #2
    newdoverman
    newdoverman is offline
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Unique, without duplicates, and able to be counted in a pivot table...or another solut

    I concatenated all the columns then used this formula to identify the unique values.
    Formula: copy to clipboard 
    =IF(COUNTIF($M$2:$M2,M2)=1,1,"")
    Attached Files Attached Files
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W
    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. Dynamic chart of counted data extracted from pivot table
    By ffbulle in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-19-2016, 04:25 PM
  2. [SOLVED] Pivot Table fields based on two counted fields
    By tejas.itraj in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 01-17-2014, 10:53 AM
  3. pivot table display/formatting hide fields not being counted
    By oamrt in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-28-2012, 10:22 AM
  4. Pivot Table - Calculating Percentage between 2 counted fields
    By Niq6 in forum Excel General
    Replies: 5
    Last Post: 06-08-2012, 03:24 PM
  5. Pivot table help,or other solution to get table data from Experts
    By interested in forum Excel General
    Replies: 1
    Last Post: 01-10-2012, 03:33 PM
  6. Summary Table - Sort breaks formulas; is a Pivot table a better solution?
    By paulrockliffe in forum Excel General
    Replies: 2
    Last Post: 05-19-2010, 05:14 AM
  7. Calculated Field in Pivot Table Based on Two Counted Fields
    By cmlits in forum Excel General
    Replies: 1
    Last Post: 03-30-2006, 12:50 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1