Rows below Sort & Filter range not showing after filter selections

D

dwarnimont

Board Regular
Joined
Jan 12, 2010
Messages
71
I have sort and filter applied to range A1:Z100. the SUM formula applied within the sort and filter data area is outside the sort and filter range in ROW 101. When i apply a filter selection criteria, row 101 is hidden. data much further below the the filter range does show. It's like my row 101 is somehow attached to the filter. Any idea what causes this?
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
You must log in or register to reply here.

Similar threads

A
  • Question
Dynamically add new rows via VBA when using IFERROR TEXTJOIN and FILTER formulas from Table?
Replies
0
Views
162
AlfredDB
A
L
  • Solved
Dynamic Named Range not working with Userform ComboBox
Replies
6
Views
491
NoSparks
N
R
  • Question
Advanced Filter Macro works until I run a different Advanced Filter Macro in same workbook
Replies
1
Views
140
rdarrylhudson
R
B
  • Question
VBA code to cut and paste multiple filtered rows based on multiple criteria
Replies
2
Views
595
Alex Blakenburg
A
J
  • Question
Automatically setting filters based upon user selection criteria
Replies
1
Views
169
John_w
J

Forum statistics

Threads
1,215,716
Messages
6,126,417
Members
449,314
Latest member
MrSabo83

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top