VBA - Counting unique values based on mutiple columns

**Bezzie** · 05-08-2016, 11:09 AM

I got data similar to the following table (actual data will be the four date columns but further apart and many more rows):

Capture.PNG

Using VBA I want to count the unique values in col A where the date is equal to 16-Jan-16 in any of the four date columns (B, D, F and H).

In the above example my answer should be 2 (MTN and DRD). MTN has 16-Jan-16 in two columns but must be counted only once.

Is this possible without using multiple CountIf or CountIfs?

Your help is appreciated.

Edit: Forgot to add that some of the cells in the date columns might not have dates in them (empty cells/null value cells).

**kalbasiatka** · 05-08-2016, 12:39 PM

Welcome! Show in the file what is and what should be in the end.

**Bezzie** · 05-08-2016, 03:34 PM

Data looks exactly like example given. There is just a bunch of columns between date columns with other information.

As I said I want to do a unique count of values in col A where date = 16-Jan-16 in any of the four date columns.

In the example 16-Jan-16 occurs 3 times but two of those times is where the same value is in col A (MTN - B5 and H4) so that must be counted as one. The other one is DRD in D8 so that one counts as one. So the unique count of values in col A where date (in any of the four columns) = 16-Jan-16 is 2. 2 is the answer I'm looking for in the example above.

One problem is that some of the cells in the date columns might not have dates in them at the time of counting but they might have dates in them at a later stage when the count is done again.

I don't know how to better explain the problem.

**kalbasiatka** · 05-09-2016, 03:09 AM

Originally Posted by Bezzie

I don't know how to better explain the problem.

You don't have to invent anything, I already wrote that it is necessary.
A file with a table and on a separate sheet that should look like the result.
If the file contains personal information, delete it. I have no desire to make a file, but there is a desire to help with the code.

**Bezzie** · 05-09-2016, 12:38 PM

Attached is a file with data similar to what I have.

There is no output sheet of what the answer should look like.

All I want is to do the count of unique values in col C in VBA code where the date in any of the date columns = 18-Jan-16 and get an answer of 3.

The three unique shares is BB, FE, GE.