Archive for the ‘Sort values’ Category
The array formula in column G filters values in column C using a condition in cell E3, comparing it with […]
Comments(2) Filed in categories: Excel, Sort values, VLOOKUP and return multiple values
I showed you in an earlier post how to sort text by number using a formula, it was a question from Denisa. The […]
Comments(0) Filed in categories: Excel, Sort values
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 categories: Excel, Mod, Sort values
In this article I will demonstrate two techniques for counting per row. The first example is simple and straightforward. The second example is a […]
Comments(3) Filed in categories: Count values, Excel, Sort values
You can group rows or columns manually using the "Group" feature. That will tie a range of cells together so […]
Comments(0) Filed in categories: Built-in features, Conditional formatting, 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 categories: Excel, Sort values, Vlookup
krish asks: I've a query in case of two columns of dates and two columns of data. Calling columns A […]
Comments(2) Filed in categories: Excel, Sort values
The sorted table to the right is created with an array formula using the data in the table to the left. Array […]
Comments(1) Filed in categories: Excel, Excel table, Sort values
Marc asks: How to find Min and Max numeric values in a range of cells that have duplicate numbers and […]
Comments(0) Filed in categories: Excel, Excel table, Sort values
Mohsin Ali Raziq asks: I have problem, and o dont know how to solve it, i have data of almost […]
Comments(0) Filed in categories: Excel, Records, 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 categories: Excel, Sort values, VBA
Vikas asks: i need to extract the headers from a grid based on value in left most column example row […]
Comments(3) Filed in categories: Excel, Sort values, Unique distinct values
awall asks: Hey can you do the opposite of this - not random order but this is my situation. i […]
Comments(7) Filed in categories: Excel, Sort values, VBA
Robert Jr asks: Oscar, I am using the VBA code & FilterUniqueSort array to generate unique lists that drive Selection […]
Comments(17) Filed in categories: Excel, Sort values, Unique distinct values, User defined functions (udf), VBA
Muhammad Saleem asks: I a column with over 400 entries. Most of them are 0s. I would like to list […]
Comments(0) Filed in categories: Excel, Sort values
Your boss wants you to sort the company´s products by a new criterion, quality. […]
Comments(0) Filed in categories: Excel, Records, Sort values
Andre asks: I am tryng to list the people with the highest scores based on certain criteria. My data: column […]
Comments(0) Filed in categories: Excel, Sort values
Overview The array formula in cell range C2:C6 creates a random list from the values in cell range A2:A6. Array […]
Comments(4) Filed in categories: Excel, Random, Sort values
Ralee asks in in this blog post: Sort values in parallel (array formula) If there is information in adjacent columns, […]
Comments(4) Filed in categories: Excel, Sort values
How to filter numbers inside ranges in column E and F Array formula in A2: =SMALL(IF(FREQUENCY(IF((COLUMN($A1:$U1)<=End)*(COLUMN($A1:$U1)>=Start), COLUMN($A1:$U1), ""), COLUMN($A1:$U1))>0, ROW($1:$21), […]
Comments(1) Filed in categories: Excel, Range, Sort values
Example 1 This example demonstrates how to sort values with sort on right click menu. Formula in C5: =ABS($C$2-B5) + […]
Comments(0) Filed in categories: Excel, Sort values
Table of Contents Extract negative values and adjacent cells (array formula) Extract negative values and adjacent cells (Excel Filter) Array […]
Comments(3) Filed in categories: Excel, Sort values
Table of contents How to sort a table by Column 1 and then by Column 2 (array formula) How to […]
Comments(16) Filed in categories: Excel, Sort values
Array formula in B16: =INDEX(tbl, MIN(IF(SMALL(IF(ISTEXT(tbl), COUNTIF(tbl, "<"&tbl)), ROW(1:1))=IF(ISTEXT(tbl), COUNTIF(tbl, "<"&tbl)), ROW(tbl)-MIN(ROW(tbl))+1)), MATCH(SMALL(IF(ISTEXT(tbl), COUNTIF(tbl, "<"&tbl)), ROW(1:1)), INDEX(IF(ISTEXT(tbl), COUNTIF(tbl, "<"&tbl)), MIN(IF(SMALL(IF(ISTEXT(tbl), […]
Comments(1) Filed in categories: Excel, Sort values
Introduction A unique list contains cell values that only exist once. A unique distinct list contains all cell values but […]
Comments(0) Filed in categories: Excel, Sort values, Unique values
This blog post describes how to filter text values and then numbers from a range. Array formula in B15: =INDEX(tbl, […]
Comments(1) Filed in categories: Excel, Sort values
Array formula in B2: =IF(ROWS(B2:$B$2)>ROWS(List), "", INDEX(List, MATCH(LARGE((LEN(List)&","&ROW(List))*1, ROWS(B1:$B$1)), (LEN(List)&","&ROW(List))*1, 0))) + CTRL + SHIFT + ENTER copied down as […]
Comments(0) Filed in categories: Excel, Sort values
This blog post describes how to extract duplicates sorted from A to Z from two different columns combined. Array formula […]
Comments(2) Filed in categories: Combine/Merge, Duplicate values, Excel, Sort values
Reverse a list ignoring blanks Formula in C2: =INDEX(List, LARGE(IF(List<>"", ROW(List)-MIN(ROW(List))+1, ""), ROWS($C$1:C1))) + CTRL + SHIFT + ENTER copied […]
Comments(0) Filed in categories: Excel, Misc, Sort values
Question: How do I sort a range containing multiple columns and rows by occurence? Answer: The range is sorted by […]
Comments(4) Filed in categories: Excel, Sort values
Question: How do I sort a range alphabetically using excel array formula? Answer: Array formula in B8: =INDEX($B$2:$E$5, MIN(IF(SMALL(COUNTIF($B$2:$E$5, "<"&$B$2:$E$5), […]
Comments(3) Filed in categories: Excel, Sort values
Question: How do I create a new list of alphabetically sorted duplicates using excel array formula? Answer: Excel array formula […]
Comments(1) Filed in categories: Duplicate values, 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 categories: 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 categories: Excel, 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 categories: Excel, Sort values
Question: I have a list containg dates and values. How do I sort values between two specific dates? Answer: Yellow […]
Comments(12) Filed in categories: Dates, Excel, Sort values
