I am trying to auto-generate the table shown in the attached Column E so that it dynamically updates if the data in Columns A, B, and C change. The goal is to skip duplicate values in Column B without having any blank rows generated in Column E. This is just a simple example but I would apply this formula to more complex worksheets if anyone has an answer. Thanks!
Bookmarks