List shifts by location
Choose a location. FILTER lists the corresponding shift rows in a separate output area.
Copyable formulas
English Excel · en-US
=FILTER(A2:C5,B2:B5=E2,"No records")Turkish Excel · tr-TR
=FİLTRE(A2:C5;B2:B5=E2;"Kayıt yok")Sample data
Enter the headers and sample records in A1:C5.
| Employee | Location | Shift |
|---|---|---|
| Deniz | L01 | V1 |
| Ada | L02 | V2 |
| Ege | L01 | V3 |
| Ekin | L03 | V1 |
- E2 = L01
Keep F2:H3 clear.
Enter the formula in F2.
To try the Turkish formula, use the sample data on the Turkish page.
Expected result
Deniz | L01 | V1 and Ege | L01 | V3
How it works
The condition compares each row in column B with E2. The result spills across three columns from F2. Set E2 to L99 and the formula displays No records in one cell.
Compatibility
Excel for Microsoft 365, Excel 2021, and Excel 2024.