View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Scooby Scooby is offline
external usenet poster
 
Posts: 9
Default Sort Data Into Numerical Order..!

I have the product and then the number in 2 seperate columns so i want to
show these in sperate columns ni another sheet in number order.....

"Marcelo" wrote:

Hi, Scooby

assuming each product has a different code and you have a space beteween the
code and the number that you would like to sort, use an auxiliar column to
sort it with this formula:

=mid(a2,search(" ",a2,1)+1,255)

copy it down and sort by this column

hth
regards from Brazil
Marcelo

"Scooby" escreveu:

I have a list which contains something like the following
Prodcut 1 10
Product 2 7
Product 3 9
Product 4 11

I want a table in another sheet to look up this list and automatically put
it into descending order so that for example Product 4 would be at the top
and Product 2 would be at the bottom. I hope this is clear, it is frustrating
me quite badly so thanks in advance to any help you can give.