# Formula for counting number of unique values in multiple non-adjacent columns with blanks

1. ## Formula for counting number of unique values in multiple non-adjacent columns with blanks

Hello,
I'm looking to count the number of unique values in multiple non-adjacent columns. These columns do have blanks. E.g.
Column A:
1
2
3
4
5
6
7
Column E:
2
Blank
4
5
6
7
8
9
Blank
10

So I would want to get a result of 10 total unique values within the two combined columns.

Thank you

2. ## Re: Formula for counting number of unique values in multiple non-adjacent columns with bla

assuming that your data ranges are A1:A10 and E1:E10, try in F1 as an ARRAY-entered formula:

``Please Login or Register  to view this content.``
this solution will only work if you have numerical entries in your ranges.

the {1,0} trick is courtesy daddylonglegs.

UPDATE

another, simpler, more extensible solution (again, ARRAY-entered):

``Please Login or Register  to view this content.``
in case you have other columns, such as C1:C10, the above formula can be extended thus:

``Please Login or Register  to view this content.``
in case your data were along rows (instead of columns), the formula would be (observe the use of ";" instead of ","):

``Please Login or Register  to view this content.``

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1