You are sorting the formulas as well as the data, so their references are moving as well. This will always happen when sorting formulas as far as I am aware, unless you convert to a multi-cell array formula
You are sorting the formulas as well as the data, so their references are moving as well. This will always happen when sorting formulas as far as I am aware, unless you convert to a multi-cell array formula
You should hit F5, because chances are I've edited this post at least 5 times.
Example of Array Formulas
Click the * below on any post that helped you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks