Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Smallest to Largest
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Smallest to Largest
Provide an example of before and after. HTH Otto
"JJ" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Smallest to Largest
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/comm...7-3f30d5e39708 "JJ" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
smallest to largest | Excel Discussion (Misc queries) | |||
Find Smallest and Largest. | Excel Worksheet Functions | |||
functions largest to smallest | Excel Worksheet Functions | |||
Getting the 2nd largest or smallest valuesin a range | Excel Discussion (Misc queries) | |||
Ranking cells largest to smallest | Excel Discussion (Misc queries) |