• 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


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

Excel Formula


HI All,
I hope you all are doing good .
Actually I have some data in two excel file where one number is unique number with different case ids and date , now I need data like one unique number having one case id so and so date after that date how many cases are logged against same unique number .

GraH - Guido

Well-Known Member
This is do-able with a simple Power Query to combine the data, then feed this table to a pivot.
Many tutorials can be found on the web.

Tip from the forum rules:
For the best/fastest results, Upload a Sample File using the "Upload a File" button at the bottom of the page.

GraH - Guido

Well-Known Member

I was expecting something else based on my initial understanding of the thread.

Seeing your sample data, you seem to need a COUNTIFS, something like:
[D2]=COUNTIFS('Total Cases file'!A:A,">"&A2,'Total Cases file'!C:C,C2)

Luke M

Excel Ninja

In the future, please try to be more descriptive in your thread titles. "Excel formula" can refer to almost an infinite number of things.