+ Reply to Thread
Results 1 to 3 of 3

Report unique values

  1. #1
    Forum Contributor
    Join Date
    05-16-2012
    Location
    Latina, ITALY
    MS-Off Ver
    Excel 2010--2016
    Posts
    947

    Report unique values

    good evening, I got stuck in reporting a unique list.
    In the attached file find an example of what I would like to do.
    In row 7 I have 2 columns to complete the H and I
    As you can see in H7 and I7 I have the same value while I would like only one of the 2 and,
    the one found in J7, would go to I7
    Also in line 10 report only one
    Thank you.
    Attached Files Attached Files

  2. #2
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Northumberland, UK
    MS-Off Ver
    various
    Posts
    2,704

    Re: Report unique values

    I would be inclined to use

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    05-16-2012
    Location
    Latina, ITALY
    MS-Off Ver
    Excel 2010--2016
    Posts
    947

    Re: Report unique values

    Perfect thank you very much
    Hi

+ 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. [SOLVED] VBA to split report according to segmentation of rows unique values to sheet check
    By johnlara in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-23-2016, 08:09 AM
  2. Visual Basic for Access Report- form load no unique values in text boxes
    By LMcKee in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-24-2015, 09:28 AM
  3. [SOLVED] Filter / Report Top 10 Values with identifier into new spreadsheet / table / report style
    By steverokh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-04-2013, 05:10 AM
  4. Replies: 0
    Last Post: 03-08-2012, 12:18 PM
  5. scaling an exisiting macro for unique values of X for Unique values of Y.
    By widodude in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-18-2011, 09:33 PM
  6. Fill an individual report with values from a team report?
    By alymcmorland in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-13-2005, 04:39 AM
  7. [SOLVED] Can an Array formula count unique values and report no. of times for each?
    By Father Guido in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-21-2005, 02:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1