| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I compare the entry in one cell against all other cells
How do I compare the entry in one cell against all other cells in the same
column, except the cell the entry is in, and make it display the entry in a different cell if it matches. I almost have it, but I'm getting all duplicates becuase the entry matches itself. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I compare the entry in one cell against all other cells
=if(countif(a:a,a25)1,a25,"")
Micki wrote: How do I compare the entry in one cell against all other cells in the same column, except the cell the entry is in, and make it display the entry in a different cell if it matches. I almost have it, but I'm getting all duplicates becuase the entry matches itself. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying functions from one cell to other cells | New Users to Excel | |||
| Return entry in column above/below cell | Excel Worksheet Functions | |||
| How to insert a value in one cell into many cells | Excel Worksheet Functions | |||
| How do I double click a cell and jump to cell's referenced cell | Excel Discussion (Misc queries) | |||
| Function syntax to compare cell contents | Excel Worksheet Functions | |||
Linear Mode
