Use hidden information for filtering data

54 views Asked by At

When I filter information - let's say I want to see only Panasonic computers. Is it possible that information begin from 1 to 1000? NOT 1,12,13,14,50,57,100. Because in my case, hidden information doesn't let me use formulas from other sheet.

enter image description here

1

There are 1 answers

0
Albance On BEST ANSWER

I used pivot table as Matt said :)