I got it. What I was looking for this.
=(MATCH(SMALL($H$3:$H$14,1),$H$3:$H$14, 0))&"-"&=(MATCH(SMALL($H$3:$H$14,2),$H$3:$H$14, 0))&"-"&=(MATCH(SMALL($H$3:$H$14,3),$H$3:$H$14, 0))&"-"&=(MATCH(SMALL($H$3:$H$14,4),$H$3:$H$14, 0))
although in question I asked I should have used D and not H
|