LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ardus Petus
 
Posts: n/a
Default Repeatition of the same item

DataValidationCustomized
Formula: =COUNTIF(A:A,A1)=1

HTH
--
AP

"S.G.Pillai" a écrit dans le message de
news: ...
I want to avoid repeatition of the tags in the rows i am entering. ie.. if
i
have entered 98TI-107 once it should notify me if i am trying to enter it
once again.
Thanks



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sort bar chart in excel BuriedInSpreadSheets Charts and Charting in Excel 6 May 31st 07 04:12 PM
Pivot Table Calculated Item Dominic Excel Discussion (Misc queries) 1 April 26th 06 11:50 PM
Extract each item in the list 0-0 Wai Wai ^-^ Excel Worksheet Functions 1 December 11th 05 06:26 PM
Extract each item in the list 0-0 Wai Wai ^-^ Excel Worksheet Functions 2 September 8th 05 12:50 PM
Linking Several Worksheets to One Worksheet TangentMemory Excel Discussion (Misc queries) 1 May 10th 05 11:37 PM


All times are GMT +1. The time now is 11:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"