Forum Discussion
Sorting large IF AND Between statement issue
Help please! I'm going a little crazy; I have created a large IF and 'Between' statement that includes values from 2 different sheets to return certain values based upon where they sit within cer...
After you have all your formulas in the rows, you have to set a fixed referencing. So Scoring!$Q2 must become Scoring!$Q$2. Do the same with column V. You can easily do this automatically for all formulas at the same time by using the Find and Replace dialog.
Search: Scoring!$Q
Replace: Scoring!$Q$
Replace all
After that, the sorting should work.
Thank you dscheikey
I did what you suggested and still no luck. Any other thoughts? Is it perhaps something with using "1", vs an actual number?
I did what you suggested and still no luck. Any other thoughts? Is it perhaps something with using "1", vs an actual number?
That cannot be the reason. Text is also sorted. Excel interprets the text as a number.
Can you upload an example of your file? Please remove data that is not intended for the public. You can also send it to me as a direct message.