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]
Counting Unique Rows (FREQUENCY)



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]

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.

Re: Counting Unique Rows (FREQUENCY)
Can you put in the results so we know what you are after and where you want them.
Quotethe desired results entered manually.



Re: Counting Unique Rows (FREQUENCY)
Absolutely perfect sktneer! Appreciate the help!

Re: Counting Unique Rows (FREQUENCY)
You're welcome. Glad to help.
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!