I need to identify if the latest date of an item has the status "published". I want the outcome to be "Yes".
If the item is "not published" or blank, I want to ignore the date.
ITEM
HF00030
HF00030
HF00030
HF00030
HF00030
HF00030
HF00030
HF00030
DATE
31/07/2022 09:37
26/09/2018 17:24
24/03/2021 11:10
12/11/2021 10:29
31/07/2022 09:41
19/08/2020 10:00
10/12/2021 17:41
10/12/2021 17:41
STATUS
Published
Published
Published
Published
Not Published
OUTCOME
NO
NO
NO
NO
NO
NO
YES
NO
Bookmarks