Use hidden information for filtering data

72 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 best solutions below

0
On BEST ANSWER

I used pivot table as Matt said :)