grifdoogindoggy
New Member
- Joined
- Aug 27, 2019
- Messages
- 21
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.
=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.