LinkBack URL
About LinkBacks
i want to create a excel sheet with following columns
Item code Desp. Quantity
is there any formula which can check that item code being entered is not repeated.
i want to create a excel sheet with following columns
Item code Desp. Quantity
is there any formula which can check that item code being entered is not repeated.
Last edited by suhail; 10-24-2010 at 10:16 PM.
Hi,
Assuming the item code is in column A, in a helper column, say column D add the formula
and copy down as many roes as necessary.
Please Login or Register to view this content.
Rgds
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
thanx
one more is there any that when u enter the same number the cell does not move forward and ask to correct the entry
You can use a custom formula in Data Validation
=COUNTIF(A:A,A1)=0
and then set the error message to "Already entered"
cheers
Thanx Richard Buttrey & teylyn
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks