Welcome to Lockergnome.com!
HomeHome FAQFAQ   SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log in/Register/PasswordLog in/Register/Password

Need a formula to Alphabatize (can not use sort)

 
   Home -> Office -> General Discussions RSS
Next:  General Discussions: In need of a formula  
Author Message
Arceesmo




Joined: Nov 30, 2007
Posts: 1



(Msg. 1) Posted: Fri Nov 30, 2007 6:10 pm
Post subject: Need a formula to Alphabatize (can not use sort)

Hi,

I am attempting to create a spreadsheet that allows other people to change the order of a list of data using Option Buttons. There are five columns, 4 out of the 5 I was able to use the index, match,& large functions in oder to pull up the largest numeric fields. However, one of the columns is not numeric, and the large function is not working.

I would like to have a formula that will allow me to extract the first five values in alphabetical order.

Much appreciated,

Arceesmo
Back to top
Login to vote
Display posts from previous:   
       Home -> Office -> General Discussions All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Categories:
 General
 Microsoft Windows XP
 Microsoft Windows Vista
 Microsoft Windows (other)
  Microsoft Office
 Microsoft Office (other)
 Computer Security
 Linux
 Movies


[ Contact us | Terms of Service/Privacy Policy ]