In cell AX3:Copy down to AX50=FILTER($A$2:$F$2,ISNUMBER(MATCH($A$2:$F$2,TRANSPOSE(OFFSET($A$11:$A$55,,ROW()-3)),0)),"")
Copy the conditional formatting from AX3 to all of AX3:BC50
In cell AX3:Copy down to AX50=FILTER($A$2:$F$2,ISNUMBER(MATCH($A$2:$F$2,TRANSPOSE(OFFSET($A$11:$A$55,,ROW()-3)),0)),"")
Copy the conditional formatting from AX3 to all of AX3:BC50
Last edited by p45cal; 09-03-2024 at 02:45 AM.
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Posting Permissions
Reply With Quote