| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sort and Match like Items in 2 Columns
THank you! I will try it and let you know.
"Herbert Seidenberg" wrote: Assume your data looks like this: setA setB 18 11 16 20 10 10 19 12 12 19 22 21 29 30 26 16 17 29 13 13 27 14 14 25 21 28 23 22 15 17 28 26 25 24 Pivot Table Multiple Consolidation Ranges Range Select the above data, including headers and a blank column in front of data. Layout Drag the Row button out of the ROW field and drag in the Value button into the ROW field. The DATA field should say Sum of Value Options Uncheck grand totals. Beside other stuff, the Pivot Table will show this result: setA setB 10 10 11 12 12 13 13 14 14 15 16 16 17 17 18 19 19 20 21 21 22 22 23 24 25 25 26 26 27 28 28 29 29 30 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| match and sort columns | Excel Worksheet Functions | |||
| MATCH UP DATA IN COLUMNS | Excel Worksheet Functions | |||
| Using AutoFilter to Sort Data Pulled in by INDEX / MATCH | Excel Worksheet Functions | |||
| Match and sort | Excel Worksheet Functions | |||
| How do I match identical values in 2 columns and then sort? | Excel Discussion (Misc queries) | |||
Threaded Mode
