ExcelBanter - How do I compare the entry in one cell against all other cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I compare the entry in one cell against all other cells (https://www.excelbanter.com/excel-discussion-misc-queries/70755-how-do-i-compare-entry-one-cell-against-all-other-cells.html)

Micki

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.

Dave Peterson

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

All times are GMT +1. The time now is 08:08 PM.