• 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.

I want to filter the values which begins with a particular number

Ram Mher

Member
Dear All

I have values from A1 to A15000 and values are like below
10025678
10123456
10224567
10021345
10045678

i want to filter those item only which begins with 100 only.

Please help and provide me the solution
 
Good day Ram

Just turn your data into a table and then filter on any numbers you want.
 
Dear friend
Data is already in Table and it is not easy to select each value manually so i need those values which begins with hundred. Reply please
 

Attachments

  • Filter.xlsx
    7.8 KB · Views: 4
When u filter & type 100 in search box You get the figures starting with 100 only. Hope it helps.
 
Dear it is not sucessful. whenI entered few more values in table and use your solution for 101 then few values are coming which are begining with 102 and 103. Refer attached sheet and provide the solution please
 

Attachments

  • Filter 2.xlsx
    7.8 KB · Views: 3
dear friend , Entered values are more than 1 lac and i do not know which value are to use in "greater than" and "Lower than" point. Therefore i need to implement the filter on those values only who are begining with a particular number I.e 101 or 102 or 103 etc...
 
Hi Ram,

I'm still trying to understand your requirement, but try this to get all the numbers begining with 100.
Put header in A1 called Numbers and in A2 Sorted Numbers, then in B2 put
="-"&A2 and copy down
Select your range columns A:B, Filter, then on the B filter, Begins with .... -100 > OK
You should now have all the ones begining with 100.
 
Dear Ram Mher
Think your data is from A1 to A6
Code
10025678
10123456
10221002
10021345
10045678
You want to filter the codes started by 100. So your result will be
10025678
10021345
10045678
Follow the steps..
1. Set filter the range A1:A6
2. Click on the filter combo (A1)
3. Write 100* in the search box
4. Click Ok button
Done!
Remember: If you write 100 instead of 100* then 10221002 this record will also shown in the output list.
 
Dear Ram Mher
Think your data is from A1 to A6
Code
10025678
10123456
10221002
10021345
10045678
You want to filter the codes started by 100. So your result will be
10025678
10021345
10045678
Follow the steps..
1. Set filter the range A1:A6
2. Click on the filter combo (A1)
3. Write 100* in the search box
4. Click Ok button
Done!
Remember: If you write 100 instead of 100* then 10221002 this record will also shown in the output list.
Thnaku very much for the solution.
I need to know one more thing related to this point. If i want to filter all the values which is begining with 100,101 and 102 etc.. then what should i do. Please reply.
 
Dear Nazmul

Please find the attached file also for getting the solution of my answer. Question is shown in the file also.
 
Back
Top