Counting Unique Rows (FREQUENCY)

AFord66 · Sep 9th 2016

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]

skywriter · Sep 9th 2016

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]

AFord66 · Sep 9th 2016

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.

Thanks!forum.ozgrid.com/index.php?attachment/70157/

skywriter · Sep 9th 2016

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.

sktneer · Sep 10th 2016

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

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

AFord66 · Sep 12th 2016

Re: Counting Unique Rows (FREQUENCY)

Absolutely perfect sktneer! Appreciate the help!

sktneer · Sep 13th 2016

Re: Counting Unique Rows (FREQUENCY)

You're welcome. Glad to help.

Counting Unique Rows (FREQUENCY)

Participate now!

Share