LinkBack URL
About LinkBacks
suhail 
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.
=IF(COUNTIF(A:A,A1)>1,"Already entered.","")
Rgds
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.=IF(COUNTIF(A:A,A1)>1,"Already entered.","")
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks