Not sure if i need macro or vlookup

[dlw2671]

I need to send nameS from one sheet to another and put them in numeric order. i would like to take the name that correspondes with the numbers and put them in numerical order on sheet 2

example


A1 A2
MARY 5
JOE 12
DON 3
HARRY 8


SECOND SHEET

A1
DON
MARY
HARRY

any help is appreciated thank you

 

[James006]

Hi,

If you want to sort data alphabetically with a formula ...

see link Sorting Text Alphabetically using Excel Formulas | Chandoo.org - Learn Microsoft Excel Online

HTH

 

[dlw2671]

Im sorry i dont want to sort alphabetically. i would like to put them in order according to the number in the second colum. My example was bad. On sheet 1 "A" colum is a list of names and colum "B" is a list of numbers. I would like to take the names and put them on sheet 2 in order numerically by the number that is in colum "b" in sheet 1. I can cut and paste them in order but i was hoping there was a fast way. thank you

 

[James006]

Hi,

In sheet 2, you can test following formula:

=INDEX(Sheet1!$A$1:$A$5,MATCH(SMALL(Sheet1!$B$1:$B$5,ROW()),Sheet1!$B$1:$B$5,0))

HTH