| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Group values
I have column B with 20 values in it. Some of the values repeat more than one
time. For example word fox appears 2 times, word wolf appears 4 times e.t.c Is there any way to group non-unique values? I mean like perform select with grouping ? For example I have range of values B1:B20 and i want to put resulting range to C1:C20, but i only want to have unique values in resulting range. If excel would support SQL in order to get resulting range i want, i would write: "SELECT DISTINCT column B FROM workbook1" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Match function with duplicate values in an array | Excel Worksheet Functions | |||
| Calculate cell row and column | Excel Discussion (Misc queries) | |||
| Count Distinct Values by Group Using Pivot Table (NM) | Excel Worksheet Functions | |||
| Can't group pivot table items by month in Excel | Excel Discussion (Misc queries) | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Threaded Mode
