Thread: data on top
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] k743911@gmail.com is offline
external usenet poster
 
Posts: 2
Default data on top

hello ,

can anyone help with this,


i have series of data segregated like this

example:

richard
kenny
smith
john
raju

i want the output like this . i want smith to be positioned in the
first place always and should not be repeated

it should be like this

smith
richard
kenny
john
raju

can anyone help me with a formula

thans