 |
 | 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 / August 2007Question on sorting
I have a spreadsheet that contains 3 columns: Col A = Names Col B = Dates of Birth Col C = An Assigned Password The passwords are formatted as follows: A001Z, B002Y, C003X, etc...through all rows. The spreadsheet contains approximately 2300 rows, currently sorted by name. I need to sort by Password in the above indicated order. Anybody have any ideas how his might be done? Or if it's even possible? Thanks, Mike Highlight the data in columns A to C, including a header row if you have one. Click on Data | Sort and select column C as the first sort field - if you have a header row and the header row box is ticked in the panel, then the list of possible fields will be presented to you as the names of the columns rather than Column A, Column B etc. Ensure that Ascending order is checked, then click OK - the list should appear in the order you want. Hope this helps. Pete > I have a spreadsheet that contains 3 columns: > [quoted text clipped - 13 lines] > > Mike Select the area with the data. Click on Data, then Sort You'll see a drop down menu where you can select Column C Hope that helps. > I have a spreadsheet that contains 3 columns: > [quoted text clipped - 13 lines] > > Mike You need 2 help columns, preferably in D and E assume you have headers, so in D2 =LEFT(C2) in E2 =MID(C2,2,3) copy down by double clicking the lower right corner of E2 after select D2 and E2 then if you want to sort by password sort by the first help column and secondly the second help column. If needed create a help column for the last character in the pw =RIGHT(C2,1)  SignatureRegards, Peo Sjoblom >I have a spreadsheet that contains 3 columns: > [quoted text clipped - 14 lines] > > Mike Hi Peo, don't you think that the password values (as quoted by the OP) will sort correctly, without needing helper columns? Pete > You need 2 help columns, preferably in D and E > [quoted text clipped - 40 lines] > > - Show quoted text - Yes they will, somehow I assumed the OP wouldn't have asked this unless there was more to it than meets the eye SignatureRegards, Peo Sjoblom > Hi Peo, > [quoted text clipped - 49 lines] >> >> - Show quoted text - Yes, I thought that myself to begin with, then I realised that he had posted into the newusers group, so I decided not to read too much into it. Pete > Yes they will, somehow I assumed the OP wouldn't have asked this unless > there was more to it than meets the eye [quoted text clipped - 63 lines] > > - Show quoted text - Hi Guys, Thanks for the advice. Yes, Peo is correct, in that, just performing a simple sort by the password column did not produce the results I was looking for. I need the sort order results to be sequential by password order. In other words, the first password issued was A001Z, the second was B002Y. I have over 2000 passwords following this format. A simple sort gives me all passwords starting with "A" first, then "B", etc. What I need is the original issue order as above, A001Z, B002Y, etc. I am a new user to Excel, but I am quickly discovering it's many advantages and how they can make my job a lot easier. My first, and greatest, problem right now is attempting to apply Excel's functionality without having a solid background using the program. I have several (large) books, which I am currently reading from cover to cover, and always search through them, as well as these newsgroups and the internet to try and find an answer before I post a question. I try to be as self-sufficient as possible. The second problem, in this case, is that I inherited this password system, which has been used for the last 15+ years, and, had I managed it from the beginning, would have kept a copy by Password order. So, again, thank you, and I will try Peo's sorting method and see what results. Respectfully, Mike > Yes, I thought that myself to begin with, then I realised that he had > posted into the newusers group, so I decided not to read too much into [quoted text clipped - 73 lines] >> >> - Show quoted text - It looks like the first letter of your password increases with each new one, as does the 3 digit number in the middle, and the final letter decreases. If this is the case then you want to sort the password by the 3 digits in the middle to get the order that you want. Peo's column D is thus not needed - use his formula for column E to extract the middle three digits and sort on these. Hope this helps. Pete > Hi Guys, > [quoted text clipped - 111 lines] > > - Show quoted text - |
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.