Hi!
I have data with duplicate values and errors in a Col. range as:
1
2
3
4
3
2
#N/A
3
1
In order to get a clean list with unique values and without errors (row with errors replaced with blank cells in end result), I am undertaking following steps:
1. I use
to remove errors from original list;
2. I use
to rank data (this assigns duplicate ranks to same values and gives errors for blank cells);
3. I use
to remove errors from rank list;
4. I use
to assign unique ranks to duplicate values;
5. I use
to remove errors from unique rank list
I was wondering if the above steps can be reduced/ no. of columns/ calculations reduced to get a clean list without errors with unique ranks assigned to duplicate values
Sample file attached.
Regards,
Naira