rootsrules
New Member
- Joined
- Feb 4, 2010
- Messages
- 19
Hello All!
I was wondering if there's a formula or way to copy certain cells from one sheet to another but only if they pass on a certain parameter and not copy the duplicates.
Like this: I have a list of registered people on column A. Column B says if they participated in the program in 2021.
I want to copy the list, but only only the ones that participated in the 2021 program and I don't want it to copy duplicated names.
Also, I'm using Google sheets...
Thanks in advance!
I was wondering if there's a formula or way to copy certain cells from one sheet to another but only if they pass on a certain parameter and not copy the duplicates.
Like this: I have a list of registered people on column A. Column B says if they participated in the program in 2021.
I want to copy the list, but only only the ones that participated in the 2021 program and I don't want it to copy duplicated names.
Also, I'm using Google sheets...
Thanks in advance!