Formula to return data in two columns

[jolthof]

see attached example
There are 4 types of events.
I have 4 columns } EVENT TYPE | DATE OF EVENT | LOCATION OF EVENT | # OF DAYS SINCE LAST EVENT
I will continually add events to the list. I want a dashboard to show the number of days since each type of event and the location where the event occurred.

[alansidman]

Here is your formula for days. In G4 =DATEDIF(MAXIFS($B$2:$B$10,$A$2:$A$10,G3),TODAY(),"d") and copy over. Still working on the second half of your issue.

[Adtxc]

G4: =LOOKUP(2,1/($A$2:$A$10=G$3),$D$2:$D$10)
G5: =LOOKUP(2,1/($A$2:$A$10=G$3),$C$2:$C$10)

Select G4 & G5 and copy across

[kvsrinivasamurthy]

ARRY formulas are used.
In G4

=TODAY()-INDEX($B$2:$B$10,MATCH(2,1/($A$2:$A$10=G$3),1))

In G5

=INDEX($C$2:$C$10,MATCH(2,1/($A$2:$A$10=G$3),1))

Then copy across to last column.

To enter ARRAY formula
Copy and paste the formula in cell
Press F2
Press Ctrl+Shift+Enter together
Excel covers the formula with {}.

[jolthof]

THANK YOU ALL!!

It appears all of these formulas work. I appreciate all of your help.

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.