View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sahafi sahafi is offline
external usenet poster
 
Posts: 108
Default Sort column B but keep value in column A with value column B

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

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


"Madscientist29" wrote:

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.