Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Dont want member number to repeat in the same column.

Using Office 2000 - Excel
I have a reservations list, that I want to prevent a members number from
repeating in a column more that once. This will eliminate the chance of
double bookings.
Maybe a simple formating or more complicated as IF Function.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default Dont want member number to repeat in the same column.

See:

http://www.cpearson.com/excel/NoDupEntry.htm
--
Gary's Student


"TPkk" wrote:

Using Office 2000 - Excel
I have a reservations list, that I want to prevent a members number from
repeating in a column more that once. This will eliminate the chance of
double bookings.
Maybe a simple formating or more complicated as IF Function.

Reply
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
Changing a Number in a Column Using Arrays [email protected] Excel Worksheet Functions 3 September 12th 06 02:48 PM
repeat a formula same column same number of rows apart steveo Excel Discussion (Misc queries) 1 July 9th 06 09:54 AM
How can I setup in Excel Worksheet Column a number is not repeat? Shahzad Zameer Excel Discussion (Misc queries) 2 April 27th 06 06:21 PM
Conditional Format as a MACRO Gunjani Excel Worksheet Functions 3 March 29th 06 05:22 PM
creating a bar graph Johnfli Excel Discussion (Misc queries) 0 October 26th 05 08:16 PM


All times are GMT +1. The time now is 08:09 PM.

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

About Us

"It's about Microsoft Excel"