Filter / Sort Question

[nickspring]

I am trying to filter and/or sort a data series, but it is not working. Every cell in the series is driven by a formula pulling info from other cells in the workbook, but I don't think that should be an issue because I have similar setups in other workbooks and it works fine. Any idea why filtering/sorting may not work? Thanks

 

[Fazza]

sheet protection?

 

[nickspring]

sheet protection?

I apologize for my vague question, but I have solved it. I was using relative references. Upon changing them to absolute references, the sorting works fine. Thanks.

 

[Fluff]

I have solved it

Did you?

Cross posted https://www.excelforum.com/excel-general/1246836-filter-sort-question.html

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[nickspring]

Did you?

Cross posted https://www.excelforum.com/excel-general/1246836-filter-sort-question.html

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

OK. Again, I am new to these boards and was not aware of cross-posting rules. I apologize and now I know for the future. FYI - I posted the second Q after I noticed many views and no responses to my original Q. I now understand that the original Q was too vague. Thanks.