How to Repair Dll Error Code In a Simple Way?: How to Fix

Friday, September 23, 2016

How to Fix - Count of unique values?

Count of unique values

Anwsers to the Problem Count of unique values

Download SmartPCFixer to Fix It (Free)

A
B
C
D
E
F

District

Class
Category
Vendor Style
AUGUST

ROW
Location

1
500
5000
1865
1
16392004
0

2
500
5000
1865
1
5BB1246B
6

3
500
5000
1865
1
5BB1242BP
0

4
500
5000
1864
1
5BB1244P
0

5
500
5000
1864
1
5BB1246A
0

6
500
5000
1864
2
5BB1246B
6

7
501
5001
1864
2
5BB1248
6

8
501
5001
1864
1
5D1974E
0

9
501
5001
1866
1
5D1974EW
0

10
501
5002
1866
1
5D1976C
0

11
501
5002
1866
3
5D1978EP
6

For the data set above, we need a count of distinct VENDOR STYLES (col E) that has a value of >0 in column F for each of the Districts #'s listed in col A.

thank you in advance for your help! jane

Assuming your data is in the range A2:F12.
You have the unique Districts listed starting in cell H2 on down.
Enter this array formula** in I2 and copy down as needed:
=SUM(IF(FREQUENCY(IF(A$2:A$12=H2,IF(F$2:F$12>0,MATCH(E$2:E$12,E$2:E$12,0))),ROW(E$2:E$12)-ROW(E$2)+1),1))
** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key then hit ENTER.
--
Biff
Microsoft Excel MVP

Open Action Center by clicking the Start button Picture of the Start button, clicking Control Panel, and then, under System and Security, clicking Review your computer's status.

Make sure your computer has at least the minimum amount of random access memory (RAM) required to run the program that is displaying the error. Look for the program requirements online or in the packaging information.

Recommended Method to Fix the Problem: Count of unique values:

How to Fix Count of unique values with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your computer. Open it, and it will perform a scan for your system. The errors will be shown in the list.