 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / October 2004Sorting a column by using formula
my sheet goes like this Cell A1: Mr. abc Cell A2: Mr. XYZ Cell A3: Blank Cell Cell A4: Blank Cell Cell A5: Ms. Lee Cell A6: Mr. PQR The data in these cells is coming from another sheet. Now i Actuall want to delete the blank cells in between this data i.e A3 & A4, an get the outcome in another sheet. Can you pls help on this. Praise, As you have described the data, if we were to sort on column A, the the prefix of Mr, Ms, etc will take precedence. Ie your data will be : Mr. abc Mr. PQR Mr. XYZ Ms. Lee Is this the order that you intended? If not, it will first be nesessar to separate the name components. Are they currently stored separately? How is the data sourced from 'another sheet', has it been copied an pated or is it a formula lookup? Please let me know -- Kiera Born ignorant and still perfecting the ar |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.