Excel Formula Issue

I have a list of data, which looks like this, it can’t be sorted in any other way.

Data View
I need a formula to give me the answer in column F, revised date
To get the answer, when a invoice has multiple items, I need to look for the latest finish date and give that date to all of the items
 
The job number can recur later on but would have a different invoice.
 
If it possible to do this with a formula?
Gareth_PointonAsked:
Who is Participating?
 
SteveCommented:
Enter the folloing in F2
=MAX(IF($B$2:$B$999=B2,$E$2:$E$999))
then enter using [ctrl]+[shift]+[enter]
copy down and it should be ok.
U--Example.xlsx
0
 
Gareth_PointonAuthor Commented:
Fantastic. Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.