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...
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
HansVogelaar thank you very kindly for being willing to look at the problem, which may help others. I am working on making a reduced and simplified version of the workbook that will show the full problem, and will soon be able to submit it.