| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| using If statement to change values in a range | Excel Worksheet Functions | |||
| How do I look up values from a range of values? | Excel Worksheet Functions | |||
| MIN with zero values in the range | Excel Discussion (Misc queries) | |||
| Use MATCH to find position of max in 2D range? | Excel Worksheet Functions | |||
Hybrid Mode
