Count Number of days from the most recent item

Hi - can you help.
I have spreadsheet of data
Date, Accident Type, Section

In the accident type it will be either RIDDOR, Major or Minor, the section will be A,B,C or D
The date will have a date in that box when it occured.

What I want to do it count the number of days from the last RIDDOR date for each section - can you help

I have attached example data set

What are the actual expected results for this sample set, and why?

Hi,

Try this array (CTRL, SHIFT and ENTER)

=DATEDIF(MAX(IF(($C$2:$C$25=G3)*($B$2:$B$25="RIDDOR"),$A$2:$A$25,"")),TODAY(),"d")

in H3 and copied down.

To return just the most recent date,

=MAX(IF(($C$2:$C$25=G3)*($B$2:$B$25="RIDDOR"),$A$2:$A$25,""))

also an array

Hi

If i understoond well your target, then in H3, put the formula and drag down..

=SUMPRODUCT(($C$2:$C$25=G3)*($B$2:$B$25="RIDDOR"))

Hope to helps you.

Expected results - so for each section we will know how many days we have operated in each section without a RIDDOR
e.g. for A we might have 30 days; B might have 320 days

Are any of the suggestions given above working for you?

If no, can you elaborate on why A is 30 and B is 320?

Originally Posted by sweep

Hi,

Try this array (CTRL, SHIFT and ENTER)

=DATEDIF(MAX(IF(($C$2:$C$25=G3)*($B$2:$B$25="RIDDOR"),$A$2:$A$25,"")),TODAY(),"d")

in H3 and copied down.

To return just the most recent date,

=MAX(IF(($C$2:$C$25=G3)*($B$2:$B$25="RIDDOR"),$A$2:$A$25,""))

also an array

Excellent - Solved