Hi,
I have some data, column A is text terms, and column F is 52 week ending dates. Is there a way to show only the unique values in column G? For example, if G1 is 1/8/24, G2 and below would only show the column A terms that are in 1/8/24 week ending but not in 1/1/24 week ending (i.e. new terms)?
Thanks!
I have some data, column A is text terms, and column F is 52 week ending dates. Is there a way to show only the unique values in column G? For example, if G1 is 1/8/24, G2 and below would only show the column A terms that are in 1/8/24 week ending but not in 1/1/24 week ending (i.e. new terms)?
Thanks!