Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match a group of cells with another group of cells
I have a workhseet in which I have data in multiple columns and rows and I
want to identify rows with the same data and then group them on a different worksheet. The data on the first sheet might look something like the following where each letter represents a value in a cell. A B C D E F G H (Row 1) A C B D F H E G (Row 2) B A C D G F E H (Row 3) A C B D F H E G (Row 4) A B C D E F G H (Row 5) After the matching and grouping, the data would appeasr on the second worksheet as follows: A B C D E F G H (Old Row 1) A B C D E F G H (Old Row 5) B A C D G F E H (Old Row 3) A C B D F H E G (Old Row 2) A C B D F H E G (Old Row 4) I am trying to use an array formula but can't get it to work and would appreciate any assistance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match a group of cells with another group of cells
Rod
I don't know about an array formula, but you coul copy then sort. Sort from Last column H in your example through to A then once more on column F. Peter "Rod in Oz" wrote: I have a workhseet in which I have data in multiple columns and rows and I want to identify rows with the same data and then group them on a different worksheet. The data on the first sheet might look something like the following where each letter represents a value in a cell. A B C D E F G H (Row 1) A C B D F H E G (Row 2) B A C D G F E H (Row 3) A C B D F H E G (Row 4) A B C D E F G H (Row 5) After the matching and grouping, the data would appeasr on the second worksheet as follows: A B C D E F G H (Old Row 1) A B C D E F G H (Old Row 5) B A C D G F E H (Old Row 3) A C B D F H E G (Old Row 2) A C B D F H E G (Old Row 4) I am trying to use an array formula but can't get it to work and would appreciate any assistance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Data from One Group of Cells to Another Group | Charts and Charting in Excel | |||
from a group of cells.find average of cells containing values | Excel Discussion (Misc queries) | |||
How do I name a group of cells? | Excel Discussion (Misc queries) | |||
Sorting by Group of Cells | Excel Discussion (Misc queries) | |||
copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions |