LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 30
Default validating data in acolumn

Hi all, I've got a column of invoice numbers and each time I add one I want
to make sure it it is not duplicated. I've tried using a function with
copy/paste validation, but it doesn't always work as the invoices can be text
as well as number. Any ideas. Thanks very much.
--
delmac
 
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
Connecting of two data validating with each other Akhil Excel Worksheet Functions 1 August 10th 06 09:01 PM
validating data in a combobox Jono Excel Worksheet Functions 0 March 13th 06 05:51 PM
avoid retype the number more than one time withen acolumn This no. already exist Excel Discussion (Misc queries) 1 April 4th 05 10:25 AM
Validating data in a spreadsheet control Nuncle[_2_] Excel Programming 0 September 30th 04 08:00 AM
Validating entered data as date Mr. B[_3_] Excel Programming 2 April 9th 04 01:40 PM


All times are GMT +1. The time now is 05:11 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"