Forum Discussion
Sortby and Filter together - Circular Reference Error
I am trying to sort (using SORTBY) a filter array on two columns, one which is value derived from another of the columns in the range being filtered. I get an error saying that there's a circular re...
Thanks for sharing the your experience. I'm also sort of new to Excel, and I find the site you mentioned helpful. Being a able to use sources not in the dataset (but of the same size) is one of the main benefits of SORTBY I think.
Well, my solution is really a failure, since I only brought the needed columns into the filtered array because my reference to them otherwise had not worked. You are right that the advantage of SORTBY was therefore wasted. If you are very curious I would share the workbook with you privately…. It has kind of a inane purpose so I don't want to unleash it publicly. Maybe you could do better with the formula that defeated me.
My sheet had room for the superfluous columns, but I put them in white font to make the data in them invisible to the user. I’m embarrassed — it took me a lot of time to reach that point of exasperation.
My sheet had room for the superfluous columns, but I put them in white font to make the data in them invisible to the user. I’m embarrassed — it took me a lot of time to reach that point of exasperation.
- No need to share this particular one. But in the future, I'd love to look at similar tasks where the data is not sensitive. Have a great day!