Link to home
Start Free TrialLog in
Avatar of nike_golf
nike_golfFlag for Afghanistan

asked on

Auto filtering question...

I'm using the AutoFilter on my data however my data has some columns that are used for formatting. When the user selects to sort either ascending or descending the numbers get out of sink due to the columns, can this be addressed somehow?

NG,
Avatar of Rory Archibald
Rory Archibald
Flag of United Kingdom of Great Britain and Northern Ireland image

If you select the entire range before sorting, there shouldn't be a problem unless the formulas refer relatively to cells on other rows, in which case it will all go wrong. Hard to suggest much without more info, I'm afraid.
Avatar of nike_golf

ASKER

Tried selecting the entire range with similar results... the columns get out of wack.

Is there a way to remove the ASC/DESC capability from the sorting feature, I assume there isn't.

Thanks,
 
Nope. To me that implies your formulas are looking at different rows.
Actually the data that is being filtered is in "values" only format but does contain Subtotals.

NG,
Presumably it's the subtotals that are going wrong?
No actually the rows are getting out of wack and the subtotals appear to be holding together.

The report has some blank columns between populated columns and that is what seems to be throwing it off. If I delete the columns then sorting seems to be working.

NG,

ASKER CERTIFIED SOLUTION
Avatar of Rory Archibald
Rory Archibald
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial