Hello everyone!
I have a relatively simple question and I hope someone can help.
Can you please have a look in the enclosed sample excel file. I want to filter data, but not with the normal Filter function, but rather by typing the value which should be filtered in a specific cell. In my example, I would like to put a 1, 2 or 3 in cell C2 with the result that only the respective number is displayed and the other ones are hided (just what the normal filter function does).
I know that I can type the number I am looking for in the "Search" field when I click on the filter button of cell C3, but I need to put the number in a specific cell, which is C2 in this case.
I hope you understand what I mean. I really need help as I need to do this for a huge excel file.
Thanks!
Bookmarks