R
R
rekonstrukcijavolos2019-04-18 19:03:01
Google Sheets
rekonstrukcijavolos, 2019-04-18 19:03:01

How to leave unique values ​​​​and remove duplicates in Google Spreadsheet?

There is data in the format 1 2 3 4 5 1 2.
How to remove duplicate values ​​and leave only those for which there were no duplicates (3 4 5)?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
D
dollar, 2019-04-19
@dollar

https://gdriveru.blogspot.com/2014/11/duplicateval...

R
Roman, 2019-04-19
@JohnnyBravo7

There is a great unique formula . But it does not remove the values, but displays only the unique ones from the range.
To remove, you can use a special addon
https://chrome.google.com/webstore/detail/remove-d...

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question