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...
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.