Hi all,
Is there any way for excel to alert me to a duplicate value entered into the same column? Preferably ignoring capitalization (as my values do have alpha characters)
I have a spreadsheet that lists all my inventory, and it would be a pretty big issue if I gave the same inventory # to 2 different products!
Thanks