This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi all
I have created a basic FILTER function, as shown. It works fine, however, I've just realised that when the data doesn't meet the criteria I have specified, it simply returns nothing - not the text "No entries"? Can anybody see what I've done wrong? TIA, Louise
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Thank you for spending time on this for me, it's appreciated. If I selected the range without the headings, would it solve the problem and then I could use my original formula? Thanks, Louise
Ah, thanks. That is still in Beta. I'm on the Current Channel.
Oh! Usually, no one is interested. Anyway, see the following:
Is that in an Insider version of Excel? Or in Google Sheets?
Oh. I thought everyone had this for a while. It trims the range from both the start, and end of the input range.
The bug for the entire column was recently fixed on my system.