Smallest to Largest

[JJ]

I have column A ranging from (Seq)1 - 30 with numerica value. Column B with
(Description)Text names. The data is to be linked so that whenever the seq
changes, it updates the cells in the worksheet containing th formula.
A1 B1
1 A
3 B
2 C

I have tried the SMALL function but don't know how to link the two comlumns.

 

[Otto Moehrbach]

Provide an example of before and after. HTH Otto

 

[JLatham]

Take a look at this thread - read through to the part where Mike wants names
resequenced based on resequenced values (which I did as 1st part). I think
that sounds almost exactly the same as what I think you're asking for here
http://www.microsoft.com/office/com...misc&mid=a8d3d4e9-2f34-4539-81b7-3f30d5e39708