Excel Formula

[ushaanu]

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]

Hi,
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.

 

[ushaanu]

Thank you. sample file enclosed where in total case sheet and Req results sheet .

Hi,
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:

 

[GraH - Guido]

Hi,

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)

 

[ushaanu]

thank You so much it`s working

 

[Luke M]

@ushaanu

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