alphabetize

Hi, I'm working on a stats project and need some help. I've got my two columns, one for first names and the other for last names, and I'm trying to figure out how to merge them so they read in one cell as the full name and then alphabetize them by last name; if it is possible. I've gone as...

I have an old excel sheet- never really ever had problems with it. Anyway- recently put a print macro into it (see below) to add to the macro that was previously there (which gives you an idea how old this workbook is....) and now the two data-validation drop downs don't work (they show a...

I have a list of employee last names that I would like to alphabetize based on the plan chosen. I created the alphabetize formula and the criteria formula, but need assistance combining them if possible: Alphabetize formula: =IFERROR(INDEX(A$2:A$96,MATCH(ROWS(A$2:A2),INDEX(COUNTIFS(A$2:A$96,">...

I have a list of employees and their manager's names. I need to consolidate the list so each manager name appears only once in column A and each employee is in a column to the right of the manager name. Ideally, the employees' names would be alphabetized from left to right, as well. Here is a...

Hello Everyone, I have a multicolumn dynamic range linked to a multicolumn combobox on a userform. Am trying to find a way to alphabetize the range top to bottom, left to right as so: Col1 Col2 Col3 a h o b i p c j d k e l f m g n Can't...

Hey guys, So this one is really getting in the weeds. I'm using the following code to convert a series of names in a cell delimited by commas to codes the names represent, with spaces and commas delimiting, still as text in a single cell. 3 Part Question: As is, after I run the script I'm...

Hey all, Need a little help alphabetizing an unknown amount of data. I have a loop set to insert data at the bottom of a column. This data starts at cell A2 as cell A1 is simply a header. So my question is, how do I alphabetize data (this includes data starting with numerical values) starting...

Hello - I am using excel 2010. I have a simple list of names, and have added 2 new names to the existing list. My slicer has updated, but the names are now at the bottom of the list on the pivot table and I can't get it to change. I have gone into the options and made sure it says to alphabetize...

Would like to automatically alphabetize named ranges on one of my sheets.. I have about 20 columns all defined name ranges, The data it pulls is text, specifically its peoples names. I want these columns to alphabetize automatically. Vb code I would assume. HALP! Need this for my valet...

I am building a kind of knowledge base and I need to alphabetize my terms in the following way: B8:B558 has acronyms, C8:C558 has the term that the acronym stands for, and definitions exist in an additional column. The problem is that there are some terms that don't have acronyms associated...

I have a column full of words to the right of a column labeling each of those words with a number (I will show an example of everything at the end). I want the third column to correspond to an alphabetized list of the second column. I want to use a formula, not a macro, to organize this third...

Hello, all I'm attempting to file about 1,000 employee forms in a new filing system. Each employee has one form. I want to divide the 1,000 employee forms according to the first two letters of their last name. I want to put "at most" twenty forms in each manila folder. I also want to keep...

I have a rather large spreadsheet of ticket/certifications and expiries. I'd like to alphabetize the employees without mixing up their information; their names are in every second row with certification dates following, and on the row below their names underneith their certification dates are...