Thread: [Solved] Conditional Formatting results in another column
View Single Post
 
Old 10-26-2020, 11:11 PM
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
You can do it with a rather long formula

=IFERROR(INDEX($B$2:$B$12,AGGREGATE(15,6,(ROW(B$2: B$12)-ROW($B$2)+1)/ISNA(MATCH($B$2:$B$12,$C$2:$C$12,0)),ROWS($D$22) )),"")
Attached Files
File Type: xlsm Book11_Purfleet.xlsm (19.8 KB, 9 views)
Reply With Quote