Thread
:
Pairing duplicates in different columns?
View Single Post
10-11-2022, 08:11 AM
ArviLaanemets
Windows 8
Office 2016
Expert
Join Date: May 2017
Posts: 949
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
ArviLaanemets
View Public Profile
Find all posts by ArviLaanemets