alphabetical order

Hello community, I have a challenge that I am currently unable to overcome: In one worksheet, I have two columns; one entitled 'TYPE' and one entitled 'PRODUCT CODE'. Under TYPE, you will either have the word 'ALPHA', 'BETA' or 'OMEGA'. Under PRODUCT CODE, you could have one of a huge...

I have this data within a cell cars; boats; autos; tractors; buses I want to sort in alpha order and split the data so each term is on the next line so to look like this within the cell autos boats buses cars tractors

I have a formula that makes a list of unique employee names that I am trying to alphabetize. The problem is there can be 2-50 (range A1:A50) employees within the list causing the alphabetize rank formula to count blank or 0 cells due to having a formula in that cell. Is there a way to use a...

Hi guys, i have a set of data where the whole name is one cell, including the middle name. I want a formula which will organize it by last name, first name middle name. I have one formula which does something similar, but it gives me an error for cells that contain one word, like vacant, or...

I am looking to alphabetize the rows of a spreadsheet based on the text in column A. The sorting also has to carry the information associated in the adjacent columns B though AK with the sorted information from column A. I would like to write this into a macro so a user can add data to the end...

Our company uses Letter formats to track our material. I was wanting to be able to automate this process a little. We use 5 letters ( GTCBA ) and ever time we add more material it gets a new code which would be like GTCBB the list goe on and on. We keep up with this on Column A of an Excel...

Hello, I'm having a bit of trouble creating a macro that will sort columns in order - I've created a form that allows people to select a broad catagory ie) Schools, then a sub catagory ie) Primary or Seconary, and type in a third ie) Projects or Teachers I'm trying to write a macro so that once...