I’m looking for a way to AutoFill cells based upon previous filled cells.

I’m working in a Excel file where I can’t edit a lot and let’s not even discuss the option for Macros. I can create conditional formatting.

I need to fill rows where one column is sort of unique.
All cells following that specific cel contain the same data. I want to create something that if I type the semi-unique value in a cel the rest AutoFills.

Like this:
| semi-unique 1 | celvalue 2 | celvalue 3 |
| semi-unique 2 | celvalue 342 | celvalue 342 |
| semi-unique 1 | celvalue 2 | celvalue 3 |

Hope this makes sense….