+ Reply to Thread
Results 1 to 2 of 2

Get result from giving condition

  1. #1
    Registered User
    Join Date
    03-03-2019
    Location
    Lisbon, Portugal
    MS-Off Ver
    2016
    Posts
    1

    Get result from giving condition

    Hello,

    I wonder if anyone as any suggestion for a formula or function to get a result.

    I have 3 date columns formated like dd-mm-yyyy hh:mm:ss with several rows.

    Date of entry; Date of work first stage; Date of work done.

    The result im looking is something like find if, when the work was done (third column), it existed any work on the first stage (second column) and older (first column). The result can be 0 and 1 so i can sum it up.

    any suggestions. I tried vlookup but was lost along the way due to the giving conditions.
    The idea is to find out if when certain work is done if it was done by skiping older works pending.

    thanks.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Get result from giving condition

    Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

    Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] IF(OR function keeps giving #VALUE! result
    By GHBrodbeck in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-27-2018, 08:42 PM
  2. [SOLVED] NextRow VBA giving strange result...
    By sintek in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-09-2017, 06:05 AM
  3. giving if condition for other workbook
    By ash3angel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-12-2016, 05:58 AM
  4. [SOLVED] Simple =Sum(B2:L2) result is not giving accurate result and =IMSUM(M2,O2) also.
    By SimonsGE in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-29-2013, 01:56 AM
  5. Formula giving different result on two different pcs
    By mdooley in forum Excel General
    Replies: 2
    Last Post: 05-28-2012, 07:05 PM
  6. Vlookup always giving n/a as result
    By ankit_85 in forum Excel General
    Replies: 4
    Last Post: 09-11-2010, 01:28 AM
  7. [SOLVED] Formula not giving me the right result
    By Steved in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-09-2006, 10:25 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1