| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
duplicate dates
In a worksheet with multiple columns of dates, how can I identify any
duplicate dates , if any, among columns. many thanks -- db |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
duplicate dates
Conditional Formatting
=COUNTIF($A:$F,A1)1 adjust your range to suit "db" wrote: In a worksheet with multiple columns of dates, how can I identify any duplicate dates , if any, among columns. many thanks -- db |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| subtotal by week with duplicate dates? | Excel Discussion (Misc queries) | |||
| How do you delete duplicate addresses, but keep duplicate names? | Excel Discussion (Misc queries) | |||
| Simple Way to Count the Number of Duplicate Dates on Multiple Worksheets | Excel Discussion (Misc queries) | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
| I need to exclude duplicate patient names for dates of service is. | Excel Discussion (Misc queries) | |||
Linear Mode
