ExcelFlux

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.

Microsoft Excel reference