software

I need a formula that will do the following: I want to copy A1:A3 to
different cells A10:A12. if the upper cells have identical entries I want the
lower cells to have the duplicated entry only once.

A
1 Joe
2 Bill
3 Joe
Because Joe was entered twice in the upper cells I want
the result to look like the lower cells. Essentually grouping like entries in
the upper cell to one entry in the lower cell.
A
10 Bill
11 Joe
12

Any help regarding this matter will be greatly appreciated. Thanks for your
time.

Hi,
A macro could do it, but you might first try using the filter function.
Here is the description from Excel help:

Applies to
Microsoft Office Excel 2003
Microsoft Excel 2002

A duplicate row (also called a record) in a list is one where all values in
the row are an exact match of all the values in another row. To delete
duplicate rows, you filter a list for unique rows, delete the original list,
and then replace it with the filtered list. The original list must have
column headers.

Caution Because you are permanently deleting data, it's a good idea to
copy the original list to another worksheet or workbook before using the
following procedure.

Select all the rows, including the column headers, in the list you want to
filter.

Click the top left cell of the range, and then drag to the bottom right cell.
On the Data menu, point to Filter, and then click Advanced Filter.
In the Advanced Filter dialog box, click Filter the list, in place.
Select the Unique records only check box, and then click OK.
The filtered list is displayed and the duplicate rows are hidden.

On the Edit menu, click Office Clipboard.
The Clipboard task pane is displayed.

Make sure the filtered list is still selected, and then click Copy .
The filtered list is highlighted with bounding outlines and the selection
appears as an item at the top of the Clipboard.

On the Data menu, point to Filter, and then click Show All.
The original list is re-displayed.

Press the DELETE key.
The original list is deleted.

In the Clipboard, click on the filtered list item.
The filtered list appears in the same location as the original list.

Regards...

--
Ken Hudsonquot;Sdbenn90quot; wrote:

gt; I need a formula that will do the following: I want to copy A1:A3 to
gt; different cells A10:A12. if the upper cells have identical entries I want the
gt; lower cells to have the duplicated entry only once.
gt;
gt; A
gt; 1 Joe
gt; 2 Bill
gt; 3 Joe
gt; Because Joe was entered twice in the upper cells I want
gt; the result to look like the lower cells. Essentually grouping like entries in
gt; the upper cell to one entry in the lower cell.
gt; A
gt; 10 Bill
gt; 11 Joe
gt; 12
gt;
gt; Any help regarding this matter will be greatly appreciated. Thanks for your
gt; time.

That worked great, but I was looking for something that would do this
automatically.

quot;Ken Hudsonquot; wrote:

gt; Hi,
gt; A macro could do it, but you might first try using the filter function.
gt; Here is the description from Excel help:
gt;
gt; Applies to
gt; Microsoft Office Excel 2003
gt; Microsoft Excel 2002
gt;
gt; A duplicate row (also called a record) in a list is one where all values in
gt; the row are an exact match of all the values in another row. To delete
gt; duplicate rows, you filter a list for unique rows, delete the original list,
gt; and then replace it with the filtered list. The original list must have
gt; column headers.
gt;
gt; Caution Because you are permanently deleting data, it's a good idea to
gt; copy the original list to another worksheet or workbook before using the
gt; following procedure.
gt;
gt; Select all the rows, including the column headers, in the list you want to
gt; filter.
gt;
gt; Click the top left cell of the range, and then drag to the bottom right cell.
gt; On the Data menu, point to Filter, and then click Advanced Filter.
gt; In the Advanced Filter dialog box, click Filter the list, in place.
gt; Select the Unique records only check box, and then click OK.
gt; The filtered list is displayed and the duplicate rows are hidden.
gt;
gt; On the Edit menu, click Office Clipboard.
gt; The Clipboard task pane is displayed.
gt;
gt; Make sure the filtered list is still selected, and then click Copy .
gt; The filtered list is highlighted with bounding outlines and the selection
gt; appears as an item at the top of the Clipboard.
gt;
gt; On the Data menu, point to Filter, and then click Show All.
gt; The original list is re-displayed.
gt;
gt; Press the DELETE key.
gt; The original list is deleted.
gt;
gt; In the Clipboard, click on the filtered list item.
gt; The filtered list appears in the same location as the original list.
gt;
gt; Regards...
gt;
gt; --
gt; Ken Hudson
gt;
gt;
gt; quot;Sdbenn90quot; wrote:
gt;
gt; gt; I need a formula that will do the following: I want to copy A1:A3 to
gt; gt; different cells A10:A12. if the upper cells have identical entries I want the
gt; gt; lower cells to have the duplicated entry only once.
gt; gt;
gt; gt; A
gt; gt; 1 Joe
gt; gt; 2 Bill
gt; gt; 3 Joe
gt; gt; Because Joe was entered twice in the upper cells I want
gt; gt; the result to look like the lower cells. Essentually grouping like entries in
gt; gt; the upper cell to one entry in the lower cell.
gt; gt; A
gt; gt; 10 Bill
gt; gt; 11 Joe
gt; gt; 12
gt; gt;
gt; gt; Any help regarding this matter will be greatly appreciated. Thanks for your
gt; gt; time.

A couple of questions....
Do you have only one column of data (column A) to manipulate?
Is it okay to write over the old data with the unique list?

--
Ken Hudsonquot;Sdbenn90quot; wrote:

gt; That worked great, but I was looking for something that would do this
gt; automatically.
gt;
gt; quot;Ken Hudsonquot; wrote:
gt;
gt; gt; Hi,
gt; gt; A macro could do it, but you might first try using the filter function.
gt; gt; Here is the description from Excel help:
gt; gt;
gt; gt; Applies to
gt; gt; Microsoft Office Excel 2003
gt; gt; Microsoft Excel 2002
gt; gt;
gt; gt; A duplicate row (also called a record) in a list is one where all values in
gt; gt; the row are an exact match of all the values in another row. To delete
gt; gt; duplicate rows, you filter a list for unique rows, delete the original list,
gt; gt; and then replace it with the filtered list. The original list must have
gt; gt; column headers.
gt; gt;
gt; gt; Caution Because you are permanently deleting data, it's a good idea to
gt; gt; copy the original list to another worksheet or workbook before using the
gt; gt; following procedure.
gt; gt;
gt; gt; Select all the rows, including the column headers, in the list you want to
gt; gt; filter.
gt; gt;
gt; gt; Click the top left cell of the range, and then drag to the bottom right cell.
gt; gt; On the Data menu, point to Filter, and then click Advanced Filter.
gt; gt; In the Advanced Filter dialog box, click Filter the list, in place.
gt; gt; Select the Unique records only check box, and then click OK.
gt; gt; The filtered list is displayed and the duplicate rows are hidden.
gt; gt;
gt; gt; On the Edit menu, click Office Clipboard.
gt; gt; The Clipboard task pane is displayed.
gt; gt;
gt; gt; Make sure the filtered list is still selected, and then click Copy .
gt; gt; The filtered list is highlighted with bounding outlines and the selection
gt; gt; appears as an item at the top of the Clipboard.
gt; gt;
gt; gt; On the Data menu, point to Filter, and then click Show All.
gt; gt; The original list is re-displayed.
gt; gt;
gt; gt; Press the DELETE key.
gt; gt; The original list is deleted.
gt; gt;
gt; gt; In the Clipboard, click on the filtered list item.
gt; gt; The filtered list appears in the same location as the original list.
gt; gt;
gt; gt; Regards...
gt; gt;
gt; gt; --
gt; gt; Ken Hudson
gt; gt;
gt; gt;
gt; gt; quot;Sdbenn90quot; wrote:
gt; gt;
gt; gt; gt; I need a formula that will do the following: I want to copy A1:A3 to
gt; gt; gt; different cells A10:A12. if the upper cells have identical entries I want the
gt; gt; gt; lower cells to have the duplicated entry only once.
gt; gt; gt;
gt; gt; gt; A
gt; gt; gt; 1 Joe
gt; gt; gt; 2 Bill
gt; gt; gt; 3 Joe
gt; gt; gt; Because Joe was entered twice in the upper cells I want
gt; gt; gt; the result to look like the lower cells. Essentually grouping like entries in
gt; gt; gt; the upper cell to one entry in the lower cell.
gt; gt; gt; A
gt; gt; gt; 10 Bill
gt; gt; gt; 11 Joe
gt; gt; gt; 12
gt; gt; gt;
gt; gt; gt; Any help regarding this matter will be greatly appreciated. Thanks for your
gt; gt; gt; time.

There is only one column to manipulate
No, I want the old data to remain as it is
Thanks.

quot;Ken Hudsonquot; wrote:

gt; A couple of questions....
gt; Do you have only one column of data (column A) to manipulate?
gt; Is it okay to write over the old data with the unique list?
gt;
gt; --
gt; Ken Hudson
gt;
gt;
gt; quot;Sdbenn90quot; wrote:
gt;
gt; gt; That worked great, but I was looking for something that would do this
gt; gt; automatically.
gt; gt;
gt; gt; quot;Ken Hudsonquot; wrote:
gt; gt;
gt; gt; gt; Hi,
gt; gt; gt; A macro could do it, but you might first try using the filter function.
gt; gt; gt; Here is the description from Excel help:
gt; gt; gt;
gt; gt; gt; Applies to
gt; gt; gt; Microsoft Office Excel 2003
gt; gt; gt; Microsoft Excel 2002
gt; gt; gt;
gt; gt; gt; A duplicate row (also called a record) in a list is one where all values in
gt; gt; gt; the row are an exact match of all the values in another row. To delete
gt; gt; gt; duplicate rows, you filter a list for unique rows, delete the original list,
gt; gt; gt; and then replace it with the filtered list. The original list must have
gt; gt; gt; column headers.
gt; gt; gt;
gt; gt; gt; Caution Because you are permanently deleting data, it's a good idea to
gt; gt; gt; copy the original list to another worksheet or workbook before using the
gt; gt; gt; following procedure.
gt; gt; gt;
gt; gt; gt; Select all the rows, including the column headers, in the list you want to
gt; gt; gt; filter.
gt; gt; gt;
gt; gt; gt; Click the top left cell of the range, and then drag to the bottom right cell.
gt; gt; gt; On the Data menu, point to Filter, and then click Advanced Filter.
gt; gt; gt; In the Advanced Filter dialog box, click Filter the list, in place.
gt; gt; gt; Select the Unique records only check box, and then click OK.
gt; gt; gt; The filtered list is displayed and the duplicate rows are hidden.
gt; gt; gt;
gt; gt; gt; On the Edit menu, click Office Clipboard.
gt; gt; gt; The Clipboard task pane is displayed.
gt; gt; gt;
gt; gt; gt; Make sure the filtered list is still selected, and then click Copy .
gt; gt; gt; The filtered list is highlighted with bounding outlines and the selection
gt; gt; gt; appears as an item at the top of the Clipboard.
gt; gt; gt;
gt; gt; gt; On the Data menu, point to Filter, and then click Show All.
gt; gt; gt; The original list is re-displayed.
gt; gt; gt;
gt; gt; gt; Press the DELETE key.
gt; gt; gt; The original list is deleted.
gt; gt; gt;
gt; gt; gt; In the Clipboard, click on the filtered list item.
gt; gt; gt; The filtered list appears in the same location as the original list.
gt; gt; gt;
gt; gt; gt; Regards...
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; Ken Hudson
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Sdbenn90quot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I need a formula that will do the following: I want to copy A1:A3 to
gt; gt; gt; gt; different cells A10:A12. if the upper cells have identical entries I want the
gt; gt; gt; gt; lower cells to have the duplicated entry only once.
gt; gt; gt; gt;
gt; gt; gt; gt; A
gt; gt; gt; gt; 1 Joe
gt; gt; gt; gt; 2 Bill
gt; gt; gt; gt; 3 Joe
gt; gt; gt; gt; Because Joe was entered twice in the upper cells I want
gt; gt; gt; gt; the result to look like the lower cells. Essentually grouping like entries in
gt; gt; gt; gt; the upper cell to one entry in the lower cell.
gt; gt; gt; gt; A
gt; gt; gt; gt; 10 Bill
gt; gt; gt; gt; 11 Joe
gt; gt; gt; gt; 12
gt; gt; gt; gt;
gt; gt; gt; gt; Any help regarding this matter will be greatly appreciated. Thanks for your
gt; gt; gt; gt; time.

Okay, give this macro a try.
Be sure to make a back up of your workbook.
The macro assumes that there is no header row.

To set up and run the macro:
With the workbook open, press Alt-F11 to open visual basic.
Go to Insert gt; Module.
Copy and paste the code from below into the module.
Close Visual Basic.
Back on the worksheet go to Tools gt; Macro gt; Macros...
Highlight the macro and click the Run button.

Code....

Option Explicit
Sub CompressRecs()

Dim Iloop As Double
Dim NumRowsA As Double
Dim NumRowsB As Double
NumRowsA = Range(quot;A65536quot;).End(xlUp).Row
Columns(quot;Aquot;).Copy
Columns(quot;Bquot;).Select
ActiveSheet.Paste
Range(quot;B1:Bquot; amp; NumRowsA).Select
Selection.Sort Key1:=Range(quot;B1quot;), Order1:=xlAscending, _
Header:=xlNo, OrderCustom:=1, MatchCase:= _
False, Orientation:=xlTopToBottom
For Iloop = NumRowsA To 2 Step -1
If Cells(Iloop, quot;Bquot;) = Cells(Iloop - 1, quot;Bquot;) Then
Cells(Iloop, quot;Bquot;).Delete Shift:=xlUp
End If
Next Iloop
NumRowsB = Range(quot;B65536quot;).End(xlUp).Row
Range(quot;B1:Bquot; amp; NumRowsB).Cut
Range(quot;Aquot; amp; NumRowsA 2).Select
ActiveSheet.Paste
Range(quot;A1quot;).Select

End Sub

--
Ken Hudsonquot;Sdbenn90quot; wrote:

gt; There is only one column to manipulate
gt; No, I want the old data to remain as it is
gt; Thanks.
gt;
gt; quot;Ken Hudsonquot; wrote:
gt;
gt; gt; A couple of questions....
gt; gt; Do you have only one column of data (column A) to manipulate?
gt; gt; Is it okay to write over the old data with the unique list?
gt; gt;
gt; gt; --
gt; gt; Ken Hudson
gt; gt;
gt; gt;
gt; gt; quot;Sdbenn90quot; wrote:
gt; gt;
gt; gt; gt; That worked great, but I was looking for something that would do this
gt; gt; gt; automatically.
gt; gt; gt;
gt; gt; gt; quot;Ken Hudsonquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Hi,
gt; gt; gt; gt; A macro could do it, but you might first try using the filter function.
gt; gt; gt; gt; Here is the description from Excel help:
gt; gt; gt; gt;
gt; gt; gt; gt; Applies to
gt; gt; gt; gt; Microsoft Office Excel 2003
gt; gt; gt; gt; Microsoft Excel 2002
gt; gt; gt; gt;
gt; gt; gt; gt; A duplicate row (also called a record) in a list is one where all values in
gt; gt; gt; gt; the row are an exact match of all the values in another row. To delete
gt; gt; gt; gt; duplicate rows, you filter a list for unique rows, delete the original list,
gt; gt; gt; gt; and then replace it with the filtered list. The original list must have
gt; gt; gt; gt; column headers.
gt; gt; gt; gt;
gt; gt; gt; gt; Caution Because you are permanently deleting data, it's a good idea to
gt; gt; gt; gt; copy the original list to another worksheet or workbook before using the
gt; gt; gt; gt; following procedure.
gt; gt; gt; gt;
gt; gt; gt; gt; Select all the rows, including the column headers, in the list you want to
gt; gt; gt; gt; filter.
gt; gt; gt; gt;
gt; gt; gt; gt; Click the top left cell of the range, and then drag to the bottom right cell.
gt; gt; gt; gt; On the Data menu, point to Filter, and then click Advanced Filter.
gt; gt; gt; gt; In the Advanced Filter dialog box, click Filter the list, in place.
gt; gt; gt; gt; Select the Unique records only check box, and then click OK.
gt; gt; gt; gt; The filtered list is displayed and the duplicate rows are hidden.
gt; gt; gt; gt;
gt; gt; gt; gt; On the Edit menu, click Office Clipboard.
gt; gt; gt; gt; The Clipboard task pane is displayed.
gt; gt; gt; gt;
gt; gt; gt; gt; Make sure the filtered list is still selected, and then click Copy .
gt; gt; gt; gt; The filtered list is highlighted with bounding outlines and the selection
gt; gt; gt; gt; appears as an item at the top of the Clipboard.
gt; gt; gt; gt;
gt; gt; gt; gt; On the Data menu, point to Filter, and then click Show All.
gt; gt; gt; gt; The original list is re-displayed.
gt; gt; gt; gt;
gt; gt; gt; gt; Press the DELETE key.
gt; gt; gt; gt; The original list is deleted.
gt; gt; gt; gt;
gt; gt; gt; gt; In the Clipboard, click on the filtered list item.
gt; gt; gt; gt; The filtered list appears in the same location as the original list.
gt; gt; gt; gt;
gt; gt; gt; gt; Regards...
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt; Ken Hudson
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Sdbenn90quot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; I need a formula that will do the following: I want to copy A1:A3 to
gt; gt; gt; gt; gt; different cells A10:A12. if the upper cells have identical entries I want the
gt; gt; gt; gt; gt; lower cells to have the duplicated entry only once.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; A
gt; gt; gt; gt; gt; 1 Joe
gt; gt; gt; gt; gt; 2 Bill
gt; gt; gt; gt; gt; 3 Joe
gt; gt; gt; gt; gt; Because Joe was entered twice in the upper cells I want
gt; gt; gt; gt; gt; the result to look like the lower cells. Essentually grouping like entries in
gt; gt; gt; gt; gt; the upper cell to one entry in the lower cell.
gt; gt; gt; gt; gt; A
gt; gt; gt; gt; gt; 10 Bill
gt; gt; gt; gt; gt; 11 Joe
gt; gt; gt; gt; gt; 12
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Any help regarding this matter will be greatly appreciated. Thanks for your
gt; gt; gt; gt; gt; time.

Thanks exactly want I needed. Thank you so much for your help.

quot;Ken Hudsonquot; wrote:

gt; Okay, give this macro a try.
gt; Be sure to make a back up of your workbook.
gt; The macro assumes that there is no header row.
gt;
gt; To set up and run the macro:
gt; With the workbook open, press Alt-F11 to open visual basic.
gt; Go to Insert gt; Module.
gt; Copy and paste the code from below into the module.
gt; Close Visual Basic.
gt; Back on the worksheet go to Tools gt; Macro gt; Macros...
gt; Highlight the macro and click the Run button.
gt;
gt; Code....
gt;
gt; Option Explicit
gt; Sub CompressRecs()
gt;
gt; Dim Iloop As Double
gt; Dim NumRowsA As Double
gt; Dim NumRowsB As Double
gt; NumRowsA = Range(quot;A65536quot;).End(xlUp).Row
gt; Columns(quot;Aquot;).Copy
gt; Columns(quot;Bquot;).Select
gt; ActiveSheet.Paste
gt; Range(quot;B1:Bquot; amp; NumRowsA).Select
gt; Selection.Sort Key1:=Range(quot;B1quot;), Order1:=xlAscending, _
gt; Header:=xlNo, OrderCustom:=1, MatchCase:= _
gt; False, Orientation:=xlTopToBottom
gt; For Iloop = NumRowsA To 2 Step -1
gt; If Cells(Iloop, quot;Bquot;) = Cells(Iloop - 1, quot;Bquot;) Then
gt; Cells(Iloop, quot;Bquot;).Delete Shift:=xlUp
gt; End If
gt; Next Iloop
gt; NumRowsB = Range(quot;B65536quot;).End(xlUp).Row
gt; Range(quot;B1:Bquot; amp; NumRowsB).Cut
gt; Range(quot;Aquot; amp; NumRowsA 2).Select
gt; ActiveSheet.Paste
gt; Range(quot;A1quot;).Select
gt;
gt; End Sub
gt;
gt; --
gt; Ken Hudson
gt;
gt;
gt; quot;Sdbenn90quot; wrote:
gt;
gt; gt; There is only one column to manipulate
gt; gt; No, I want the old data to remain as it is
gt; gt; Thanks.
gt; gt;
gt; gt; quot;Ken Hudsonquot; wrote:
gt; gt;
gt; gt; gt; A couple of questions....
gt; gt; gt; Do you have only one column of data (column A) to manipulate?
gt; gt; gt; Is it okay to write over the old data with the unique list?
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; Ken Hudson
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Sdbenn90quot; wrote:
gt; gt; gt;
gt; gt; gt; gt; That worked great, but I was looking for something that would do this
gt; gt; gt; gt; automatically.
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Ken Hudsonquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; Hi,
gt; gt; gt; gt; gt; A macro could do it, but you might first try using the filter function.
gt; gt; gt; gt; gt; Here is the description from Excel help:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Applies to
gt; gt; gt; gt; gt; Microsoft Office Excel 2003
gt; gt; gt; gt; gt; Microsoft Excel 2002
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; A duplicate row (also called a record) in a list is one where all values in
gt; gt; gt; gt; gt; the row are an exact match of all the values in another row. To delete
gt; gt; gt; gt; gt; duplicate rows, you filter a list for unique rows, delete the original list,
gt; gt; gt; gt; gt; and then replace it with the filtered list. The original list must have
gt; gt; gt; gt; gt; column headers.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Caution Because you are permanently deleting data, it's a good idea to
gt; gt; gt; gt; gt; copy the original list to another worksheet or workbook before using the
gt; gt; gt; gt; gt; following procedure.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Select all the rows, including the column headers, in the list you want to
gt; gt; gt; gt; gt; filter.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Click the top left cell of the range, and then drag to the bottom right cell.
gt; gt; gt; gt; gt; On the Data menu, point to Filter, and then click Advanced Filter.
gt; gt; gt; gt; gt; In the Advanced Filter dialog box, click Filter the list, in place.
gt; gt; gt; gt; gt; Select the Unique records only check box, and then click OK.
gt; gt; gt; gt; gt; The filtered list is displayed and the duplicate rows are hidden.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; On the Edit menu, click Office Clipboard.
gt; gt; gt; gt; gt; The Clipboard task pane is displayed.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Make sure the filtered list is still selected, and then click Copy .
gt; gt; gt; gt; gt; The filtered list is highlighted with bounding outlines and the selection
gt; gt; gt; gt; gt; appears as an item at the top of the Clipboard.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; On the Data menu, point to Filter, and then click Show All.
gt; gt; gt; gt; gt; The original list is re-displayed.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Press the DELETE key.
gt; gt; gt; gt; gt; The original list is deleted.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; In the Clipboard, click on the filtered list item.
gt; gt; gt; gt; gt; The filtered list appears in the same location as the original list.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Regards...
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; --
gt; gt; gt; gt; gt; Ken Hudson
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; quot;Sdbenn90quot; wrote:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; I need a formula that will do the following: I want to copy A1:A3 to
gt; gt; gt; gt; gt; gt; different cells A10:A12. if the upper cells have identical entries I want the
gt; gt; gt; gt; gt; gt; lower cells to have the duplicated entry only once.
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; A
gt; gt; gt; gt; gt; gt; 1 Joe
gt; gt; gt; gt; gt; gt; 2 Bill
gt; gt; gt; gt; gt; gt; 3 Joe
gt; gt; gt; gt; gt; gt; Because Joe was entered twice in the upper cells I want
gt; gt; gt; gt; gt; gt; the result to look like the lower cells. Essentually grouping like entries in
gt; gt; gt; gt; gt; gt; the upper cell to one entry in the lower cell.
gt; gt; gt; gt; gt; gt; A
gt; gt; gt; gt; gt; gt; 10 Bill
gt; gt; gt; gt; gt; gt; 11 Joe
gt; gt; gt; gt; gt; gt; 12
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; Any help regarding this matter will be greatly appreciated. Thanks for your
gt; gt; gt; gt; gt; gt; time.