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?
Who is Participating?
Enter the folloing in F2
then enter using [ctrl]+[shift]+[enter]
copy down and it should be ok.
Gareth_PointonAuthor Commented:
Fantastic. Thanks
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.