Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-14-2012, 04:39 AM
tatihulot tatihulot is offline How Can I Flag Duplicate Date Entries? Windows 7 How Can I Flag Duplicate Date Entries? Office 2010 (Version 14.0)
Advanced Beginner
How Can I Flag Duplicate Date Entries?
 
Join Date: Apr 2010
Posts: 38
tatihulot is on a distinguished road
Default How Can I Flag Duplicate Date Entries?

Hello. I'm using Excel 2010.

I'm not much of a spreadsheet designer, so I'm hoping what I want to do is fairly simple.

I want to flag duplicate dates somehow. Here's what I mean:

My spreadsheet has columns for Last Name, First Name, etc. The standard data. One column in particular has dates, formatted like this: 11/14/12.

All I want is for Excel to display a warning or a flag of some sort, if I type in a date that is already in that column. It is not necessary for Excel to inform me which cell has the already-entered date.

So…let's say 03/18/10 is in cell D-10.



If I enter 03/18/10 in oh, let's say cell D-59, I want Excel to inform me somehow that this date has already been entered elsewhere in the same column.

Is this possible? If so, then what is the easiest and most practical way to accomplish this?

If you require further details from me, please let me know.

Thank you very much. J. Danniel
Reply With Quote
  #2  
Old 11-14-2012, 05:24 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline How Can I Flag Duplicate Date Entries? Windows 7 64bit How Can I Flag Duplicate Date Entries? Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,747
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

One way would be using Conditional formatting
If you plan to always enter your reference date in D59 try the following :
Select the range containing tour dates to check (say D150) - go to Conditional Formatting - Use a formula
As formula enter
Code:
=COUNTIF($D1:$D50, D59)
and choose the format you want when the condition is true The formatting of the duplicate will then change in your range

If the dates in range D150 are not true dates, let us know so w can help further

There are also other possibilities
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 11-14-2012, 11:22 AM
Kevin@Radstock Kevin@Radstock is offline How Can I Flag Duplicate Date Entries? Windows 7 32bit How Can I Flag Duplicate Date Entries? Office 2010 32bit
Office 365
 
Join Date: Feb 2012
Posts: 94
Kevin@Radstock is on a distinguished road
Default

Hi tatihulot

I am not a great lover of the built in Conditional Formatting. But here you go, nice and simple. Select the range you wish to conditionally format. Home tab > Styles > Conditional formatting > Highlight cell rules > Duplicate values > Format as required.
Reply With Quote
  #4  
Old 11-14-2012, 12:27 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline How Can I Flag Duplicate Date Entries? Windows 7 64bit How Can I Flag Duplicate Date Entries? Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,747
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

@Kevin
As the OP explained, he wants to enter a date in a cell and check a range to see if that date is already there.
I'm afraid the solution you proposed will not help in this case
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #5  
Old 11-15-2012, 12:25 AM
Kevin@Radstock Kevin@Radstock is offline How Can I Flag Duplicate Date Entries? Windows 7 32bit How Can I Flag Duplicate Date Entries? Office 2010 32bit
Office 365
 
Join Date: Feb 2012
Posts: 94
Kevin@Radstock is on a distinguished road
Default

@ Pecoflyer

If I were you I should read the question again.

The OP has written "I want to flag duplicate dates somehow" & "If I enter 03/18/10 in oh, let's say cell D-59". Has he said that he wants to reference D59 all the time!! I think not.

Rightly or wrongly, the OP has requested that there is some kind of warning that if he enters a date in column D that already exist then flag them. so what you are suggesting, is the answer I come up with will not work. Is that correct!!
Reply With Quote
  #6  
Old 11-16-2012, 12:19 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline How Can I Flag Duplicate Date Entries? Windows 7 64bit How Can I Flag Duplicate Date Entries? Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,747
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

I agree it can also be interpreted that way
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Follow-up flag--IMAP vs. POP3? markg2 Outlook 0 10-28-2012 05:02 PM
How Can I Flag Duplicate Date Entries? Meaning of current date vs status date when saving baselines ketanco Project 1 02-08-2012 02:20 PM
How Can I Flag Duplicate Date Entries? Change flag in margin for compare (legal blackline)? Jennifer Murphy Word 1 01-16-2012 09:13 PM
Task closing when flag is cleared pro3carp3 Outlook 1 12-05-2011 10:21 PM
Move Outlook 2007 Flag Status wes newman Outlook 0 10-15-2009 10:59 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:40 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft