How to get unique sorted indices of a list?

[JenniferMurphy]

Is there a way to get a set of unique (integer) indices into a list of numbers with no duplicates?

In this minisheet, the Values row has the list of numbers. There are duplicates. There are 2 2's and 3 3's.

The Rank.Eq row has the sorted indices, but there are duplicates. The Rank.Avg has the sorted indices, but there are fractions and duplicates. The Solution row has the indices I would like to get, but I would also be happy with the alternate indces on the next row. Is there a way to get it?

Sorting.xlsx
	B	C	D	E	F	G	H	I	J
8	Values	3	6	2	3	1	2	8	3
9	Rank.Eq	3	2	6	3	8	6	1	3
10	Rank.Avg	4	2	6.5	4	8	6.5	1	4
11	Solution	4	7	2	5	1	3	8	6
12		/5/6		/3	/4/6		/2		/4/5
Sheet2

Cell Formulas
Range	Formula
C9:J9	C9	=RANK.EQ(Values,Values)
C10:J10	C10	=RANK.AVG(Values,Values)

Named Ranges
Name	Refers To	Cells
Values	=Sheet2!$C$8:$J$8	C9:J10

Thanks

 

[Peter_SSs]

What about

=SORTBY(SEQUENCE(,COUNT(Values)),Values)

 

[JenniferMurphy]

What about

=SORTBY(SEQUENCE(,COUNT(Values)),Values)

Just like magic!

Row 11, your solution, is identical to Row 9, the solution I wanted. I wasn't aware of SortBy. And I searched several times for ways to search. But what does your formula do that mine in Row 12 does not?

Sorting.xlsx
	B	C	D	E	F	G	H	I	J
7	Index	1	2	3	4	5	6	7	8
8	Values	3	6	2	3	1	2	8	3
9	Solution wanted	5	3	6	1	4	8	2	7
10	Access via solution	1	2	2	3	3	3	6	8
11	PeterSS	5	3	6	1	4	8	2	7
12	Simpler?	5	3	6	1	4	8	2	7
Sheet2

Cell Formulas
Range	Formula
C10:J10	D10	=INDEX(Values,1,D9)
C11:J11	C11	=SORTBY(SEQUENCE(,COUNT(Values)),Values)
C12:J12	C12	=SORTBY(Indices,Values,1)
Dynamic array formulas.

Named Ranges
Name	Refers To	Cells
Indices	=Sheet2!$C$7:$J$7	C12
Values	=Sheet2!$C$8:$J$8	D10:J10, C10:C12

Thank you

 

[Peter_SSs]

But what does your formula do that mine in Row 12 does not?

It is more what your formula does that mine does not. Your formula uses a named range that was not given in post 10 (or post 5) and, as such, it also uses values that were described as ..

Row 7 is just for illustration.

.. and were not given in the original information. I took that to mean that they were not actually there in your real data and you put them in post 10 (&5) simply to help us understand what you wanted.