Filter question

bknight
5StarLounger
Posts: 767
Joined: 08 Jul 2016, 18:53

Filter question

Post by bknight »

A question concerning filters. I have a spreadsheet with filters in the column headers row 1 then mostly blank cells until data beginning in row 6.
When applying filters the data isn't filtered contains all still. What Am I doing wrong here

User avatar
HansV
Administrator
Posts: 72885
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Filter question

Post by HansV »

The filter range is probably only the header row.
Try the following:
- Turn off the filter.
- Select the entire range that you want to filter.
- Turn on the filter.
Regards,
Hans

bknight
5StarLounger
Posts: 767
Joined: 08 Jul 2016, 18:53

Re: Filter question

Post by bknight »

That seemed to work.

bknight
5StarLounger
Posts: 767
Joined: 08 Jul 2016, 18:53

Re: Filter question

Post by bknight »

Related to the filter. There is a column that only contains simple addition formulas and a column of values that leads to the additions. The two sums of the columns are different and should be identical. Is there a way to check the formulas columns to identify any value cells that might be omitted or duplicated? Neither of these two conditions should occur.

ETA:
The value cells are positive and negative and the addition formulas for the most part are 2 cell additions with a smattering of three cell additions.

User avatar
HansV
Administrator
Posts: 72885
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Filter question

Post by HansV »

If the number of discrepancies is small, you could use conditional formatting to highlight them, then inspect the formulas in the highlighted cells.

Otherwise, I'd have to see a copy of the workbook.
Regards,
Hans

bknight
5StarLounger
Posts: 767
Joined: 08 Jul 2016, 18:53

Re: Filter question

Post by bknight »


User avatar
HansV
Administrator
Posts: 72885
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Filter question

Post by HansV »

Thanks - what should I look at?
(It'll have to be tomorrow. Off to bed now)
Regards,
Hans

bknight
5StarLounger
Posts: 767
Joined: 08 Jul 2016, 18:53

Re: Filter question

Post by bknight »

The values are in column G, the formulas are in column O Gx + Gx+1 for the most part but not all.

User avatar
HansV
Administrator
Posts: 72885
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Filter question

Post by HansV »

i'm afraid I don't have the slightest idea, sorry.
Regards,
Hans

bknight
5StarLounger
Posts: 767
Joined: 08 Jul 2016, 18:53

Re: Filter question

Post by bknight »

ok