how to Find the cell position of a Duplicated smallest values in a data set ?

[Anjelo]

Hello every one ..
If i have a data set like this one in the attached picture ,
Is there any way to find the positions as a result in column "P" by finding the the smallest values in column "O".
Notes that there are a duplicated smallest values in different positions in the data set.

 

[Fluff]

Removed, as there was an error.

 

[Fluff]

Hi & welcome to MrExcel.
How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1
2		V1	V2	V3	V4	V5	V6	V7	V8	V9	V10
3	P1	125	1056	284	1551	156	231	1938	1929	1060	1148			1	48	P8	V9
4	P2	159	1757	540	1638	1952	317	1356	1441	1039	52			2	52	P2	V10
5	P3	1774	1470	1441	333	299	1486	259	1134	117	1119			3	52	P6	V1
6	P4	746	765	117	817	1363	1236	460	1824	687	1048			4	66	P11	V6
7	P5	658	1727	287	1154	1158	770	1484	709	1581	888			5	99	P12	V10
8	P6	52	117	1763	1873	139	1626	1155	1142	117	791			6	117	P3	V9
9	P7	1112	162	1060	628	1214	1326	149	436	721	1172			7	117	P4	V3
10	P8	1923	1327	222	135	710	334	1337	1215	48	845			8	117	P6	V2
11	P9	157	240	119	1073	839	1602	1594	430	1014	1552			9	117	P6	V9
12	P10	1697	126	325	1901	231	551	1761	1813	1851	1578			10	119	P9	V3
13	P11	1707	809	949	1373	1878	66	1735	249	1048	593			11	125	P1	V1
14	P12	1572	379	538	1145	126	935	559	514	1159	99			12	126	P10	V2
15														13	126	P12	V5
16														14	135	P8	V4
17														15	139	P6	V5
Main

Cell Formulas
Range	Formula
O3:O17	O3	=SMALL($B$3:$K$14,N3)
P3:P17	P3	=INDEX($A$3:$A$14,INT((AGGREGATE(15,6,ROW($1:$120)/(FILTERXML("<k><m>"&TEXTJOIN("</m><m>",,$B$3:$K$14)&"</m></k>","//m")=O3),COUNTIFS(O$3:O3,O3))-1)/10)+1)
Q3:Q17	Q3	=INDEX($B$2:$K$2,MOD(AGGREGATE(15,6,ROW($1:$120)/(FILTERXML("<k><m>"&TEXTJOIN("</m><m>",,$B$3:$K$14)&"</m></k>","//m")=O3),COUNTIFS(O$3:O3,O3))-1,10)+1)

 

[Anjelo]

Hi & welcome to MrExcel.
How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1
2		V1	V2	V3	V4	V5	V6	V7	V8	V9	V10
3	P1	125	1056	284	1551	156	231	1938	1929	1060	1148			1	48	P8	V9
4	P2	159	1757	540	1638	1952	317	1356	1441	1039	52			2	52	P2	V10
5	P3	1774	1470	1441	333	299	1486	259	1134	117	1119			3	52	P6	V1
6	P4	746	765	117	817	1363	1236	460	1824	687	1048			4	66	P11	V6
7	P5	658	1727	287	1154	1158	770	1484	709	1581	888			5	99	P12	V10
8	P6	52	117	1763	1873	139	1626	1155	1142	117	791			6	117	P3	V9
9	P7	1112	162	1060	628	1214	1326	149	436	721	1172			7	117	P4	V3
10	P8	1923	1327	222	135	710	334	1337	1215	48	845			8	117	P6	V2
11	P9	157	240	119	1073	839	1602	1594	430	1014	1552			9	117	P6	V9
12	P10	1697	126	325	1901	231	551	1761	1813	1851	1578			10	119	P9	V3
13	P11	1707	809	949	1373	1878	66	1735	249	1048	593			11	125	P1	V1
14	P12	1572	379	538	1145	126	935	559	514	1159	99			12	126	P10	V2
15														13	126	P12	V5
16														14	135	P8	V4
17														15	139	P6	V5
Main

Cell Formulas
Range	Formula
O3:O17	O3	=SMALL($B$3:$K$14,N3)
P3:P17	P3	=INDEX($A$3:$A$14,INT((AGGREGATE(15,6,ROW($1:$120)/(FILTERXML("<k><m>"&TEXTJOIN("</m><m>",,$B$3:$K$14)&"</m></k>","//m")=O3),COUNTIFS(O$3:O3,O3))-1)/10)+1)
Q3:Q17	Q3	=INDEX($B$2:$K$2,MOD(AGGREGATE(15,6,ROW($1:$120)/(FILTERXML("<k><m>"&TEXTJOIN("</m><m>",,$B$3:$K$14)&"</m></k>","//m")=O3),COUNTIFS(O$3:O3,O3))-1,10)+1)

thank you so much ... it looks exactly what i am looking for ,, but i got an issues that the calculation is not correct like in the attached picture
thank you again

 

[Fluff]

For that range you would need to use

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1
2
3			V1	V2	V3	V4	V5	V6	V7	V8	V9	V10	V11	V12
4		P1	125	1056	284	1551	156	231	1938	1929	1060	1148	1108	875		1	27	P19	V11
5		P2	159	1757	540	1638	1952	317	1356	1441	1039	52	1222	161		2	30	P18	V6
6		P3	1774	1470	1441	333	299	1486	259	1134	117	1119	1288	333		3	48	P8	V9
7		P4	746	765	117	817	1363	1236	460	1824	687	1048	414	1704		4	52	P2	V10
8		P5	658	1727	287	1154	1158	770	1484	709	1581	888	498	1133		5	52	P6	V1
9		P6	52	117	1763	1873	139	1626	1155	1142	117	791	695	1943		6	55	P17	V7
10		P7	1112	162	1060	628	1214	1326	149	436	721	1172	1406	110		7	61	P9	V11
11		P8	1923	1327	222	135	710	334	1337	1215	48	845	1779	1467		8	66	P11	V6
12		P9	157	240	119	1073	839	1602	1594	430	1014	1552	61	97		9	75	P13	V4
13		P10	1697	126	325	1901	231	551	1761	1813	1851	1578	756	1915		10	89	P20	V4
14		P11	1707	809	949	1373	1878	66	1735	249	1048	593	1980	1539		11	92	P20	V7
15		P12	1572	379	538	1145	126	935	559	514	1159	99	832	209		12	97	P9	V12
16		P13	766	681	421	75	494	819	1885	1859	1521	1084	530	1856		13	99	P12	V10
17		P14	1911	1234	394	566	1666	127	745	591	220	1176	1953	673		14	110	P7	V12
18		P15	1930	1236	725	1194	844	1688	697	681	1197	403	831	686		15	117	P3	V9
19		P16	544	475	887	1948	1057	377	438	1468	629	587	121	1955
20		P17	1303	1643	1948	1860	1673	1719	55	1847	233	1477	677	620
21		P18	1785	1501	1372	1821	974	30	1175	1407	1847	215	1772	1883
22		P19	1276	552	284	1856	185	1841	1969	388	157	213	27	1211
23		P20	154	758	1576	89	1547	234	92	1172	1114	1919	250	317
Main

Cell Formulas
Range	Formula
Q4:Q18	Q4	=SMALL($C$4:$N$23,P4)
R4:R18	R4	=INDEX($B$4:$B$23,INT((AGGREGATE(15,6,ROW($1:$240)/(FILTERXML("<k><m>"&TEXTJOIN("</m><m>",,$C$4:$N$23)&"</m></k>","//m")=Q4),COUNTIFS(Q$4:Q4,Q4))-1)/12)+1)
S4:S18	S4	=INDEX($C$3:$N$3,MOD(AGGREGATE(15,6,ROW($1:$240)/(FILTERXML("<k><m>"&TEXTJOIN("</m><m>",,$C$4:$N$23)&"</m></k>","//m")=Q4),COUNTIFS(Q$4:Q4,Q4))-1,12)+1)

 

[Fluff]

For reference with this

=INDEX($B$4:$B$23,INT((AGGREGATE(15,6,ROW($1:$240)/(FILTERXML("<k><m>"&TEXTJOIN("</m><m>",,$C$4:$N$23)&"</m></k>","//m")=Q4),COUNTIFS(Q$4:Q4,Q4))-1)/12)+1)

The part in blue needs to be the total number of cells being looked at. C4:N23 = 240 cells.
The part in Red is the number of columns being looked at. C4:N4 =12 columns

 

[Anjelo]

For that range you would need to use

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1
2
3			V1	V2	V3	V4	V5	V6	V7	V8	V9	V10	V11	V12
4		P1	125	1056	284	1551	156	231	1938	1929	1060	1148	1108	875		1	27	P19	V11
5		P2	159	1757	540	1638	1952	317	1356	1441	1039	52	1222	161		2	30	P18	V6
6		P3	1774	1470	1441	333	299	1486	259	1134	117	1119	1288	333		3	48	P8	V9
7		P4	746	765	117	817	1363	1236	460	1824	687	1048	414	1704		4	52	P2	V10
8		P5	658	1727	287	1154	1158	770	1484	709	1581	888	498	1133		5	52	P6	V1
9		P6	52	117	1763	1873	139	1626	1155	1142	117	791	695	1943		6	55	P17	V7
10		P7	1112	162	1060	628	1214	1326	149	436	721	1172	1406	110		7	61	P9	V11
11		P8	1923	1327	222	135	710	334	1337	1215	48	845	1779	1467		8	66	P11	V6
12		P9	157	240	119	1073	839	1602	1594	430	1014	1552	61	97		9	75	P13	V4
13		P10	1697	126	325	1901	231	551	1761	1813	1851	1578	756	1915		10	89	P20	V4
14		P11	1707	809	949	1373	1878	66	1735	249	1048	593	1980	1539		11	92	P20	V7
15		P12	1572	379	538	1145	126	935	559	514	1159	99	832	209		12	97	P9	V12
16		P13	766	681	421	75	494	819	1885	1859	1521	1084	530	1856		13	99	P12	V10
17		P14	1911	1234	394	566	1666	127	745	591	220	1176	1953	673		14	110	P7	V12
18		P15	1930	1236	725	1194	844	1688	697	681	1197	403	831	686		15	117	P3	V9
19		P16	544	475	887	1948	1057	377	438	1468	629	587	121	1955
20		P17	1303	1643	1948	1860	1673	1719	55	1847	233	1477	677	620
21		P18	1785	1501	1372	1821	974	30	1175	1407	1847	215	1772	1883
22		P19	1276	552	284	1856	185	1841	1969	388	157	213	27	1211
23		P20	154	758	1576	89	1547	234	92	1172	1114	1919	250	317
Main

Cell Formulas
Range	Formula
Q4:Q18	Q4	=SMALL($C$4:$N$23,P4)
R4:R18	R4	=INDEX($B$4:$B$23,INT((AGGREGATE(15,6,ROW($1:$240)/(FILTERXML("<k><m>"&TEXTJOIN("</m><m>",,$C$4:$N$23)&"</m></k>","//m")=Q4),COUNTIFS(Q$4:Q4,Q4))-1)/12)+1)
S4:S18	S4	=INDEX($C$3:$N$3,MOD(AGGREGATE(15,6,ROW($1:$240)/(FILTERXML("<k><m>"&TEXTJOIN("</m><m>",,$C$4:$N$23)&"</m></k>","//m")=Q4),COUNTIFS(Q$4:Q4,Q4))-1,12)+1)

Thank you soooooooooooo much ... Now everything is 100% correct ,,

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Fluff]

If you're interested, 2simpler formulae

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q			T	U
1
2
3			V1	V2	V3	V4	V5	V6	V7	V8	V9	V10	V11	V12
4		P1	125	1056	284	1551	156	231	1938	1929	1060	1148	1108	875		1	27			P19	V11
5		P2	159	1757	540	1638	1952	317	1356	1441	1039	52	1222	61		2	30			P18	V6
6		P3	1774	1470	1441	333	299	1486	259	1134	117	1119	1288	333		3	48			P8	V9
7		P4	746	765	117	817	1363	1236	460	1824	687	1048	414	1704		4	52			P2	V10
8		P5	658	1727	287	1154	1158	770	1484	709	1581	888	61	1133		5	52			P6	V1
9		P6	52	117	1763	1873	139	1626	1155	1142	117	791	695	1943		6	55			P17	V7
10		P7	1112	162	1060	628	1214	1326	149	436	721	1172	1406	110		7	61			P2	V12
11		P8	1923	1327	222	135	710	334	1337	1215	48	845	1779	1467		8	61			P5	V11
12		P9	61	161	119	1073	61	1602	1594	430	1014	1552	61	97		9	61			P9	V1
13		P10	1697	126	325	1901	231	551	1761	1813	1851	1578	756	1915		10	61			P9	V5
14		P11	1707	809	949	1373	1878	66	1735	249	1048	593	1980	1539		11	61			P9	V11
15		P12	1572	379	538	1145	126	935	559	514	1159	99	832	209		12	66			P11	V6
16		P13	766	681	421	75	494	819	1885	1859	1521	1084	530	1856		13	75			P13	V4
17		P14	1911	1234	394	566	1666	127	745	591	220	1176	1953	673		14	89			P20	V4
18		P15	1930	1236	725	1194	844	1688	697	681	1197	403	831	686		15	92			P20	V7
19		P16	544	475	887	1948	1057	377	438	1468	629	587	121	1955
20		P17	1303	1643	1948	1860	1673	1719	55	1847	233	1477	677	620
21		P18	1785	1501	1372	1821	974	30	1175	1407	1847	215	1772	1883
22		P19	1276	552	284	1856	185	1841	1969	388	157	213	27	1211
23		P20	154	758	1576	89	1547	234	92	1172	1114	1919	250	317
Main

Cell Formulas
Range	Formula
Q4:Q18	Q4	=SMALL($C$4:$N$23,P4)
T4:T18	T4	=INDEX($B$4:$B$23,AGGREGATE(15,6,(ROW($B$4:$B$23)-ROW($B$4)+1)/($C$4:$N$23=Q4),COUNTIFS(Q$4:Q4,Q4)))
U4:U18	U4	=INDEX($C$3:$N$3,AGGREGATE(15,6,(COLUMN($C$3:$N$3)-COLUMN($C$3)+1)/($C$4:$N$23=Q4)/($B$4:$B$23=R4),COUNTIFS(Q$4:Q4,Q4,R$4:R4,R4)))

 

[Anjelo]

If you're interested, 2simpler formulae

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q			T	U
1
2
3			V1	V2	V3	V4	V5	V6	V7	V8	V9	V10	V11	V12
4		P1	125	1056	284	1551	156	231	1938	1929	1060	1148	1108	875		1	27			P19	V11
5		P2	159	1757	540	1638	1952	317	1356	1441	1039	52	1222	61		2	30			P18	V6
6		P3	1774	1470	1441	333	299	1486	259	1134	117	1119	1288	333		3	48			P8	V9
7		P4	746	765	117	817	1363	1236	460	1824	687	1048	414	1704		4	52			P2	V10
8		P5	658	1727	287	1154	1158	770	1484	709	1581	888	61	1133		5	52			P6	V1
9		P6	52	117	1763	1873	139	1626	1155	1142	117	791	695	1943		6	55			P17	V7
10		P7	1112	162	1060	628	1214	1326	149	436	721	1172	1406	110		7	61			P2	V12
11		P8	1923	1327	222	135	710	334	1337	1215	48	845	1779	1467		8	61			P5	V11
12		P9	61	161	119	1073	61	1602	1594	430	1014	1552	61	97		9	61			P9	V1
13		P10	1697	126	325	1901	231	551	1761	1813	1851	1578	756	1915		10	61			P9	V5
14		P11	1707	809	949	1373	1878	66	1735	249	1048	593	1980	1539		11	61			P9	V11
15		P12	1572	379	538	1145	126	935	559	514	1159	99	832	209		12	66			P11	V6
16		P13	766	681	421	75	494	819	1885	1859	1521	1084	530	1856		13	75			P13	V4
17		P14	1911	1234	394	566	1666	127	745	591	220	1176	1953	673		14	89			P20	V4
18		P15	1930	1236	725	1194	844	1688	697	681	1197	403	831	686		15	92			P20	V7
19		P16	544	475	887	1948	1057	377	438	1468	629	587	121	1955
20		P17	1303	1643	1948	1860	1673	1719	55	1847	233	1477	677	620
21		P18	1785	1501	1372	1821	974	30	1175	1407	1847	215	1772	1883
22		P19	1276	552	284	1856	185	1841	1969	388	157	213	27	1211
23		P20	154	758	1576	89	1547	234	92	1172	1114	1919	250	317
Main

Cell Formulas
Range	Formula
Q4:Q18	Q4	=SMALL($C$4:$N$23,P4)
T4:T18	T4	=INDEX($B$4:$B$23,AGGREGATE(15,6,(ROW($B$4:$B$23)-ROW($B$4)+1)/($C$4:$N$23=Q4),COUNTIFS(Q$4:Q4,Q4)))
U4:U18	U4	=INDEX($C$3:$N$3,AGGREGATE(15,6,(COLUMN($C$3:$N$3)-COLUMN($C$3)+1)/($C$4:$N$23=Q4)/($B$4:$B$23=R4),COUNTIFS(Q$4:Q4,Q4,R$4:R4,R4)))

thank you soooo much this one much more efficient ... ammazing