|
To find duplicated values in a range
and range a1:a6 if i have aaa bbb ccc ddd aaa ccc I would like to have sometype of notification that a5 is the same as a1 and a3 is the same as a6 This is the case for 350 part#s so i'm hoping theres a way to do this easily. References to tut's welcomed -- beechum1 ------------------------------------------------------------------------ beechum1's Profile: http://www.excelforum.com/member.php...o&userid=30489 View this thread: http://www.excelforum.com/showthread...hreadid=510898 |
To find duplicated values in a range
One way you could identify a duplicate value
In cell B1 type =IF(COUNTIF($A$1:A1,A1)=1,"",COUNTIF($A$1:A1,A1)) This would identify the 2nd, 3rd, 4th, etc, times that particular value has appeared. "beechum1" wrote: and range a1:a6 if i have aaa bbb ccc ddd aaa ccc I would like to have sometype of notification that a5 is the same as a1 and a3 is the same as a6 This is the case for 350 part#s so i'm hoping theres a way to do this easily. References to tut's welcomed -- beechum1 ------------------------------------------------------------------------ beechum1's Profile: http://www.excelforum.com/member.php...o&userid=30489 View this thread: http://www.excelforum.com/showthread...hreadid=510898 |
| All times are GMT +1. The time now is 11:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com