frankyalta
New Member
- Joined
- Nov 8, 2015
- Messages
- 29
Hi,
I don't really know what title to write but i don't really know which nested formula i need to do this simple task.
I have 2 columns (1 column have numbers and each numbers have an score on second column)
I need to transpose the column with numbers and bellow i would like to display the score sorted by highest to least
example before achieve:
__Col_A____Col_B
1_Numb____Score
2__18_______50
3__01_______65
4__35_______100
5__06_______10
6__10_______25
7__02_______80
Need to achieve this output:
l________A_____l___B__l__C__l__D__l__E__l__F__l__G__
Row 19l________l______l_____l______l_____l_____l_____
Row 20lNumbersl__35__l__02_l__01__l_18_l_10__l_06__
Row 21lScore___l__100_l__80_l__65_ l_50_l_25__l_10__ <--- Sort by Highest to least score
Row 22l________l______l_____l______l_____l_____l_____
to my mind and google mind its cross nested formulas Match,Row, Small, if plus index, i tried but not success
please any advice?
I don't really know what title to write but i don't really know which nested formula i need to do this simple task.
I have 2 columns (1 column have numbers and each numbers have an score on second column)
I need to transpose the column with numbers and bellow i would like to display the score sorted by highest to least
example before achieve:
__Col_A____Col_B
1_Numb____Score
2__18_______50
3__01_______65
4__35_______100
5__06_______10
6__10_______25
7__02_______80
Need to achieve this output:
l________A_____l___B__l__C__l__D__l__E__l__F__l__G__
Row 19l________l______l_____l______l_____l_____l_____
Row 20lNumbersl__35__l__02_l__01__l_18_l_10__l_06__
Row 21lScore___l__100_l__80_l__65_ l_50_l_25__l_10__ <--- Sort by Highest to least score
Row 22l________l______l_____l______l_____l_____l_____
to my mind and google mind its cross nested formulas Match,Row, Small, if plus index, i tried but not success
please any advice?