• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Aging + Formula Figure

W

wannabe_guru2

New Member
I have an aging report where I need to determine the unique count value in the "oldest" bucket.


Column Header:


1-30

31-60

61-90

91-120

121+


A customer row might have a value in the "1-30" bucket, "61-90" bucket, and then "121+" bucket ...


When I get a total count for the unique values in the specific buckets, I only want to see where that customer is accounted for in the "121+" bucket and not the other buckets ... does that make sense?
 
Would one of the other threads about getting unique counts w/ criteria be helpful?

http://chandoo.org/forums/topic/counting-unique-values-if-other-criteria-are-true

http://chandoo.org/forums/topic/formula-to-count-unique-values-with-criteria


It sounds like you need a unique count of 1 column (customer names?) based on if another column (120+) meets criteria.


Also, note that this forum is 100% volunteer. If you don't get a response right away, we might be busy doing other things, working on the problem currently, or sleeping. Be patient, and we'll usually have some response within 24 hrs at the latest (but usually much sooner. depends on complexity of question)
 
Perhaps if you pasted a sample of what your data looks like, we could be more helpful. So far, I just have a vague idea that you have columns B:F which may or may not have data (can more than 1 have data?) in them. If there's data, return column header (why?). Once you have all the headers, we want to...?
 
You must log in or register to reply here.
Back
Top