| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I create formula to identify duplicate cells?
Using Excel 2000, I need to identify rows that have matching cells. For
example, B3=B4 and C3=C4. I have used the and/if function in the past and been able to add something to show me what was duplicated but it has been so long I can't remember how. I have a delete macro but I need to see what is duplicated instead of just getting rid of the duplicates. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create a formula with multiple contraints and answers | Excel Discussion (Misc queries) | |||
| Formula to return cell contents based on multiple conditions | Excel Worksheet Functions | |||
| using content of a cell in a formula in another cell | Excel Worksheet Functions | |||
| How can I write an if-then formula for 0 or less than 0 in cell t. | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
