Welcome to MacForumz.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Preventing Duplicate Entries Across Sheets

 
   Macintosh computer (Home) -> Excel RSS
Next:  Problem with mround  
Author Message
Ken10

External


Since: Dec 01, 2003
Posts: 9



(Msg. 1) Posted: Wed Apr 14, 2004 4:48 pm
Post subject: Preventing Duplicate Entries Across Sheets
Archived from groups: microsoft>public>mac>office>excel (more info?)

Anyone know how to prevent duplicate entries of numbers.
e.g. I have two sheets. I want to make sure that the same
number is not entered more than once. Thank you.

 >> Stay informed about: Preventing Duplicate Entries Across Sheets 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Strange PC apostophe in formula preventing Mac spreadsheet.. - Hi, I have downloaded data in Excel format from a PC server onto my Mac OS X 10.3.9. I have Excel 2001. The data in the formula bar of every cell starts with an apostrophe ( ' ) before the text or numerals. I'm trying to sort but the sort function..

Work Sheets - Is there a way to ask a Work book to arrange it's Work sheets in Numerical order? I created a Work Book for Inventory purposes, with a start page. I recently added about 100 new items and linked them departments. On the start page I keep..

Blank sheets after 10.1.5 update - I'm on a Mac using Panther. I've recently installed to the Office X 10.1.5 update. Shortly after starting work on a large workbook and on switching from one sheet to another, the sheet display goes blank. All other operations continue but I can't..

names data sheets in excell -

tabs for selected sheets - I find it a little difficult to distinguish betweeen selected and unselected sheets by looking at the tabs. Is it possible to color selected tabs or make some other change? Thanks for any help. Charlie
   Macintosh computer (Home) -> Excel All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]