# Counting Unique Rows (FREQUENCY)

• I'm attempting to write a formula that will count COLUMN B if it's >0% and COLUMN A is unique photo ex. below
[ATTACH=CONFIG]70155[/ATTACH]

## Images

• Re: Counting Unique Rows (FREQUENCY)

I think it would be helpful if you included a sample workbook with data in place and the desired results entered manually.

[sw]*[/sw]

Bruce :cool:

• Re: Counting Unique Rows (FREQUENCY)

The photo was pretty much it skywriter, the graphs etc. make the workbook itself far to large for an attachment here, so I'll include a sample with correct formatting Column A - General and Column B - Percentage (0 decimal spaces) not much more to it, just trying to figure out how to count the percentages over 0% ignore blanks and only count PINs that repeat once.

## Files

• Book3.xlsx

(9.54 kB, downloaded 44 times, last: )
• Re: Counting Unique Rows (FREQUENCY)

Can you put in the results so we know what you are after and where you want them.

Quote

the desired results entered manually.

Bruce :cool:

• Re: Counting Unique Rows (FREQUENCY)

As per your sample workbook, try this Array Formula which requires confirmation with Ctrl+Shift+Enter instead of Enter alone.

Code
1. =SUM(IF(FREQUENCY(IF(Table1[Score]<>"",IF(Table1[Score]>0,Table1[PIN])),Table1[PIN])>0,1))

Regards.
sktneer

• Re: Counting Unique Rows (FREQUENCY)

Absolutely perfect sktneer! Appreciate the help!