+ Reply to Thread
Results 1 to 7 of 7

Return only cells that does not have "" value (not blank) from a range

  1. #1
    Registered User
    Join Date
    10-27-2020
    Location
    Slovakia
    MS-Off Ver
    365
    Posts
    5

    Smile Return only cells that does not have "" value (not blank) from a range

    Hello! I am going crazy... :D

    I have column A, column B and column C

    Column A: list (all cells have a value, a lot of duplicates)
    Column B: contains a formula that shows the values of column A but removes all the duplicates and places a blank cell instead of showing the duplicate, so what the formula does its that if it finds a duplicate then it shows "" (a blank value)
    Column C: I want simply the list present in column B without the blank cells, so I need the range in column B just with the cells that have a value, what formula will help achieve that please??

    Alternative request: if column B can just directly show the values of column A without the blank cells of the duplicates.

    Thanks in advance for precious help!
    Attached Files Attached Files
    Last edited by mako24; 10-27-2020 at 03:18 PM.

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,077

    Re: Return only cells that does not have "" value (not blank) from a range

    Hi & welcome to the board.
    How about
    =UNIQUE(FILTER(A2:A100,A2:A100<>""))

  3. #3
    Registered User
    Join Date
    10-27-2020
    Location
    Slovakia
    MS-Off Ver
    365
    Posts
    5

    Re: Return only cells that does not have "" value (not blank) from a range

    thanks but this is what happens when try to use your formula:

    0rac8vj.png

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,077

    Re: Return only cells that does not have "" value (not blank) from a range

    Are you using 365? If so can you install the latest updates?

  5. #5
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,077

    Re: Return only cells that does not have "" value (not blank) from a range

    if you can't install the latest updates, then try
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    10-27-2020
    Location
    Slovakia
    MS-Off Ver
    365
    Posts
    5

    Re: Return only cells that does not have "" value (not blank) from a range

    AMAZING! Works perfectly thank youuuuuuuuuu!!!

  7. #7
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,077

    Re: Return only cells that does not have "" value (not blank) from a range

    You're welcome & thanks for the feedback.

+ 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] If vlookup return blank means "paid", otherwise is "unpaid"
    By Dewdrop in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-12-2019, 05:51 AM
  2. [SOLVED] Return value from one of several cells if value is not "blank" or -100%"
    By thedrinkerparadox in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-13-2017, 02:34 PM
  3. [SOLVED] Copy cells from range "C3" to "F3" with loop and blank field
    By masterm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-16-2015, 01:03 PM
  4. Replies: 5
    Last Post: 01-23-2014, 11:02 AM
  5. If formula to return "yes" or "no" answer from a range of cells
    By mfairhurst1 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-02-2013, 05:00 PM
  6. Replies: 3
    Last Post: 04-14-2013, 11:53 PM
  7. Replies: 3
    Last Post: 02-16-2011, 02:55 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