Sort column B but keep value in column A with value column B

M

Madscientist29

I need to sort column B from largest to smallest, but I need the value in
column A that is paired to the value in column B to STAY WITH the value in
column B once it gets sorted.
 
S

sahafi

Select both Col A and B >> Data >> Sort >> sort by Col B, and click on
'Desending.

Thanks.
 
G

GoBow777

Madscientist29;642478 said:
I need to sort column B from largest to smallest, but I need the valu
in
column A that is paired to the value in column B to STAY WITH the valu
in
column B once it gets sorted.

Select the range of values in column B and click the Sort Descendin
icon in the Toolbar, the Sort Warning dialog box will open; select
"Expand the selection" and click the Sort button. Column A wil
reference the values in column B accordingly
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top