How to filter cell containing only 1 in between words but not 10 or 11 or 12 in a column?

Hi,
Here is the data for a column below:
class 1
class 10
class 12
class 11
class 1
class 1

So I want to filter the cells containing only class 1. so when I am using custom filter it is pulling all above data because in every cell it contains 1.
So kindly suggest me how to filter or any other technique to solve this problem.

Any suggestion highly appreciated?

Thanks in advance

Originally Posted by kbkumar

Hi - Did you try using Text Filters "Equals" Class 1?

That should give you just class 1 eliminating class 10 / 11 etc.

Originally Posted by kbkumar

Hi - Did you try using Text Filters "Equals" Class 1?

That should give you just class 1 eliminating class 10 / 11 etc.

Thanks for replying, I have already tried with "equals".... I know for above data that I have mentioned equals will work. Please have a look into below data. I am very sorry I have given less data.... Please look below to see data

class 1 question paper
class 10 sample paper
question paper class 12
best book class 11
cbse class 1
class 1 icse

So now please tell me how to filter data containing only class 1. I want result to be like below
class 1 question paper
cbse class 1
class 1 icse

Any suggestion greatly appreciated.

Thanks a lot.

Originally Posted by benishiryo

hi kalucharan. welcome to the forum. shouldn't have any problems if you filter "equals" "class 1". do not use "contains"

Originally Posted by kbkumar

Hi - Did you try using Text Filters "Equals" Class 1?

That should give you just class 1 eliminating class 10 / 11 etc.

Thanks for replying, I have already tried with "equals".... I know for above data that I have mentioned equals will work. Please have a look into below data. I am very sorry I have given less data.... Please look below to see data

class 1 question paper
class 10 sample paper
question paper class 12
best book class 11
cbse class 1
class 1 icse

So now please tell me how to filter data containing only class 1. I want result to be like below
class 1 question paper
cbse class 1
class 1 icse

Any suggestion greatly appreciated.

Thanks a lot.

Originally Posted by benishiryo

use a helper column then:
=ISNUMBER(SEARCH("class 1 ",A2&" "))

this is assuming data is in column A. then filter all the TRUEs

Hi,
I am using like below but result comes FALSE
ISNUMBER(SEARCH("class 1",A2:A6124&" "))

Originally Posted by kbkumar

Hi Kalucharan,

You need to use the formula given by Benishiryo in cell B2 and drag it down till B6124 to get True and False results. The one you are using in post #7 will not work.

Hi kbkumar,
I did the same as you suggested but I am getting all results like the cells containing 11 or 12 or 10.
Please suggest any other idea to solve this.
Thanks for your suggestion and any suggestion highly appreciated.

Hi kbkumar,
I have attached the spreadsheet, Please find and let me know if I am doing right or not.

Thanks
Kalu

Hi kbkumar,
I have uploaded the spreadsheet with the formula and let me know if this is right?

Thanks
Kalu

Originally Posted by kbkumar

You are missing a space. Use this:

Formula:

Please Login or Register  to view this content.

Hi kbkumar,
Thanks a lot for solving my previous problem by taking your valuable time. Here I have come with a new problem,Please read below:

Suppose I have 1000 data in column A and I want to categorize the column A data in column B. These 1000 data I want make into 4 categories in column B. So what I was thinking if I could have write single formula in column B and drag till the end, the each data cell of column A will fall respective category in column B. Please find the attachment to understand better.
In this sheet I have two columns Keyword and Category.
Condition:
If any cell containing "paper" or "question paper" or "sample papers" will come under category called Sample Paper in column B.
If any cell containing "syllabus" will come under category called Syllabus in column B.
If any cell containing "book" or "books" will come under category called Book in column B
I can solve this by using Filter in Column A but I want a formula which can be written in column B and drag till the end to get result.

Any suggestion or help highly appreciated.

Thanks in advance.

Originally Posted by kbkumar

Thanks for the feedback Kalucharan.

Regarding your new problem, Am afraid to say but as per the forum rules you would have to create a new thread and then it would be picked up / answered accordingly...

Hi kbkumar
I have already started a new thread but to remind you only I have replied in this thread because I was really happy when you solved my first thread problem. If it is as per forum rule then I respect it and from next time I will not commit such mistake. Thanks for reminding the forum rule.

Regards
Kalucharan