-2

i am facing this issue right now. i hope someone will help me out. i want to find the unique values from the range column A to column D.

Dilju Sunil
  • 1
  • 1
  • 1
    Your edits have made this question very vague, and you have not commented on whether the two earlier answers have been helpful on your issue. – kirkg13 Jul 09 '20 at 17:48

2 Answers2

2

You can concatenate the ranges by using curly brackets ({}) and then surround that with the UNIQUE() function.

=UNIQUE({A:A;B:B;C:C;D:D})

edit: changed comma separator to semi-comma. The comma adds arrays together as columns while semi-comma adds them into one column.

a-burge
  • 1,535
  • 1
  • 13
  • 25
  • hi @a-burge... i am facing one more situation now.. pls take a look.. hope u will help me. – Dilju Sunil Jun 27 '20 at 08:36
  • 1
    Please, vote on the best answer for your question. It is a way to say thank you for peole who had spent time trying to help you. Also, create a New tópic if you have a diffenlrent problem. Take care. – Andre Nevares Jul 05 '20 at 14:01
  • The note on using comma vs semicolon was helpful to me (when paired with the note on using curly braces). Thanks! – Dannid Nov 21 '22 at 19:07
  • @Dannid if you're interested in more documentation, please see this article by Ben: https://www.benlcollins.com/spreadsheets/arrays-in-google-sheets/ – a-burge Nov 22 '22 at 12:06
1

The best way for your database is:

=sort(UNIQUE({A2:A;B2:B;C2:C;D2:D}))

I just change what @a-burge has done. He has to take the credit for that!

  • He forgot to use ( when he typed here. Of course, he will edit it.
  • Also, I had used sort() function.
  • sort() function is used to set data in A-Z order. But also take some blank spaces out!

Long-life to Stack Overflow.

Andre Nevares
  • 711
  • 6
  • 21