@bestlearnings: Quick tutorial - Highlight and count all duplicates between two excel lists #excel #exceltips #LearnOnTikTok #TikTokLearningCampaign #fyp

golden..orange :

This is great, but is there a formula for if you click on a name, it will highlight the name in (multiple) other columns only when clicking on the name? -- example: trying to see how many shifts a particular individual signed up for