Results 1 to 2 of 2

Thread: Excel Delete/Ignore Values
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Aug 2019
    Posts
    21
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Excel Delete/Ignore Values

    I want to create a formula that can filter information. Right now I have the following formula:

    =IF($J$5=A:A,B:B)

    $J$5 is a date, and if that date matches the date in column A, then give me the text in column B. This is then pulled down for however many times that date is found, so I get something that looks like this:

    FALSE
    FALSE
    0
    "text"
    "text"
    "text"

    If that makes sense. For cells that are empty it returns a 0, and for cells that are not equal to the date it returns FALSE, as it should. I would like to find a way to just return the cells that match the date without using a VBA, if that makes sense.

    Thank you.

  2. #2
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    28,298
    Post Thanks / Like
    Mentioned
    471 Post(s)
    Tagged
    47 Thread(s)

    Default Re: Excel Delete/Ignore Values

    Is this what you mean?
    =IF($J$5=A5,B5,"")
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •