Thread: [Solved] Highlight values not registered
View Single Post
 
Old 09-24-2020, 07:17 AM
Purfleet Purfleet is offline Windows 10 Office 2019
Expert
  
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default
There must be a better way, possibly with advanced filter or PQ. But this seems to work for a formula

=IF(C2<>"","",IF(COUNTIFS($A$2:A2,A2)<COUNTIFS(Nam e,A2),"",IF(LARGE(--(Name=Registration!$A2)*(Date_of_Registration),1)> $F$1,"","Check")))
Attached Files
File Type: xlsx Registration_purfleet.xlsx (15.8 KB, 8 views)
Reply With Quote