# Sorting With Multiple Decimals

Jun 11, 2009

I'm looking for a way to sort things with multiple decimals (version number). Is there a way to have something like this:

1.1
1.57
1.1.5
1.2
1.68.23
1.23.1

become:
1.1
1.1.5
1.2
1.23.1
1.57
1.68.23

I could do it all manually, but I have to work with like 400 entries at a time.

## Convert Degrees Minutes & Decimals Of A Minute (12° 34.567') To Degrees And Decimals Of A Degree (12.57611°)

Oct 29, 2008

I am trying to convert Degrees Minutes & Decimals of a minute (12° 34.567') to Degrees and decimals of a degree (12.57611°). I have the formula to convert latitude, that is two digits, but it doesn't want to work with longitudes, three digits. (see attachment). This is the formula that I am using:

=IF(A2="","",(INT((LEFT(A2,3)+MID(A2,4,6)/60)*100000)/100000)&"d")

## Extract Multiple Dollar Values With Decimals From String Into Individual Named Cells?

May 21, 2014

I'm pasting XML data into a spreadsheet and trying to create a vba tool so I can work with the values in a different configuration.

Here's an example of the XML data when pasted into Excel and how I'd like to organize it:

Capture.JPG

## Sorting Multiple Columns ...

Sep 3, 2009

I have a potential of 5 columns of numerical data (simple number entries) which are entered manually in no particular order.

Is there any way of sorting the data so that it is presented in numerical order (smallest to largest) starting with the smallest figure at the start of column 1 up to the largest figure at the end of column 5.

## Selecting Multiple Row For Sorting

Dec 23, 2008

I am trying to select multiple rows so that i can sort. The code i have

## Multiple Column Sorting

Mar 10, 2009

I'm trying to merge two or more tables.

The first column of each table is the same field, for example 'Country'. Lets say the first table has information on male population, the second table has information on female population. So i want to merge the tables into one, but here's the problem: table1 has 100 rows (countries), table2 has 96 rows (countries). I need excel to recognise the 4 missing rows of data in table2 and insert blank rows so all the data in table2 corresponds to the correct country in table1 (column1).

Here's a (very) simple example: ...

## Multiple Cell Sorting

Jul 9, 2008

I have a multiple Excel sort option question and I hope that someone can answer it. I have multiple rows and I want to sort rows together that match(text or value) in 3 different columns. If there is not a match, I would like Excel to delete the row. I have over 160,000 items and probably only 20,000 match and this is why it would be such a pain to do this manually.

## Sorting Multiple Columns

Sep 8, 2008

How do I sort multiple columns at once? In other words, I have a chart that is a series of 1s and 2s, and I need all of the 1s to drop to the bottom, so that I can do a rudimentary chart in spreadsheet form. My chart has dozens of columns like so:

1 2 1 1 1 2 2 2 2
1 2 1 1 2 1 1 2 2
2 1 2 2 2 2 2 2 2
1 1 1 2 1 1 1 1 2

How do I get the entire range sorted to look like this, without having to do each column individually (hours of work)?:

2 2 2 2 2 2 2 2 2
1 2 1 2 2 2 2 2 2
1 1 1 1 1 1 1 2 2
1 1 1 1 1 1 1 1 2

## Custom Sorting Of Multiple Columns?

Jun 20, 2013

In Column A there are randomly assigned numbers using the RANDBETWEEN function.

In Column B there are three possible values X, Y, and Z.

I want to create a sort order where "X" is always at the top but then the rest of the rows are randomly sorted by column A (Y and Z values are intermixed).

Currently I tried to use a Custom List and the value is "X" to sort first, and then a seconday sort of Column A. The problem is that column B is always sorted by X then Y then Z where I am trying to get the Y and Z values to be randomly intermixed based on the sort of the random numbers in Column A.

I know I can manually do 2 seperate sorts each time, but I would like to save a sort list to the file so I recreate that sort over and over again.

## Matching And Sorting Multiple Columns

Mar 11, 2014

I need sorting a contact list of 3000 + so the emails match with the company name, and first and last name of the contacts

Column A is Email and Matches column C & D. Column B matches with Column E. I need A to match with B-E.

I've attached an example : Example Spreadsheet.xls

## Sorting With Multiple Rows Per Entry

Feb 24, 2006

I've come upon a problem with sorting that I don't know how to tackle... I have entries in a workbook that I want to sort by a transaction number, but each entry spans multiple rows. One "entry" might look like this, for example:

TransID PassengerName Ticket#
leg of travel: Departure Arrival
leg of travel: Departure Arrival

I need to be able to sort by TransID or PassengerName while keeping the "legs of travel" attached to the correct TransID/Ticket#.

## Sorting Data That Has Multiple Formats?

Jun 15, 2012

I have lists of products that I want to sort, but all the skus are in different formats, some letter, numbers, spaces, symbols and mixes of all.

Example:
01107919
CE-4128B9
RED-BRIC889
1124
14100119020-E
86TR
ECO CUP22OZ/1000
1418909888783301

I would like to organize them by the order of the numbers, letters and symbols, not the value of the numbers.

Example:
01107919
1124
14100119020-E
1418909888783301
86TR
CE-4128B9
ECO CUP22OZ/1000
RED-BRIC889

I have tried formatting and different sorting options but there's a dent in the wall and my forehead is getting bruised from all of the banging.

## Sorting Multiple Sets Of Data

Aug 22, 2012

Create a macro or some other solution to sorting my data. Just clicking on Sort Ascending isn't good enough because it'll sort everything and remove the empty rows. However, I want the empty rows to stay there. The way that I've been doing this is manually. Basically, after the empty rows were inserted, I'd click on a cell in Column A and click on Sort Ascending, then I'd scroll down and click on the next set of data and click on Sort Ascending, then the next set and the next. I'd end up having to do this hundreds of times.

I've uploaded an example of what I'm talking about, I also labeled the tabs as "I want this" and "to look like this":

Example file.xls

## Sorting Multiple Rows Horizontally?

Apr 11, 2013

I have over 300 rows with a username in the column A followed by 3 fields in the following columns B,C,D. I want to just sort all 300 rows alphabetically by column B,C,D.

Eg. Cormac, Santa, Atlas, Egg
After search Cormac, Altas, Egg, Santa.

how to do this easily in Excel without VB as I am not good as it.

## Sorting Multiple Columns Alphabetically

May 2, 2013

How do I sort multiple columns alphabetically with the last name first, then the first name as the 2nd sorting option?

Here is an example of what I have:

year; first; last
2011 chrisBell
2010 chrisBell
2009 chrisBell
2008 chrisBell

[Code] .......

As you can see, the first names aren't sorted 100% alphabetically. I think issue stems from the years 2001 n-2006 n. I have to use the 2001 n since its a different data than the normal 2001.

The default sorting was by year:
2012
2011
2010
2009

[Code] .......

So I want it to sort by last first, then first name. Then it should sort by the default sort I already had in the left column (years).

## Sorting Multiple Lines Of Data

Nov 20, 2007

I have a large spreadsheet I need to sort into alphabetical manager order.

As there are between 2 and 20 rows per manager I would like to know if I am able to sort this into alphabetical order!

## Sorting Info From A WS To Multiple Worksheets

Sep 30, 2009

Here's the issue: I have a spreadsheet with 12,000 contacts in it (name, email, phone number, country, industry, etc etc). The sheet is kind of messy, and I want to clean it up. One way thing I want to do is organize it. I want to sort the Master sheet into other worksheets, and I would like to do this Industry.

Is there a way to make excel register when a contact is in a certain industry, and then subsequently move that contact into a sheet? I tried playing around with If/Then functions, but I think this is a job for a macro/VB expert.

## Display Multiple Rows & Sorting

May 2, 2006

1) Is it possible to hide all cols save D & E and also all blank rows in Col D

2) I would like to have an initial If statement saying stating that if the answer to the question in D2 is Y then don't display anything else other than the info in B2 & B3.

£) the sorting seems to have gone funny - not sure what I've done here, I'd like it sorted by phase (col A)

4) where there is a blank in the cell under a question (for example D3) - this means that the same question applies and that multiple docs should be returned (e.g for Q1 D2 docs 1 & 2 display, for qu D37 docs 36 - 39 display)

## Sorting A List Of Numbers By Multiple Columns

Oct 13, 2008

I want to sort the list like this:

1) If there is a zero (null) value in all 3 months, these records should be at the bottom sorted by record name (I did not show this field in my file).
2) If there is a non-zero (non-null) value in any of the 3 months, the records will be sorted with each other by total change.

Is there a way to do this without me doing sorts multiple times and manually moving rows of data around (which is what I have done to arrive at the list I have attached)? I am not experienced with VBA or Macros, and would prefer a detailed explanation if a solution is using either method.

## Excel 2010 :: Sorting Multiple Times

Aug 27, 2013

I have a sorting question in Excel 2010. Attached is an example workbook with a simplified version of the situation.

I want to sort a table multiple times. I have a table with part numbers and alphanumeric locations (Row, Shelf, Bay, Slot). I have formulas that divide up the location into 4 separate columns to be able to sort.

The first sort I do is by location, which I can easily achieve. The issue I have is sorting AGAIN by part number, while keeping the original sort somewhat intact. If a part number shows up multiple times (i.e. in two DIFFERENT locations), the Nth instance might show somewhere down the list.

Is there a way to sort my table to where you keep it in location order WHILE accounting for duplicates, which I would want grouped together in location order? Please see attached file : SortExample.xlsx

## VBA / Macros - Sorting Across Multiple Repetitive Columns?

Jan 27, 2014

I have attached an example spreadsheet with two tabs. The first tab (Matrix) shows raw data scores - there are 28 measures in Column A and Participants in Row 1. There are always 28 measures but participants can vary. What I need to happen is to sort each measure in a Lineup tab i.e. rank all the participants listed in the Matrix tab from lowest score to highest score for each of the 28 measures. Obviously this can be done manually but a VBA/macro solution will be so much faster and easier. Unfortunately I have to keep the data in this format so the macro will need to transpose the data to get into the formt in the Lineup tab.

## Comparing And Sorting Multiple Column Groups?

Feb 28, 2014

I'm am trying to take multiple column-groups and sort them by product ID number.

I am trying to put together a sales record for the past 26 months for around 2000 different items and sorting them manually would obviously be a nightmare.

I would like to sort them so that all the drugs with the same NDC (prod ID) have the correct data for each month displayed on the correct row for that NDC. Right now I have each set of data for that month sorted by product ID number but some months we used certain products and others we did not. Is there any sort of Macro that I could use? What I am trying to do I attached two files. The "before" and my desired "after".

starting point.xlsx
end product.xlsx

## Sorting Data In Multiple Tabs By Group

Dec 31, 2012

I have imported data into excel arranged as per the following and there are separate tabs per year. I a trying to summarize and phase the balances per client..i.e 07,08,09,10,11,12.

Therefore if client x balance in 2007 = 10, 2008=11, 2009=10, 2010=2, 2011=3 and 2012 = 5 and so on...then total the balance owed as of now and also phase it as illustrated below. I've tried vlook up's?

Client
Code
01Jan07-
31Jan07
01Feb07-
28Feb07

[Code] .....

## Sorting Multiple Customers In A Single Cell

Aug 18, 2006

I am trying to figure out how I can sort multiple customers in a single cell, and then assign the customers to the outside salesman. The basic idea is in column A I have the customers for a specific job. Assume I have three customers (Alpha, Omega & Gamma) and they are all in ONE cell. I need to sort this and assign each customer to each of my outside salesmen (Bob, Ted, Fred) in another column. The other component to this question is that Bob, Ted & Fred may have MORE than one customer in that single cell........

## Data Sorting - Formula Based On Multiple Other Cells

Jul 1, 2014

I have some cells that are summed with total cost.... now i need to sort the totaled cells? How do i sort a cell that has a formula based on multiple other cells?

## Sorting Multiple Worksheet Tabs In Alphabetical Order

Nov 24, 2008

I have a spreadsheet saved with one worksheet with all the results on it and 130 worksheets with calculations on them, each with its' own named tab along the bar at the bottom of the page. What I'd like to know is if it is possible to sort the tabs into alphabetical order so I don't have to roam through up to 130 to find the tab (and it's corresponding worksheet) I'm looking for.

## All Information In One Cell Instead Of Multiple Cells - Sorting Dataset

Oct 17, 2013

I downloaded a massive dataset in .csv format to work with. My first problem is that I'm having trouble sorting the dataset. When I open the .csv-file every bit of information comes up in the A-column instead of having INFORMATION1 in the A-column INFORMATION2 in the B-column and so on.

## Sorting (or Maybe Filtering) Worksheet With Multiple Data In Cells

Nov 1, 2008

Background: I am HR manager for a construction company & keeper of the call-in list of personnel who are looking for work. I have a simple sheet that has columns:

If each call-in had only one craft, wouldn't have a problem. Those who are multicrafted ar listed e.g. "EL, MW, BM" In the column C. A caller two days later may be listed as "MW, BM, EL" We input the data as they say it since that is usually their order of expertise. (Yes, I know that it should have been set up with each craft having its own column, but I inherited the sheet & it has 4000+ entries)

I wrote a couple of small macros & assigned buttons on the sheet to allow the users to sort the sheet by date, or name, or craft. My customers (project managers) have requested to be able to sort by craft but have all the folks with any specific craft listed together.

Example (Excel 2003): ..

## Sorting Long Lists - Extract Multiple Items

Jan 13, 2013

I have two lists. A1:A7000 has 7000 items and B1:B10000 has 10,000 items all in random order. List B includes all the items on list A, but with an additional 3000 items. How can I extract the 3000 items that are exclusively on list B? I would like to put these on a new list C1:C3000.

## Excel 2010 :: Sorting Multiple Values In Ascending Order

Dec 29, 2012

I am trying to sort multiple values in ascending order (example attached) however I can't get this to work. Tried looking at a few different forums and although there is plenty of sorting questions out there they all tend to be relating to dates not different values (i.e text and numbers).