Filtr na dwóch kolumnach

Filtrowanie według kilku kryteriów - Arkusz kalkulacyjny w liceum i technikum (sheet)

Autofiltr pokazuje zamówienia z Krakowa (filtr kolumny Miasto) o wartości co najmniej 70 zł (warunek w kolumnie Wartość). Ukryte wiersze nie znikają: wyłączenie filtru pokaże je z powrotem. Kolumna z aktywnym filtrem ma wyróżnioną strzałkę w nagłówku.

{"sheets":[{"name":"Arkusz1","cells":{"A1":"Data","B1":"Miasto","C1":"Produkt","D1":"Ilość","E1":"Wartość","A2":"02.11.2026","B2":"Kraków","C2":"kawa","D2":"4","E2":"96","A3":"02.11.2026","B3":"Gdańsk","C3":"herbata","D3":"2","E3":"30","A4":"03.11.2026","B4":"Wrocław","C4":"kawa","D4":"7","E4":"168","A5":"03.11.2026","B5":"Kraków","C5":"herbata","D5":"5","E5":"75","A6":"04.11.2026","B6":"Kraków","C6":"kawa","D6":"2","E6":"48","A7":"04.11.2026","B7":"Poznań","C7":"kakao","D7":"3","E7":"54","A8":"05.11.2026","B8":"Gdańsk","C8":"kawa","D8":"6","E8":"144","A9":"05.11.2026","B9":"Wrocław","C9":"herbata","D9":"1","E9":"15","A10":"06.11.2026","B10":"Kraków","C10":"kakao","D10":"8","E10":"144","A11":"06.11.2026","B11":"Gdańsk","C11":"kakao","D11":"2","E11":"36","A12":"09.11.2026","B12":"Poznań","C12":"kawa","D12":"5","E12":"120","A13":"09.11.2026","B13":"Kraków","C13":"kawa","D13":"3","E13":"72","A14":"10.11.2026","B14":"Wrocław","C14":"kakao","D14":"4","E14":"72","A15":"10.11.2026","B15":"Gdańsk","C15":"herbata","D15":"9","E15":"135"},"filter":{"range":"A1:E15","columns":{"B":{"values":["Kraków"]},"E":{"conditions":[{"op":"ge","value":"70"}]}}},"formats":{"A1":{"bold":true,"fill":"#e0e7ff"},"B1":{"bold":true,"fill":"#e0e7ff"},"C1":{"bold":true,"fill":"#e0e7ff"},"D1":{"bold":true,"fill":"#e0e7ff"},"E1":{"bold":true,"fill":"#e0e7ff"}},"cols":{"A":100}}]}

Ładowanie interaktywnego edytora... Jeśli się nie pojawi, włącz JavaScript.

Wszystkie lekcje kursu Arkusz kalkulacyjny w liceum i technikum·Zaloguj się, aby zapisać postęp na koncie.