I need to create a summary table listing only unique entries from a source table. The key is split across two columns (Unit, Lesson). I've found an example online to do that much. The difficulty is that I also need to omit entries where 'Lesson' = 0, and I don't have a good enough grasp of array formulas to adapt the solution.
The formula I'm using is:
{=INDEX(Source[Unit],IFERROR(MATCH(TRUE(),ISNA(MATCH(Source[Unit]&Source[Lesson],Summary[[#Headers],[Unit]]:OFFSET([@Unit],-1,0)&Summary[[#Headers],[Lesson]]:OFFSET([@Lesson],-1,0),0)),0),1))}
Right now, it's returning:
What I need is:
I'm attaching a minimal working example. Any help you can offer on adding the additional criterion or making the whole thing more efficient would be greatly appreciated.
Bookmarks