All:
With help from some of this site’s suggestions, I’ve got the following formula to pull from several worksheets:
=FILTER(VSTACK(FRR:SOD!G3:M200),(VSTACK(FRR:SOD!K3:K200)<>””)*(VSTACK(FRR:SOD!K3:K200)=”ABC XXXX”))
Is there a way to filter for a partial match within “ABC XXXX”? Think of ABC as a location, and XXXX as a job/position at that location. I would like to be able to pull everyone assigned to ABC to a new worksheet then filter by job/position. Is that possible?
I appreciate any help you all can provide.
Thanks!