Forum Discussion
Solved
Question on Extract Group Values
Hi all, I have a sample dataset that has 3 columns, ID, Food-A and Food-B. I would like to create a new column called Last Meal (Yellow color). I would like to exact the group of value by Sample ...
ryan_mayu Another I want to clarify with you.
The output of the Filter (to create the virtual table, I mean this FILTER(Sheet1, Sheet1[Sample]=EARLIER(Sheet1[Sample] && Sheet1[Food-A]=""), let's take A1 as example. Originally, it has 3 records, when applied the fillter function on whether Food-A column is NA, is the A1 record remain as 3 (beef, lamb and NA) or 2 (beef and lamb).