Auto Populate Date?

[applecore821]

Hello,

I need help with auto-populating the date. I have attached an example spreadsheet where we input user id's and when we've last reviewed them. We mark them good or bad depending on reporting and I'd like to have the date with which they were last "good" populate in Column D and the date they were last "bad" populate in Column E. Is that possible?

Thanks,
Mark

[AliGW]

Try this:

=MAX(IF($A$2:$A$47=A2,IF($C$2:$C$47="GOOD",$B$2:$B$47)))

... confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.


Then the other:
=MAX(IF($A$2:$A$47=A2,IF($C$2:$C$47="BAD",$B$2:$B$47)))

[applecore821]

Hi Ali,

Thanks you so much!!!!

Is there a way to make this keep going and not just end at '47'?

Thanks, Mark

[JeteMc]

If you would like Ali's formulas to update as new data is added to columns A:B then convert the range into a table.
You could additionally modify the formulas to use structured references as in: =IFERROR(1/(1/MAX(IF([User ID]=[@[User ID]],IF([Decision]="GOOD",[Date Reviewed])))),"")
Let us know if you have any questions.