ExcelBanter - detecting duplicate input in a cell

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - detecting duplicate input in a cell (https://www.excelbanter.com/excel-worksheet-functions/127101-detecting-duplicate-input-cell.html)

leo

detecting duplicate input in a cell

guys pls help

i wonder if there's a function that can detect duplicate input in a cells
that can give me a message and its value?

im using ms excel 2003

thanks

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