Hi guys,
I have an array formula in column B cells that removes duplicates from column A. Unfortunately, column B displays 0 instead of the real values because it's a circular reference formula.
I've tried changing the number of iterations and maximum change, this time I get my values but in an disorderly way compared to the values in column A.
I would like to remove duplicates from column A and keep them from smallest to biggest. What values should I use for number of iterations and maximum change?
Here attached is the workbook sample.
Thanks for your help.
Bookmarks