Duplicates sort in order

[JTL9161]

I have a list of names in Column A (A3:A50)
In column B I have various numbers between 1 and 5 for each name
I am trying to sort the entire list (which changes almost daily) with all the 1's first in Col C and then list the associated name from column A in column D, then all the 2's and then 3's and so on till all the 5's at the bottom

There ins't always a set amount for each number in col B. There could be 11 #1's and 9 #2's...etc.


I tried COUNTIF, INDEX and still cannot get it right.

Thanks in advance for your help
James

 

[JTL9161]

Unfortunately this is a work laptop and I am unable to install add-ins. I have uploaded a screen shot. Hope that can help.

 

[Fluff]

You've already said that the values in C are text, so that formula is not going to work, but you haven't clearly explained what you want to do.

 

[JTL9161]

I did try in cell J3 =abs(f3) which gave me the 1 in col. F and when I use the TRUE FALSE IF statement it comes up TRUE so the data in Column F or C in your example needs a ABS somewhere

 

[JTL9161]

I got it. I put the ABS in the IF statement and I get the 100.

=IF(ABS(F3)=1,100,0)

Thanks for your help.

 

[Fluff]

Glad you sorted it & thanks for the feedback.