Hello, i have 2 Columns containing guards's names. ( I tried to use "maxifs" function but it is working only for one column ) My Question is: I need formula to find "Last Date" of "John Fizz" in "Beach"?
Kitap1 (version 1).xlsb | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Date | Guard 1 | Guard 2 | Location | ||
2 | 1.02.2023 | Mike Rogers | Romeo Loi | Lobby | ||
3 | 2.02.2023 | John Fizz | Taric Ben | Beach | ||
4 | 3.02.2023 | Alan Dusk | Lora Ian | Hotel | ||
5 | 4.02.2023 | Clark Kent | John Fizz | Beach | ||
Sayfa1 |