SORT column ascending order

[Vishaal]

we have the following sheet where we have data in column A to D, and in column F, we have combined the data,

now we want to sort the column F in ascending order. help please

Book1
	A	B	C	D	E	F	G
1	Rank	Title	Distributor	Domestic gross		COMBINE	SORT
2	Top Gun: Maverick	T+4	Paramount	$718,732,821		Top Gun: Maverick (Paramount) ($718,732,821)
3	Avatar: The Way of Water	T+4	20th Century / Disney	$684,075,767		Avatar: The Way of Water (20th Century / Disney) ($684,075,767)
4	Black Panther: Wakanda Forever	T+4	Disney	$453,829,060		Black Panther: Wakanda Forever (Disney) ($453,829,060)
5	Doctor Strange in the Multiverse of Madness	T+4	$411,331,607	$9586754		Doctor Strange in the Multiverse of Madness ($411,331,607) ($9586754)
6	Jurassic World Dominion	T+6	Universal	$376,851,080		Jurassic World Dominion (Universal) ($376,851,080)
7	Minions: The Rise of Gru	T+6	$369,695,210	$98605746		Minions: The Rise of Gru ($369,695,210) ($98605746)
8	The Batman	T+8	Warner Bros.	$369,345,583		The Batman (Warner Bros.) ($369,345,583)
9	Thor: Love and Thunder	T+8	Disney	$343,256,830		Thor: Love and Thunder (Disney) ($343,256,830)
10	Sonic the Hedgehog 2	T+8	Paramount	$190,872,904		Sonic the Hedgehog 2 (Paramount) ($190,872,904)
11	Puss in Boots: The Last Wish	T+8	Universal	$185,535,345		Puss in Boots: The Last Wish (Universal) ($185,535,345)
12
13
14
15
16
17
18
Sheet1

Cell Formulas
Range	Formula
F2:F18	F2	=IF(A2="","",A2& " (" &C2& ") " &"("&D2&")")

 

[Akuini]

now we want to sort the column F in ascending order. help please

Do you mean to sort only col F without affecting other columns?
Just remove the formula and keep the value:

Sub remove_formula()

With Range("F2", Cells(Rows.Count, "F").End(xlUp))
    .Value = .Value
End With
End Sub

then sort manually.

 

[Vishaal]

Do you mean to sort only col F without affecting other columns?
Just remove the formula and keep the value:

Sub remove_formula()

With Range("F2", Cells(Rows.Count, "F").End(xlUp))
    .Value = .Value
End With
End Sub

then sort manually.

Thanks Akuini,

No, we want to sort only column F data, we can get sorted data in Column G

Any Excel formula will be appreciated

Thanks

 

[Akuini]

Any Excel formula will be appreciated

Sorry, I don't know how to do it with formula.
Hope somebody else will step in.

 

[Skyybot]

By which data do you wish to sort? Title, Distributor, or Domestic Gross?

 

[alansidman]

If you are running O365, then in G2 =SORT(F2:F11,1,1)

Rank	Title	Distributor	Domestic gross		COMBINE	SORT
Top Gun: Maverick	T+4	Paramount	$718,732,821		Top Gun: Maverick (Paramount) (718732821)	Avatar: The Way of Water (20th Century / Disney) (684075767)
Avatar: The Way of Water	T+4	20th Century / Disney	$684,075,767		Avatar: The Way of Water (20th Century / Disney) (684075767)	Black Panther: Wakanda Forever (Disney) (453829060)
Black Panther: Wakanda Forever	T+4	Disney	$453,829,060		Black Panther: Wakanda Forever (Disney) (453829060)	Doctor Strange in the Multiverse of Madness (411331607) (9586754)
Doctor Strange in the Multiverse of Madness	T+4	########	$9,586,754		Doctor Strange in the Multiverse of Madness (411331607) (9586754)	Jurassic World Dominion (Universal) (376851080)
Jurassic World Dominion	T+6	Universal	$376,851,080		Jurassic World Dominion (Universal) (376851080)	Minions: The Rise of Gru (369695210) (98605746)
Minions: The Rise of Gru	T+6	########	$98,605,746		Minions: The Rise of Gru (369695210) (98605746)	Puss in Boots: The Last Wish (Universal) (185535345)
The Batman	T+8	Warner Bros.	$369,345,583		The Batman (Warner Bros.) (369345583)	Sonic the Hedgehog 2 (Paramount) (190872904)
Thor: Love and Thunder	T+8	Disney	$343,256,830		Thor: Love and Thunder (Disney) (343256830)	The Batman (Warner Bros.) (369345583)
Sonic the Hedgehog 2	T+8	Paramount	$190,872,904		Sonic the Hedgehog 2 (Paramount) (190872904)	Thor: Love and Thunder (Disney) (343256830)
Puss in Boots: The Last Wish	T+8	Universal	$185,535,345		Puss in Boots: The Last Wish (Universal) (185535345)	Top Gun: Maverick (Paramount) (718732821)

 

[Skyybot]

Help.xlsx
	A	B	C	D	E	F	G
1	Rank	Title		Distributor	Domestic gross	COMBINE	SORT
2	2	Top Gun: Maverick	T+4	Paramount	$718,732,821	Top Gun: Maverick Paramount $718,732,821	Top Gun: Maverick Paramount $718,732,821
3	3	Avatar: The Way of Water	T+4	20th Century / Disney	$684,075,767	Avatar: The Way of Water 20th Century / Disney $684,075,767	Avatar: The Way of Water 20th Century / Disney $684,075,767
4	4	Black Panther: Wakanda Forever	T+4	Disney	$453,829,060	Black Panther: Wakanda Forever Disney $453,829,060	Black Panther: Wakanda Forever Disney $453,829,060
5	5	Doctor Strange in the Multiverse of Madness	T+4	Disney	$9,586,754	Doctor Strange in the Multiverse of Madness Disney $9,586,754	Jurassic World Dominion Universal $376,851,080
6	6	Jurassic World Dominion	T+6	Universal	$376,851,080	Jurassic World Dominion Universal $376,851,080	The Batman Warner Bros. $369,345,583
7	7	Minions: The Rise of Gru	T+6	Universal	$98,605,746	Minions: The Rise of Gru Universal $98,605,746	Thor: Love and Thunder Disney $343,256,830
8	8	The Batman	T+8	Warner Bros.	$369,345,583	The Batman Warner Bros. $369,345,583	Sonic the Hedgehog 2 Paramount $190,872,904
9	9	Thor: Love and Thunder	T+8	Disney	$343,256,830	Thor: Love and Thunder Disney $343,256,830	Puss in Boots: The Last Wish Universal $185,535,345
10	10	Sonic the Hedgehog 2	T+8	Paramount	$190,872,904	Sonic the Hedgehog 2 Paramount $190,872,904	Minions: The Rise of Gru Universal $98,605,746
11	11	Puss in Boots: The Last Wish	T+8	Universal	$185,535,345	Puss in Boots: The Last Wish Universal $185,535,345	Doctor Strange in the Multiverse of Madness Disney $9,586,754
Sheet1

Cell Formulas
Range	Formula
G2:G11	G2	=SORTBY(F2:F11,E2:E11,-1)
F2:F11	F2	=B2&" "&D2&" "&TEXT(E2,"$#,##")
Dynamic array formulas.

Sorted by Domestic Gross

 

[Fluff]

For 2010 how about

Fluff.xlsm
	A	B	C	D	E	F	G	H
1	Rank	Title	Distributor	Domestic gross		COMBINE	SORT
2	Top Gun: Maverick	T+4	Paramount	$718,732,821		Top Gun: Maverick (Paramount) ($718,732,821)	10	Avatar: The Way of Water (20th Century / Disney) ($684,075,767)
3	Avatar: The Way of Water	T+4	20th Century / Disney	$684,075,767		Avatar: The Way of Water (20th Century / Disney) ($684,075,767)	1	Black Panther: Wakanda Forever (Disney) ($453,829,060)
4	Black Panther: Wakanda Forever	T+4	Disney	$453,829,060		Black Panther: Wakanda Forever (Disney) ($453,829,060)	2	Doctor Strange in the Multiverse of Madness ($411,331,607) ($9586754)
5	Doctor Strange in the Multiverse of Madness	T+4	$411,331,607	$9586754		Doctor Strange in the Multiverse of Madness ($411,331,607) ($9586754)	3	Jurassic World Dominion (Universal) ($376,851,080)
6	Jurassic World Dominion	T+6	Universal	$376,851,080		Jurassic World Dominion (Universal) ($376,851,080)	4	Minions: The Rise of Gru ($369,695,210) ($98605746)
7	Minions: The Rise of Gru	T+6	$369,695,210	$98605746		Minions: The Rise of Gru ($369,695,210) ($98605746)	5	Puss in Boots: The Last Wish (Universal) ($185,535,345)
8	The Batman	T+8	Warner Bros.	$369,345,583		The Batman (Warner Bros.) ($369,345,583)	8	Sonic the Hedgehog 2 (Paramount) ($190,872,904)
9	Thor: Love and Thunder	T+8	Disney	$343,256,830		Thor: Love and Thunder (Disney) ($343,256,830)	9	The Batman (Warner Bros.) ($369,345,583)
10	Sonic the Hedgehog 2	T+8	Paramount	$190,872,904		Sonic the Hedgehog 2 (Paramount) ($190,872,904)	7	Thor: Love and Thunder (Disney) ($343,256,830)
11	Puss in Boots: The Last Wish	T+8	Universal	$185,535,345		Puss in Boots: The Last Wish (Universal) ($185,535,345)	6	Top Gun: Maverick (Paramount) ($718,732,821)
Master

Cell Formulas
Range	Formula
F2:F11	F2	=IF(A2="","",A2& " (" &C2& ") " &"("&D2&")")
G2:G11	G2	=COUNTIFS($F$2:$F$20,"<"&F2,$F$2:$F$20,"?*")+1
H2:H11	H2	=INDEX(F:F,AGGREGATE(15,6,ROW($F$2:$F$11)/($G$2:$G$11=SMALL($G$2:$G$11,ROWS(H$1:H1))),1))

 

[Vishaal]

Thanks Akuini, alansidman, Skyybot and Fluff for the help

 

[Fluff]

Glad we could help & thanks for the feedback.