software

There should be an option or formula that you can run on excel to find all
duplicated line items for example:

Line 1 has John Doe
Line 2 has John Doe
Line 3 has Jane Doe
Line 4 has Jane Doe

Each line and column has the same date for each person. It would be easier,
especially if there are over 1400 rows to use an option to find and select
all duplicated lines and delete them without have to go through the whole
document which takes up to much time.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the quot;I
Agreequot; button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click quot;I Agreequot; in the message pane.

www.microsoft.com/office/comm...et.f unctions

You can already do this, use datagt;advanced filter, select unique records
only.--

Regards,

Peo Sjoblom

nwexcelsolutions.com
quot;Faith Shirleyquot; lt;Faith gt; wrote in message
...
gt; There should be an option or formula that you can run on excel to find all
gt; duplicated line items for example:
gt;
gt; Line 1 has John Doe
gt; Line 2 has John Doe
gt; Line 3 has Jane Doe
gt; Line 4 has Jane Doe
gt;
gt; Each line and column has the same date for each person. It would be
gt; easier,
gt; especially if there are over 1400 rows to use an option to find and select
gt; all duplicated lines and delete them without have to go through the whole
gt; document which takes up to much time.
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; Agreequot; button in the message pane. If you do not see the button, follow
gt; this
gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; click quot;I Agreequot; in the message pane.
gt;
gt; www.microsoft.com/office/comm...et.f unctions
Thank you.

quot;Peo Sjoblomquot; wrote:

gt; You can already do this, use datagt;advanced filter, select unique records
gt; only.
gt;
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; nwexcelsolutions.com
gt;
gt;
gt;
gt; quot;Faith Shirleyquot; lt;Faith gt; wrote in message
gt; ...
gt; gt; There should be an option or formula that you can run on excel to find all
gt; gt; duplicated line items for example:
gt; gt;
gt; gt; Line 1 has John Doe
gt; gt; Line 2 has John Doe
gt; gt; Line 3 has Jane Doe
gt; gt; Line 4 has Jane Doe
gt; gt;
gt; gt; Each line and column has the same date for each person. It would be
gt; gt; easier,
gt; gt; especially if there are over 1400 rows to use an option to find and select
gt; gt; all duplicated lines and delete them without have to go through the whole
gt; gt; document which takes up to much time.
gt; gt;
gt; gt; ----------------
gt; gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; gt; Agreequot; button in the message pane. If you do not see the button, follow
gt; gt; this
gt; gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; gt; click quot;I Agreequot; in the message pane.
gt; gt;
gt; gt; www.microsoft.com/office/comm...et.f unctions
gt;
gt;
gt;