Forum Discussion
UNIQUE table
Hi,
Might be beginner question but i have a list of names from where i extract unique information with =UNIQUE command to a different sheet. But the problem is when i change the original lists sorting or filtering it changes the unique operators list order also which messes up with my sheet2.
Question is how do i lock the rows together or fix the whole operation.
Thanks in advance and sorry for dumb question.
Thanks for the quick and fulfilling answer!
I thought about this way also but then i need to be updating the unique list manually by ctrl + C every time something is added. This way will do but much preferably do the automation for the job.
I have scratced my head for entire day trying to find automated way to do this.
-Leevi
Take this:
- Copy and Paste as Values:
- After generating your unique list with the UNIQUE function, you can copy the resulting list and then paste it as values on another sheet. This will "freeze" the list, so it won't change if the original list is modified.
- Steps:
- Select the unique list.
- Copy it (Ctrl+C or Command+C).
- Go to another sheet or the same sheet in another location.
- Right-click and choose "Paste Special" and then select "Values Only" (or "Values").
- Sort the Unique List Independently:
- You can apply a sort function directly to the unique list, so it maintains its order independently of the original list.
- Example: =SORT(UNIQUE(A2:A10))
- This formula first extracts unique values and then sorts them. This way, even if the original list changes, the unique list stays sorted.
- Copy and Paste as Values:
