?
Solved

Frequency if adjacent cell not blank

Posted on 2011-09-13
2
Medium Priority
?
175 Views
Last Modified: 2012-05-12
I need to get the number of unique "thk" values if the "count" value is not blank.  In the example below I am expecting a return value of 3.  How can I do this?

thk      count
0.118      1
0.118      2
0.118      
0.394      2
0.394      
0.236      
0.5      
0.25      2
 frequency.xls
0
Comment
Question by:munch007
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 50

Expert Comment

by:barry houdini
ID: 36530102
One way is to use this formula

=SUM(IF(FREQUENCY(IF(B2:B10<>"",IF(A2:A10<>"",MATCH(A2:A10,A2:A10,0))),ROW(A2:A10)-ROW(A2)+1),1))

confirmed with CTRL+SHIFT+ENTER

see attached

regards, barry
0
 
LVL 50

Accepted Solution

by:
barry houdini earned 2000 total points
ID: 36530113
sorry, attachement not attached - here it is

barry
frequency-barry.xls
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question