Unique Numbers

[z168]

Not sure how to search it so I figured Id ask

Column A = has randow 7digit numbers

in Column B, it should be able to identify (without sorting) if any of the prior rows in Column A has duplicates

Example:

how do I do this?

 

[texasalynn]

Excel Workbook
	A	B
1	Number	Check
2	9689467	OK
3	8538991	OK
4	6362705	OK
5	5570867	OK
6	2301876	OK
7	8538991	check
Sheet1

Excel 2003

Cell Formulas
Range	Formula
B2	=IF(COUNTIF(A2:$A$2,A2)>1,"check","OK")

copy the formula down

 

[jasonb75]

One way would be

Excel Workbook
	A	B
1	Number	Check
2	9689467	OK
3	8538991	OK
4	6362705	OK
5	5570867	OK
6	2301876	OK
7	8538991	Check
Sheet

 

[z168]

One way would be

<table style="font-family: Calibri,Arial; font-size: 11pt; background-color: rgb(255, 255, 255); padding-left: 2pt; padding-right: 2pt;" border="1" cellpadding="0" cellspacing="0"> <colgroup><col style="font-weight: bold; width: 30px;"><col style="width: 64px;"><col style="width: 64px;"></colgroup><tbody><tr style="background-color: rgb(202, 202, 202); text-align: center; font-weight: bold; font-size: 8pt;"><td> </td><td>A</td><td>B</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">1</td><td>Number</td><td>Check</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">2</td><td style="text-align: right;">9689467</td><td>OK</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">3</td><td style="text-align: right;">8538991</td><td>OK</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">4</td><td style="text-align: right;">6362705</td><td>OK</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">5</td><td style="text-align: right;">5570867</td><td>OK</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">6</td><td style="text-align: right;">2301876</td><td>OK</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">7</td><td style="text-align: right;">8538991</td><td>Check</td></tr></tbody></table>
<table style="font-family: Arial; font-size: 10pt; border-style: groove; border-color: rgb(0, 255, 0); background-color: rgb(255, 252, 249); color: rgb(0, 0, 0);"><tbody><tr><td>Spreadsheet Formulas</td></tr><tr><td><table style="font-family: Arial; font-size: 9pt;" border="1" cellpadding="2" cellspacing="0"><tbody><tr style="background-color: rgb(202, 202, 202); font-size: 10pt;"><td>Cell</td><td>Formula</td></tr><tr><td>B2</td><td>=IF(ISNA(MATCH(A2,A$1:A1,0)),"OK","Check")</td></tr></tbody></table></td></tr></tbody></table>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4

Thank you!!!