I have constructed a database spreadsheet to be distributed the different
branches. The formulas (which are frozen/locked cells) range in a column for
calculation of interest (suppose C1:C20000). The cases are coming upto 15000
in total listed in column "A". I have permitted the users to filter for
sorting out cases pertaining to their particular branch, branch names listed
in Column B.

Now if a branch, for instance, filters out its cases, the extra rows (for
further addition of cases, i.e. 15001:20000) also hide.

How can I opt to allow a branch for filtering data based on the logic of
blank rows (except for Column C, i.e. calculation formula) being shown
alongwith their branches' records?

Thank you all 4 your kind consideration.