How do I get rid of the blank line when I use UNIQUE in Google Sheets?

Ask Question

Asked 4 years, 5 months ago

Modified 4 years, 5 months ago

Viewed 161 times

I used unique... the result is in column B, but I want results to look like column C. So what do I need to do to achieve this?

user0

26k8 gold badges49 silver badges77 bronze badges

asked Apr 10, 2019 at 7:23

YYY Trade

251 silver badge3 bronze badges

Add a comment |

1 Answer 1

Sorted by:

=UNIQUE(FILTER(A2:A, A2:A<>""))

answered Apr 10, 2019 at 10:54

user0

26k8 gold badges49 silver badges77 bronze badges

Add a comment |

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.