You can use the COUNTIF function to select a range of cells and find out HOW MANY matches (text or other) it finds in that range.
=COUNTIF($B$2:$B$15,D2)
Dawn Monroe Training
Microsoft Office Specialist Master
Wichita, KS, USA
https://dawnmonroetraining.com/
PLEASE SUBSCRIBE for more tips!
🔔 Subscribe for Updates 🔔
YouTube: / dawnmonroetraining
❤️ Connect on Social ❤️
LinkedIn: / dawnmonroetraining
Facebook: / dawnmonroe.training
💥 View Learning Opportunities💥
Calendar: https://learn.dawnmonroetraining.com/...
Website: https://dawnmonroetraining.com/
#microsoft #365 #excel #excelfunctions #countif