replacing values

[ctrlrowdim]

In this project I need to replace the values of a random list for the values of those numbers in a positional list. every number must be replace for the place is found for the first time only, when the same number show up again will be replace for the next position I attach example images replace thoundsand ideas so.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	6	20	25	31	32	45		1	2	3	4	5	6
2	8	17	24	34	40	41		7	8	9	10	11	12
3	6	12	14	30	40	41		13	14	15	16	17	18
4	2	5	13	28	31	41		19	20	21	22	23	24
5	2	4	8	10	30	33		25	26	27	28	29	30
6	1	9	10	21	33	35		31	32	33	34	35	36
7	15	31	32	33	38	49		37	38	39	40	41	42
8	7	12	27	29	42	45		43	44	45	46	47	48
9		17	20	24	25	34		49	50	51	52	53	54
10	6	14	30	40	50	53		55	56	57	58	59	60
11	INPUT LIST							POSITION REFERENCE
12
13
14	OUTPUT LIST
15	13	51	53	23	39	48
16	27	50	52	54	17	18
17	55	44	56	29	58	24
Sheet3

 

[ilovepurple]

Sorry can you illustrate with an example?

6 in your input list becomes 13 in the output list using a position reference of 13, how does that work?

Could you explain for 2-3 values so it will be easier for us to understand what is happening?

 

[Marcelo Branco]

Maybe

Array formula in A15

=INDIRECT(TEXT(MIN(IF($A2:$F$10=A1,ROW($A2:$F$10)*10^4+(COLUMN($A2:$F$10)+7))),"R0000C0000"),0)

confirmed with Ctrl+Shift+Enter
(hold down both Ctrl and Shift keys and hit Enter)

copy across till F15 and down

M.

 

[ctrlrowdim]

every row has to be replace for the position number.
in A1 you see no.6 so replace no. is like you ask, WHERE 6 WAS RIGHT BEFORE HERE, the answer is in A3 and A3 = H3, and H3=13. another example no.41, is in F2, where was before here, in F3 and F3=M3 (M3=18)
when you get to F3 is the same 41, and the same question, where was right before this position, answer F4=M4=24. do you understand now.

 

[Marcelo Branco]

every row has to be replace for the position number.
in A1 you see no.6 so replace no. is like you ask, WHERE 6 WAS RIGHT BEFORE HERE, the answer is in A3 and A3 = H3, and H3=13. another example no.41, is in F2, where was before here, in F3 and F3=M3 (M3=18)
when you get to F3 is the same 41, and the same question, where was right before this position, answer F4=M4=24. do you understand now.

The Output List in your example has only 3 rows, so try the formula i posted above (must be comfirmed with Ctrl+Shift+Enter, not just Enter)

M.

 

[ctrlrowdim]

thanks marcelo, My real data is A1:F3000 that's why I am looking for a code, but I will try in small data your idea, thank you, thank you.