Skip to main content
Web Applications

Return to Question

Tweeted twitter.com/StackWebApps/status/1280607522429140992
deleted 5 characters in body; edited tags
Source Link
user0
user0
  • 27.1k
  • 10
  • 53
  • 78

Google Sheets has a UNIQUE(...) function which when given a column of values, will output a column of all unique values.

This works well for column-specific data, however, you have multiple columns and rows of data that needs to be summarized, this won't work. This is because if you include a 2-dimensional range into UNIQUE(...) the end results are two dimensional, with only each column being summarized.

Is there a function or way to summarize all values across an entire 2 dimensional-dimensional range?

REASONING:

I have a large list of businesses. Each column is a type of business, and each row contains values of business names. I need to create an end-list of all businesses that are provided throughout the entire source sheet. I don't need unique values per column. I need unique values across the entire document.

Google Sheets has a UNIQUE(...) function which when given a column of values, will output a column of all unique values.

This works well for column-specific data, however, you have multiple columns and rows of data that needs to be summarized, this won't work. This is because if you include a 2-dimensional range into UNIQUE(...) the end results are two dimensional, with only each column being summarized.

Is there a function or way to summarize all values across an entire 2 dimensional range?

REASONING

I have a large list of businesses. Each column is a type of business, and each row contains values of business names. I need to create an end-list of all businesses that are provided throughout the entire source sheet. I don't need unique values per column. I need unique values across the entire document.

Google Sheets has a UNIQUE() function which when given a column of values, will output a column of all unique values.

This works well for column-specific data, however, you have multiple columns and rows of data that needs to be summarized, this won't work. This is because if you include a 2-dimensional range into UNIQUE() the end results are two dimensional, with only each column being summarized.

Is there a function or way to summarize all values across an entire 2-dimensional range?

REASONING:

I have a large list of businesses. Each column is a type of business, and each row contains values of business names. I need to create an end-list of all businesses that are provided throughout the entire source sheet. I don't need unique values per column. I need unique values across the entire document.

Source Link
RLH
RLH
  • 307
  • 1
  • 2
  • 10

How can I create a unique list of data across multiple rows AND columns?

Google Sheets has a UNIQUE(...) function which when given a column of values, will output a column of all unique values.

This works well for column-specific data, however, you have multiple columns and rows of data that needs to be summarized, this won't work. This is because if you include a 2-dimensional range into UNIQUE(...) the end results are two dimensional, with only each column being summarized.

Is there a function or way to summarize all values across an entire 2 dimensional range?

REASONING

I have a large list of businesses. Each column is a type of business, and each row contains values of business names. I need to create an end-list of all businesses that are provided throughout the entire source sheet. I don't need unique values per column. I need unique values across the entire document.