In regards to the video "The Excel Feature Everyone Loves...But Shouldn't Use (Alternative)". I'm having an issue properly applying the conditional formatting. I have the data in A2:A118 and there is 5 groups I'm trying to get it to work on. The formula I'm using =A2=A1. When the formatting applies, it applies (hides) so that the last line of the group is visible instead of the first. ex. A2:A10 is hidden and A11 is visible. I'm using Excel 2021 LTSC. Would anyone be able to help me figure out why the last is visible and not the first for each group? is the some a formatting with the table, sheet, or workbook that is interfering? I tried attaching an example file, but I get the error message the the file type is not correct. What file types am I able to attach?