Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
help with my inventory
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: http://www.excelforum.com/member.php...o&userid=33294 View this thread: http://www.excelforum.com/showthread...hreadid=531186 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
help with my inventory
Assume you type in the product code in Column A, click column A header to
select the whole column with A1 as active then do datavalidation, allowcustom and put this in the formula box =COUNTIF($A$1:A1,A1)<=1 now try to enter a duplicate -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "juliocrd" wrote in message ... 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: http://www.excelforum.com/member.php...o&userid=33294 View this thread: http://www.excelforum.com/showthread...hreadid=531186 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sales journal and inventory management | Excel Discussion (Misc queries) | |||
Associating data across worksheets from an inventory that's sorted | Excel Discussion (Misc queries) | |||
Inventory List Question | Excel Discussion (Misc queries) | |||
Make inventory sheet to track, order & reduce quantity from master | Excel Worksheet Functions | |||
How can i get an inventory list that adds and subtracts inventory | Excel Discussion (Misc queries) |