• 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.

Distinct Count With latest Record

NARAYANK991

Excel Ninja
Hi ,

Try these formulas :

=COUNT(1/FREQUENCY(IF(Status = "Received", MATCH(Company, Company,0)), ROW(Company) - MIN(ROW(Company)) + 1))

Change the text Received to Sent and Resent to get the distinct counts for those statuses.

This formula is an array formula , to be entered using CTRL SHIFT ENTER.

Narayan
 

NARAYANK991

Excel Ninja
Hi ,

Company and Status are named ranges , referring to addresses where you have your data.

If you can upload a sample worksheet instead of a picture , it will make it easy for you to see that the formula works.

Narayan
 
Top