Results 1 to 8 of 8

Getting unique values by excel formula

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Microsoft Office 2016
    Posts
    640

    Getting unique values by excel formula

    Dear all, I am using below formula for getting unique values, it is working fine except getting one Zero, below the formula & unique values example.


    B2{=IFERROR(INDEX($A$2:$A$20, MATCH(0, COUNTIF($B1:B$1, $A$2:$A$20), 0)),"")}
    
    CELL A   CELL B
    a              a
    a              b
    a              c
    b              0
    c
    c
    here CELL B formula output is ok except Zero . I don't want to get Zero in the CELL B.
    Last edited by nur2544; 05-03-2019 at 01:51 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 11
    Last Post: 10-27-2016, 07:33 PM
  2. [SOLVED] Formula in Excel to count unique values matching criteria
    By Krix in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-15-2016, 11:51 AM
  3. [SOLVED] Formula or VBA - Comparison CSV Values between 3 cells for used range. Find unique values.
    By grphillips in forum Excel Programming / VBA / Macros
    Replies: 36
    Last Post: 06-09-2014, 02:12 PM
  4. [SOLVED] Excel VBA Code Instead of SumIf Array Formula for Unique Values
    By excelforumkeys in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-12-2014, 03:39 PM
  5. [SOLVED] Formula to extract unique values from two excel tabs and sort alphabetically
    By rshukla in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-06-2013, 01:48 PM
  6. Excel 2007 - Formula or VBA to find unique names and return values?
    By kjwaller in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-02-2013, 09:09 PM
  7. Replies: 8
    Last Post: 12-30-2008, 12: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