My data set has three fields: Name, Discount Rate & Week.
I want the name to populate below the week in which following conditions are met.
IF [Discount Rate]>3200 THEN [Name}
The issue is that I don't want the names to repeat in subsequent weeks if the condition has already been met.
In other words, if John Doe had a discount rate of 3300 in Week 1, and 3600 in Week 2, I only want his name to populate below Week 1.
The end result should look something like this. It seems like some sort of lookup function needs to involved.