Sort of minimum 5 from the list of series from 1 to 50 along with its ties.

[shekharverma]

There are two columns say A & B. Total 50 numbers are inserted in column A ie A1 ..A50(numbers can be same like 20 can come more than one time or upto 50 nos.). In front of every row of A1 there is a coding mark in B ie B1 to B50.(Coding like c26, c6, c35 etc.). I want to highlight lowest 5/6/10 figures from column A1 to A50(which can be same for eg. 2 in A1, 2 in A6, 2 in A7) in column c from C1 to desired requiremnt. Along with it the coding wriiten in front of A1 to A50 ie B1 to B50 should also be marked in front of C1 to desered requirement ie D1 to desired requirement. For Eg.
A B C D
1 2 C26 1 H15
2 5 W11 1 S02
3 1 H15 1 W02
4 3 c02 1 C06
5 1 S02 1 C09
6 1 W02
7 1 c06
8 7 c08
9 1 c09
10 9 c07

Lowest 5 from column A1 to A10 is indicated in clolumn C1 to C5 & coding of minumum 5 from column A highlighted in column B is reflected in column D.

 

[Robert Mika]

Hello and welcome
C1:
=SMALL($A$3:$A$12,ROW(A1))
D1
=INDEX($B$3:$B$12,SMALL(IF($A$3:$A$12=$C3,ROW($A$3:$A$12)-ROW($A$3)+1),COUNTIF($C$3:C3,C3)))
Confirm Control+shift+Enter

 

[shekharverma]

Thank you very much..Sir..

 

[Robert Mika]

You are welcome