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