close

Hello,

In a particular spreadsheet, I would like to verify if the same name is
listed on multiple rows. The name is entered in multiple columns on the
same row, that is acceptable, but I would like to know if the name is
entered on multiple rows regardless of the column. How can I check
this?

THANKS,
karmen--
Karmen
------------------------------------------------------------------------
Karmen's Profile: www.excelforum.com/member.php...oamp;userid=30972
View this thread: www.excelforum.com/showthread...hreadid=509495Presume you're checking some specific names ?
One way to quickly check is to use autofilter (Data gt; Filter gt; Autofilter)
Select quot;Customquot; from the droplist, then enter/paste the specific name gt; OK
Then reset the droplist to quot;(All)quot;, repeat the check for each col concerned
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;Karmenquot; gt; wrote in
message ...
gt;
gt; Hello,
gt;
gt; In a particular spreadsheet, I would like to verify if the same name is
gt; listed on multiple rows. The name is entered in multiple columns on the
gt; same row, that is acceptable, but I would like to know if the name is
gt; entered on multiple rows regardless of the column. How can I check
gt; this?
gt;
gt; THANKS,
gt; karmen
gt;
gt;
gt; --
gt; Karmen
gt; ------------------------------------------------------------------------
gt; Karmen's Profile:
www.excelforum.com/member.php...oamp;userid=30972
gt; View this thread: www.excelforum.com/showthread...hreadid=509495
gt;
Karmen wrote:
gt; Hello,
gt;
gt; In a particular spreadsheet, I would like to verify if the same name is
gt; listed on multiple rows. The name is entered in multiple columns on the
gt; same row, that is acceptable, but I would like to know if the name is
gt; entered on multiple rows regardless of the column. How can I check
gt; this?
gt;
gt; THANKS,
gt; karmen
gt;
gt;
Try using COUNTIF(...) gt; 1 as a test.

You can change the ranges in my example to match what you need.

Lets make the following assumptions
A120 contains your data
Column A contains the names you want to check for duplicates
Column E will contain TRUE for duplicates

The following will work for single column to be checked.
Enter this in E1 and copy down to E20
=COUNTIF($A$1:$A$20,A1)gt;1

In your case you may need something like this.
Enter this in E1 and copy down to E20
=COUNTIF($A$1:$D$20,A1)gt;COUNTIF($A1:$D1,A1)
This checks the whole range count versus the current row count
Simple but effective.

Hope it helps
George

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()