• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to filter single digit or double digit or triple digit

Oscarr

Member
Hi,

any formula that can filter in once single digit or double digit or triple digit or more than that?

Thanks
 

Attachments

  • simple.xlsx
    10.8 KB · Views: 12
Using the FILTER function, which is associated with dynamic arrays and is only available in some versions of Office 365,
= FILTER(number, LEN(number)=@n, "" )
 
Back
Top