duplicate dates

D

db

In a worksheet with multiple columns of dates, how can I identify any
duplicate dates , if any, among columns. many thanks
 
G

Glenn

db said:
In a worksheet with multiple columns of dates, how can I identify any
duplicate dates , if any, among columns. many thanks
Click to expand...


One way would be with conditional formatting. Assuming your data is in A1:C100,
select that range, starting with A1, and put the following in the conditional
formatting "Formula is":

=COUNTIF($A$1:$C$100,A1)>1

Then select the format you want to use to identify duplicates.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Average dates help 0
Finding duplicate records 4
Reserved dates 3
2 criteria 1
Check if Duplicate with Exceptions 6
Sorting dates, ignoring year 3
Date Format 3
Hybrid vlookup - sum function 2

Top