Thread: duplicate dates
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
 
Posts: 1,240
Default duplicate dates

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



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.