Excel Formula Issue

Posted on 2014-08-08
Last Modified: 2014-08-08
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?
Question by:Gareth_Pointon
    LVL 24

    Accepted Solution

    Enter the folloing in F2
    then enter using [ctrl]+[shift]+[enter]
    copy down and it should be ok.

    Author Closing Comment

    Fantastic. Thanks

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
    Over the years I have built up my own little library of code snippets that I refer to when programming or writing a script.  Many of these have come from the web or adaptations from snippets I find on the Web.  Periodically I add to them when I come…
    The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now