|
|
#2
10-11-2022, 08:11 AM
|
|||
|
|||
The simplest way is to add a helper column with formula like =(Date(MID(A2,1,4),MID(A2,5,2),MID(A2,7,2))=B2) (replace cell references according your table structure), and then setting autofilter for this helper column to TRUE
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Conditional formatting showing duplicates across multiple columns not NOT same row
|
Peterson | Excel | 2 | 04-05-2021 09:43 PM |
| Merging all data between two sheets into a third one without duplicates or rows or columns | Ricko_uk | Excel | 4 | 08-27-2020 01:16 AM |
| Split selected columns, or all columns exept for Column1 | Cendrinne | Word VBA | 2 | 09-20-2019 09:14 PM |
|
Macro to check against Columns & Delete Duplicates
|
cjamps | Excel Programming | 27 | 12-18-2017 06:38 AM |
| Duplicates | riothecat | Excel | 1 | 02-28-2017 03:31 PM |
Windows 8 
Office 2016
Threaded Mode