Excel formula to sort or filter rows based on a cell value

I am attaching here with the sample sheet with my vba which which give you filtered rows based in cell value g1 it searches column c and filter rows

can it be done through any formula

as my ultimate purpose is to make web page of my excel which is not possible along with my vba

kindly help

I think you forgot to attach your sample Excel workbook.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post. Don't use the Paperclip icon, as it doesn't work on this forum.

Hope this helps.

Pete

Sample is attached

Now uploaded sir

mostly importantly the search is not case sensitive

So, you only want to filter based on column C, and the filtering is based around what you put in cell G1 ?

If you are hoping to filter using formulae, it would be better to do so on another sheet - you enter the filter parameter in one cell (like you do at the moment) and the filtered results are shown in columns A to C of that sheet. The data in Sheet1 remains unchanged.

Is this acceptable to you?

Pete

Actually i want to use it on my android ph and android does not support vba so i thought of using formulas.

Kindly help that way sir

I want something which can serve my this purpose over my android ph

Take a look at the attached file. I've not changed your Sheet1, and set everything up in Sheet2.

Put your desired word in G1 (coloured yellow), and the appropriate data is shown filtered in columns A to C.

I don't know if this will work in android - you'll have to test it out yourself.

Hope this helps.

Pete

Yes sir that is what was required ,but in my excel number of rows are more than 10000
So formulas are taking too much time with processors.

It might be a bit quicker if you change the formula in F2 of Sheet2 to this:

=IF(Sheet1!C2="","-",IF(ISNUMBER(SEARCH(" "&$G$1&" "," "&Sheet1!C2&" ")),COUNTIF(F$1:F1,">0")+1,"-"))

and copy it down. I've changed the MAX to COUNTIF.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark this thread as SOLVED.

Also, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Hope this helps.

Pete

Note also, that although the formula in column F needs to be copied down for as much data as you have in Sheet1 (i.e. 10,000+ rows), the formulae in columns A:C do not need to be copied as far - just sufficient to display the amount of data after filtering.

Pete