To Sort 3 Columns With A Priority List?

Jul 8, 2014

I have to sort the data as follows:

DI has top priority, MATT is next and SAM is last in the priority list. I attach the list of data and desired result.

View 2 Replies


Double Entry With Priority List

Dec 16, 2008

First post here and I hope to find a solution

I have 2 columns with data. The first one has 16000 data (6 digit numbers), which are 2 or 3 or 4 times the same (duplication). The second column has a list with name folders.

Question: How can I delete the duplicate/triplicate entries, and leave only the one I want, according to a priority list I have of name folders?

View 9 Replies View Related

Sorting Spreadsheet By Priority Columns

Jun 14, 2014

I'm managing a World Cup Prediction League and have been trying to create a spreadsheet that will eventually feed in to a league, positioning each player in descending order. However, I would like to use three columns to determine how to position the players.


Priority 1 - Column D - Total Points (Rank from Highest to Lowest)
(if there are players with equal Total Points in column D, then)
Priority 2 - Column F - Correct Scores (Rank from Highest to Lowest
(if there are still players with equal value after Total Points and Correct Scores, then)
Priority 3 - Column F - Incorrect Scores (Lowest to Highest)

I've tried for hours to work this out but can't. It would save me hours of work each day

I have attached the document : WC Prediction League EXAMPLE.xlsx‎

View 14 Replies View Related

Macro To Sort 2 Columns Of Numbers Into A New List

Jan 28, 2007

I am trying to write a macro that will sort 2 columns of real numbers in ascending order, then merge them in ascending order into a new 3rd column.

View 9 Replies View Related

Extract Unique Distinct List From Two Columns With Array Formula And Sort From A To Z

May 30, 2014

I have two lists in different columns, which are defined ranges. I want to extract them to a unique list with an array formula and at the same time sort albafetically, without duplicates, like this:


Final List


[Code] ....

So far, I have this formula which is working in what concerns removing duplicates and exctract a unique list. But it is not ordering alfabeticaly.

{=IFERROR(IFERROR(INDEX(List1, MATCH(0, COUNTIF($D$1:D1, List1), 0)), INDEX(List2, MATCH(0, COUNTIF($D$1:D1, List2), 0))), "")}

View 2 Replies View Related

Move And Sort With One Column But Insert Extra Columns As Needed For Proper Sort?

Jan 13, 2014

Using DataEntry sheet for data.
Trying to rearrange the data to DataFormatedProperly sheet.
So far all I can accomplish is DataFormatedWrong sheet.

Edit: Not sure what happened but file was NOT understandable before. It should be correct now.

View 2 Replies View Related

Sort Horizontally. Sort Across Columns

Dec 30, 2006

I am trying to sort a long range of text that is placed horizontally in a spreadsheet. I can do it vertically with the sort function in Excel but it does not seem to work for text that is placed horizontally. Example is as below:

Inventory Accounts Human Resources

View 2 Replies View Related

Excel 2013 :: Can Sort List A-Z Then Numbers At Bottom Of List

Jun 5, 2014

Does excel 2013 have a fence way to sort a list of alpha numeric numbers and alphabetize in this order A - Z and then 0 - 9.

Ex) Apple, Greg, Rob, Sand, 123, 126, 1000, 2001

View 2 Replies View Related

IF Priority Value Changes Then Move $ Amount To A Different Column

Oct 18, 2008

If the value in Column H changes then move the value from it's original location which would be either in J, K or L from there to the column corresponding with the value in H (reference 1=J, 2=K, 3=L).

So, in the file, if H3 were to be changed to Priority 3 then I want the value to move from J3 to L3 and if it were to be changed to Priority 2 then I want the value to move from J3 to K3. The formula needs to work on all variations ie priority 2 changing to 1 or 3 for the whole sheet. There is conditional formatting - would be nice to keep it but no big deal.

View 5 Replies View Related

Sort Multiple Columns, With Blanks, And Move All Columns Into One

Feb 15, 2010

I found this code on Ozgrid to sort all columns of a worksheet that were continuous with no gaps or spaces that works well:

Sub CopyToA()
Do While ActiveCell <> ""
Range(ActiveCell, ActiveCell.End(xlDown)).Cut Destination:=Range("a65535").End(xlUp).Offset(1, 0)
ActiveCell.Offset(0, 1).Select
End Sub

However, I've tried to manipulate the code myself to 1) find all columns that aren't empty then 2) sort each column individually (WITHOUT expanding the sort to other columns) and 3) combining all the numbers into one seperate column. There are many posts concerning sorting but not one that addressed this particular situation.

View 2 Replies View Related

Priority Queue - Ability To Delete Row / Entry?

Oct 29, 2011

I'm trying to get one more feature added to this priority queue tool that a forum member created. Essentially, this attached spreadsheet is a dynamic task/priority list that will change on the fly. See the original thread here: [URL]

The only missing feature is the ability to delete an entry and have all other entries below it change up a rank.

The attached spreadsheet is the almost completed solution


Item D - 1
Item B - 2
Item E - 3
Item A - 4
Item C - 5

Remove item B
Item D - 1
Item E - 2
Item A - 3
Item C - 4

View 4 Replies View Related

Formula Change Cell Color Depending On Priority

Aug 29, 2012

My colleagues are working on multiple projects at once. The projects got different priority, so I'm looking for a formula that change the cell color if a person is working on it, depending on the project's priority.

For example if John is working on project: East(pri.1), South(pri.2) and West(pri.3). On East he got 5 remaining hours (cell E8). Then i would like that cell to turn red. For South green and West red.

View 5 Replies View Related

Automated Target Dates Based On Priority Rating

Dec 16, 2008

I have a list of issues and depending on their priority would require a different target closure date e.g. low priority = 90 days, medium = 45 days, High = 10 days.

So if I have the following columns:

Issue No (Unique Ref #)
Date Raised
Priority (Low/Medium/High)
Target Closure (based on the pre-determined criteria as detailed in above paragraph)

Can somebody suggest a formula to enter in the "Target Closure" column so it is automated?

View 7 Replies View Related

Conditional Formatting Based On Dates And Priority Levels

Feb 9, 2013

Each item (row) in my sheet contains a logged date in column A, and a priority Level in Column G - which is via a data validation drop down (1 to 3).

What I would like to do is create a conditional format based on what the priority level is, and whether it has expired its allowed resolution time based on the logged date.

For example a Level 1 priority requires a 1 day fix, a level 2 requires a 5 day fix and a level 3 requires a 10 day fix.

If the priority level is a 1 and the logged date is over 1 day old i need the whole row to change colour. If the priority level is a 2 and the logged date is over 5 days old I need it to change colour, and if the Priority level is a 3 and the logged date is over 10 days old I need it to change colour. The colour can be the same each time, but I just need to know how to get it to trigger.

I think I have used an IF(AND( formula in the past, but cannot remember how to do it.

View 4 Replies View Related

Getting 15 Columns In Spreadsheet To Sort On One Columns As It Alphabetizes

Jun 10, 2014

Have a spreadsheet with 15 columns. In one of the columns is the name of the company and that column is not in alphabetical order. The city, state, zip code, business type and all the other pertinent data about that company is in the same row as the name of the company. My intent would be to put the company names in alphabetical order and keep all the company information in the same row as the company name.

View 1 Replies View Related

How Do You Sort Columns So That They Match Up With Other Columns With Like Data

Jul 2, 2008

I have two columns one is web addresses and the other is email addresses but the rows do not line up. I was hoping that since the second half of the email address matches the web address I could somehow sort them so that the email address column and web address column match up. Here is an example but keep in mind that this list is about 9k long and this is just a sampling so you may not see any in this example that match. Also I may have more than one email address per website.

View 9 Replies View Related

(Match & Sort) Sort Columns B And C So That A And B Match Up Numerically

Feb 26, 2009

I would like to sort columns B and C (keeping the two lined up together) so that A and B match up numerically.

View 3 Replies View Related

Auto-Merge Dates In 3 Columns And Then Auto-sort Merged Columns

Jan 10, 2012

I have dates values in 3 columns.

A1 - Header - "Holidays in XXXX'
B1 - Header - "Holidays in YYYY'
C1 - Header - "Leaves by YOU"

A2:B11 have static dates consisting of 10 dates in each column.
C2:C11 - the user may enter any date at any point of time.

I would like to auto-merge the dates in all the 3 columns (A2:C11) in a single column say D2:D31 and then the system should auto-sort the column based on dates in any one order. So as soon as the user enters a value in say cell C2, all the 10+10+1 dates should get sorted.

Also the constraint here is a user may not apply all 10 leaves at in a year. So many of the cells may have blank values.

View 1 Replies View Related

Sort All Columns Except For Few

May 3, 2009

I am using a formula but when it sorts with the data in the adjacent cells it does not update the reference cells properly.

For example here is the =SUMPRODUCT(($F$12:$WWX$12>=C1)*1,($F$12:$WWX$12<=E1)*1,ABS($F$13:$ZZ$13))

This code is located on row 13, when I do a sort function with all the data, this code is then moved to row 30, that is fine but the code changes in the following way:


C1 & E1 should not have changed at all, F13 & ZZ13 should have changed to F30 & ZZ30.

I am not sure if there is a way to fix the formula so it updates correctly, or these cells can stay in the same place as long as everything else sorts.

Is is possible to sort all columns except a few?

View 6 Replies View Related

Sort Columns A B C D And E

Jul 8, 2009

I am trying to get columns A:E on Sheet1 converted into columns A:H on Sheet2. I attached the workbook with the macro so you can see what I am talking about. I posted the same macro in the workbook below. It comes close to what I am trying to do but it only sorts based on Column E. I would like to include Columns A, B, C, and D in the sort instead of just Column E so the display will look like Sheet2.

View 2 Replies View Related

Sort Columns - First A / Then B / Then C

Oct 29, 2012

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 category ie) Schools, then a sub category ie) Primary or Secondary, and type in a third ie) Projects or Teachers

I'm trying to write a macro so that once they enter the form, their choices will be automatically sorted alphabetically, first by column A, then B, then C - to look like:

Schools - Primary - Projects - A
Schools - Primary - Projects - B
Schools - Primary - Projects - C
Schools - Primary - Teachers - B
Schools - Secondary - Projects - C
Schools - Secondary - Teachers - A
Schools - Secondary - Teachers - B
Schools - Secondary - Teachers - C

However I'm having the issue where if column B or C are left blank - the columns are not sorted properly, and the categories in column A get separated out..?

My code at the moment looks like:

Range("A1").Sort Key1:=Range("A2:A3"), Order1:=xlAscending, Header:= _
xlYes, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _

[Code] .......

View 1 Replies View Related

VBA: Sort On Two Columns

Oct 22, 2008

I have the necessity to execute a macro for sorting a list of data on two columns.
More exactly, let's suppose to have this situation:

A 10/2/2008 FFFF GGGG HHH
C 15/10/2008 AAA BBBB CCC

I need this sort:
A 10/2/2008 FFFF GGGG HHH
C 15/10/2008 AAA BBBB CCC

View 9 Replies View Related

Sort A To G And S Columns

Jun 26, 2006

r = Range("c65536").End(xlUp).Row
Range("a5:G" & r).Select

Selection.Sort Key1:=Range("G5"), Order1:=xlAscending, Key2:=Range("F5") _
, Order2:=xlAscending, Key3:=Range("C5"), Order3:=xlAscending, Header:= _
xlNo, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal, DataOption2:=xlSortNormal, DataOption3:= _
Rows("4:" & r).Select
For i = 5 To r
If i Mod 2 = 0 Then
Selection.Interior.ColorIndex = xlNone
Selection.Interior.ColorIndex = 36
End If
Application.Calculation = xlCalculationAutomat

this sorts range from A to G and set color to each second row how can I include S column in this range
I mean that cells in column S are moved with cells from columns A to G.

View 9 Replies View Related

Long List Won't Sort?

Jul 22, 2013

I am trying to sort a fairly long list of tasks into a custom calendar order. I have created the custom list as Sept, Oct, Nov, Dec, Jan etc through to Aug, with one additional heading of "Recurring". The list won't seem to sort by the column where these headings occur. See attachment.

View 7 Replies View Related

VBA To Sort Worksheets From A List

May 7, 2009

Is it possible to sort numerous worksheets based off a list of cells that are the names of the worksheets within the same file? For example my worksheet names are:

YTD Texas
YTD Florida
Period Texas
Period Florida

I can sort the sheets by alpha but it puts the two YTD worksheets together when I need the two Texas sheets side by side (I need this on a file that contains over 100 worksheets otherwise I would do it manually) I was wondering if I could create my order of sheet name in another worksheet and reference that list through vba code?

View 7 Replies View Related

Getting A List To Automatically Sort

Oct 17, 2013

I am trying to get a list to sort automatically. I am running a competition over an 11 week period and entering weekly data that is totalled on a separate "Totals" sheet.

This "Totals" sheet, in turn, feeds a "Scores" sheet which I want to automatically sort in descending order of score in order to show the current positions in the competition.

The data in the list isn't entered directly but comes from formulas that reference cells in other workbooks.

I have found ways of sorting a list when you enter data into the list itself but what I need is a macro that will update the sort order automatically whenever a new value is entered in one of the other workbooks.

View 1 Replies View Related


Jun 3, 2006

I have a wedding list of names and addresses in one long column. The names occur every 5th line. They are not in alphabetical order.

View 9 Replies View Related

Sort List By No Of Characters

Feb 18, 2007

I have a large list of phrases, about 30,000 all in Col A. (From A3 to be exact)

What I want is to sort by number of characters.
I know excel can sort A-Z,,, but I can't see by number of characters??

Is there anyway I can sort this list by No of Characters please??

List does include letters and numbers.
But they are mainly 3-4 keyword phrases.

This is so from a large list all the least amount of characters will be at the top of the list so I can easily see them,, and probably delete most of the 1,2,3,4 character returned results.

View 9 Replies View Related

Sort Based On List

Jun 4, 2008

sorry for restarting this thread but i started one similar on saturday and the person I was talking to has not yet responded

I want to know if it is possible to adjust this code line:

Case "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday"

from the macro below to instead get the case names from a list on a worksheet... the reason for this is that the names of the worksheets I want sorted will change periodically.

Sub SortDaysoftheWeek()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
Select Case ws.Name
Case "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday"
With ws
.Range("A6:G256").Sort Key1:=Range("A6"), Order1:=xlAscending, Header:= _
xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
End With
End Select
Next ws
End Sub

View 9 Replies View Related

Sort List With X Exceptions

Aug 22, 2007

I need to create a custom sort which will cause entries "TBD" and blank to appear at the bottom of my spreadsheet. Any other value will be sorted alphabetically. I'm not sure how to create my sort list to do this. I tried "*, TBD " but this did not work.

View 2 Replies View Related

Copyrights 2005-15, All rights reserved