I am playing with this formula, it works, but if no data is returned, I want the value to display No Data.
That part is not working. I am missing something, I appreciate any help.
=FILTER(INDEX(TData,SEQUENCE(ROWS(TData)),{1,2,3,4,6,7}),IF(1,TData[DATE]>=C3)*(TData[DATE]<=C4),”No Data”)
Thank you,
Nick
What does "not working" mean? What does it do instead of what you want?
The slanted quote marks you used in your post are not legal in Excel. That will get you a #NAME? error. You have to use just plain old quotes.
Formula:
Please Login or Register to view this content.
If that is not your problem, you will have to provide a sample workbook so we can see how your formula works. Do not just show a screenshot; we have to analyze the formula using your table and data.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
That was it 6StringJazzer, I had typed it up in word, didn't think about the quotes.
Glad that worked, and thanks for the rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks