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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Madscientist29 - 21 Mar 2008 20:29 GMT

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.

Reply to this Message

sahafi - 21 Mar 2008 21:26 GMT

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

Thanks.

Signature

when u change the way u look @ things, the things u look at change.

> 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.

Reply to this Message

GoBow777 - 21 Mar 2008 21:49 GMT

Madscientist29;642478 Wrote:

> 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

--
GoBow777

Reply to this Message