Computer Help and Spyware Removal Computer Help and Spyware Removal Computer Help and Spyware Removal Computer Help Forums Windows Startup Programs Database Spyware and Malware Removal Guides Computer Tutorials Uninstall Database File Database Computer Glossary Computer Resources
 

Welcome Guest ( Log In | Click here to Register a free account now! )



Register a free account to unlock additional features at BleepingComputer.com
Welcome to Bleeping Computer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.
Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

 
Reply to this topicStart new topic
> Microsoft Excel, lookup functions
tallredmond
post Feb 23 2008, 06:12 PM
Post #1


New Member
*

Group: Members
Posts: 6
Joined: 23-February 08
Member No.: 192,122
I run a spreadsheet at work (the details I will not bore you with!) and I would like to make some improvements to it. The sheet is a shared file which many users enter data to and I then collate this data and process it, one of the big problems I have is when a manager enters the same data twice which causes an error when processing.

What would I like to be able to do?
When data is entered I would like the sheet to look across all worksheets in the file and validate if this has already been entered (the data is in the form of a unique 7 digit numeric) if it already appears it should return an error message to tell the user that the number already exists elsewhere. Is this possible and of course if so can anyone help with the how?

Many thanks
A new user!
Go to the top of the page
 
+Quote Post
Paul Morgan
post Feb 24 2008, 06:18 AM
Post #2


New Member
*

Group: Members
Posts: 3
Joined: 23-February 08
Member No.: 192,010
google
duplicate data validation excel

here's one hit, (there are lots)
http://www.cpearson.com/excel/NoDupEntry.aspx

May be more difficult to find out how to approach it looking through all sheets

This post has been edited by Paul Morgan: Feb 24 2008, 06:19 AM
Go to the top of the page
 
+Quote Post
tallredmond
post Feb 24 2008, 03:44 PM
Post #3


New Member
*

Group: Members
Posts: 6
Joined: 23-February 08
Member No.: 192,122
Thanks for the advice, I will have a try and see the results!
Go to the top of the page
 
+Quote Post
« Next Oldest · Business Applications · Next Newest »
 

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

Lo-Fi Version Time is now: 9th January 2009 - 07:41 AM


Advertise   |   About Us   |   Terms of Use   |   Privacy Policy   |   Contact Us   |   Site Map   |   Chat   |   Tutorials   |   Uninstall List
Discussion Forums   |   The Computer Glossary   |   Resources   |   RSS Feeds   |   Startups   |   The File Database   |   Malware Removal Guides

© 2003-2008 All Rights Reserved Bleeping Computer LLC.

Powered By IP.Board © 2009  IPS, Inc.