## Sort values in parallel in excel, part 2

**Ralee asks in in this blog post: Sort values in parallel (array formula)**

If there is information in adjacent columns, say:

Joel, AA, 7

Mark, FF, 31

Nick, AA, 7

with the possibility of matching sort criteria (columns 2 & 3), how would I display the corresponding data after the sort (sorting only columns 2 & 3) without repeats; that is,

Joel, AA, 7

Nick, AA, 7

Mark, FF, 31

Instead of:

Joel, AA, 7

Joel, AA, 7

Mark, FF, 31

?

**Answer:**

**Array formula in F2:**

+ CTRL + SHIFT + ENTER

**Array formula in G2:**

+ CTRL + SHIFT + ENTER copied down as far as needed.

**Array formula in H2:**

+ CTRL + SHIFT + ENTER copied down as far as needed.

**Named ranges**

Descr (C2:C15)

Qty (D2:D15)

What is named ranges?

**Explaining array formula in cell F2**

**Step 1 - **

**Download excel sample file for this tutorial**

Array-formula-sorts-columns-in-parallel2.xls

(Excel 97-2003 Workbook *.xls)

**Functions in this article:**

**IF(**logical_test;[value_if:true];[value_if_false]**)
**Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE

**INDEX(**array,row_num,[column_num]**)**

Returns a value or reference of the cell at the intersection of a particular row and column, in a given range

**SMALL(**array,k**)** returns the k-th smallest row number in this data set.

**ROW(**reference**)** returns the rownumber of a reference

**MATCH(**lookup_value;lookup_array; [match_type]**)**

Returns the relative position of an item in an array that matches a specified value

**COUNTIF(**range,criteria**)**

Counts the number of cells within a range that meet the given condition

### Category: Sort values

Table of Contents Sort a column using array formula Two columns sorting by the second column Sort alphanumeric values I […]

Comments(81) Filed in category: Excel, Sort values

Question: I have a list of unsorted dates. I want to extract records between two dates and I want the […]

Comments(23) Filed in category: Excel, Sort values

Robert Jr asks: Oscar, I am using the VBA code & FilterUniqueSort array to generate unique lists that drive Selection […]

Comments(17) Filed in category: Excel, Sort values, Unique distinct values, User defined functions (udf), VBA

Table of contents How to sort a table by Column 1 and then by Column 2 (array formula) How to […]

Comments(16) Filed in category: Excel, Sort values

Table of Contents Sort text from two columns combined (array formula) Sort text from multiple cell ranges combined (user defined […]

Comments(13) Filed in category: Excel, Sort values

Pat asks: Hi Oscar, Thanks for creating such a helpful website and I've a question if I would like to […]

Comments(13) Filed in category: Excel, Sort values, Vlookup

Question: I have a list containg dates and values. How do I sort values between two specific dates? Answer: Yellow […]

Comments(12) Filed in category: Dates, Excel, Sort values

awall asks: Hey can you do the opposite of this - not random order but this is my situation. i […]

Comments(7) Filed in category: Excel, Sort values, VBA

Denisa asks: I have a problem and i cant figure it out, even if i'm seraching for 2 days. I […]

Comments(7) Filed in category: Excel, Mod, Sort values

The following macro let´s you select a cell range and a delimiting character. The macro sorts the values in each […]

Comments(5) Filed in category: Excel, Sort values, VBA

### 4 Responses to “Sort values in parallel in excel, part 2”

### Leave a Reply

**How to add a formula to your comment:**

<code>your formula</code>

**How to add VBA code to your comment:**

[vb 1="vbnet" language=","]

VBA code

[/vb]

**How to add a picture to your comment:**

Upload picture to postimage.org

Add picture link to comment.

**Contact Oscar**

You can contact me through this webpage

Great! That's exactly what I needed.

~Thanks

there is an error is your named ranges

Qty (B2:B15) should be Qty (d2:d15)

Descr (B2:B15) should be Descr (c2:c15)

Paul,

thanks!

Please tell me why you put "65536" in your array formula

thx