ALL BUSINESS ENGLISH ARTICLES MICROSOFT EXCEL TIPS

Dynamically Filter Data in Excel – Educational Video

Filter employees by department in columns from mixed data

Function for cell A7
=FILTER($G7:$G$33;$H$7:$H$33=A6)
Function for cell B7
=FILTER($G7:$G$33;$H$7:$H$33=B6)

Music track: A Positive Direction by Aylex
Source: https://freetouse.com/music
Royalty Free Music for Video (Safe)
#mindstormGR #dynamic_filters #excel #educational

Views: 4

Comments are closed.

Pin It