moron who knows nothing needs formula

K

karaoke_maker

thanks in advance for any help....
simple example

a b
van halen jump 100-0
van halen jump 452-0
van halen jump 223-0
van halen jump 395-0
van halen jump 97-0
van halen jump 610-0

how can i get excel (what formula or how do i do it) to see all the entries....and if an entry matches another like in this example, to delete all entries except the lowest #...in this example deleting every entry except for....
van halen jump 97-0

pls keep in mind i am not familiar with excel and no one to this point has been able to help me, could be impossible for all i know...thanks agai

email if needed is [email protected]
 
Top