software

Hello, first of all, I wanna thank you for this helpfull forum, I am
just a begineer using excel, but I wanna say it is an excellent tool
for small business owner as my self.

My question is, i hava an inventory of 2000 products, and when I add
another prodcut, I usually write the product code in a cell of a
column, but at this moment I have some products with the same code, I
dont know how to discriminate those, I wanna know if somenone knows a
formula, to avoid repeat information in excel, it will be very handfull
for me.

Thanks a lot for everything.

Julio Rodriguez.--
juliocrd
------------------------------------------------------------------------
juliocrd's Profile: www.excelforum.com/member.php...oamp;userid=33294
View this thread: www.excelforum.com/showthread...hreadid=531186Assume you type in the product code in Column A, click column A header to
select the whole column with A1 as active then do datagt;validation,
allowgt;custom and put this in the formula box

=COUNTIF($A$1:A1,A1)lt;=1now try to enter a duplicate
--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;juliocrdquot; gt; wrote in
message ...
gt;
gt; Hello, first of all, I wanna thank you for this helpfull forum, I am
gt; just a begineer using excel, but I wanna say it is an excellent tool
gt; for small business owner as my self.
gt;
gt; My question is, i hava an inventory of 2000 products, and when I add
gt; another prodcut, I usually write the product code in a cell of a
gt; column, but at this moment I have some products with the same code, I
gt; dont know how to discriminate those, I wanna know if somenone knows a
gt; formula, to avoid repeat information in excel, it will be very handfull
gt; for me.
gt;
gt; Thanks a lot for everything.
gt;
gt; Julio Rodriguez.
gt;
gt;
gt; --
gt; juliocrd
gt; ------------------------------------------------------------------------
gt; juliocrd's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33294
gt; View this thread: www.excelforum.com/showthread...hreadid=531186
gt;