+ Reply to Thread
Results 1 to 4 of 4

Replace formula for Empty cells !

  1. #1
    Forum Contributor
    Join Date
    05-20-2016
    Location
    Detroit
    MS-Off Ver
    Office 365 Version 2008 (July 2020)
    Posts
    773

    Replace formula for Empty cells !

    Hi,
    I have this simple formula : FILTER(RANGE,CONDITION)
    But if in Range are Empty cells, with formula I get 0 for those cells
    So then I replaced with IF(FILTER(RANGE,CONDITION)="","",FILTER(RANGE,CONDITION))
    How can I write it different way ?
    Thank all ...

  2. #2
    Forum Expert
    Join Date
    07-06-2004
    Location
    Northern California
    MS-Off Ver
    2K, 2003, 2010, O365
    Posts
    1,443

    Re: Replace formula for Empty cells !

    You show your Excel version as 2016, but if so, you don't have the FILTER function. If you do have the FILTER function, you should update your profile to show all the Excel versions you use.

    Do you need the blank cells returned? If not,
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    If your actual Excel version includes the LET function,
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by hrlngrv; 11-16-2020 at 08:22 PM. Reason: simplification

  3. #3
    Forum Contributor
    Join Date
    05-20-2016
    Location
    Detroit
    MS-Off Ver
    Office 365 Version 2008 (July 2020)
    Posts
    773

    Re: Replace formula for Empty cells !

    thank you, to me, second work, first no

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 11 64-bit)
    Posts
    53,334

    Re: Replace formula for Empty cells !

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

+ 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. Replace empty values from CONCATENA formula
    By glausantos in forum Excel General
    Replies: 4
    Last Post: 10-22-2019, 02:18 AM
  2. Replace Empty Text/Space in all Empty Cells
    By bhenlee in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-04-2018, 10:07 PM
  3. Replace empty cells in range variable
    By s80NL in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-28-2016, 06:50 PM
  4. Replies: 5
    Last Post: 01-12-2013, 12:16 AM
  5. [SOLVED] Replace empty cells with zero in a range
    By Snoopy2003 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-23-2012, 06:35 PM
  6. Replace empty cells with blank space
    By charles.2345 in forum Excel General
    Replies: 10
    Last Post: 08-02-2008, 08:31 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