+ Reply to Thread
Results 1 to 3 of 3

To get desired result based on the conditions

  1. #1
    Registered User
    Join Date
    04-19-2016
    Location
    Bangalore, India
    MS-Off Ver
    Office 2016
    Posts
    2

    Thumbs up To get desired result based on the conditions

    Hi,
    I am new member, saw the views most of the people who got stuck in getting their results solved in simple steps thanks for the team

    I need your help to put the formulas to the get the desired results based on conditions, I have more than 10000 lines items attach the sample for your reference

    Condition1
    To check for 2012/13 records based on ACTUAL_START_DATE & pull the related rows data, if he has more than one line for the period 2012/13 we need to check Fiscal Year (6th April 2012 to 5th April 2013) for which period he will fall & pull that records
    Condition2
    To check the latest records based on ACTUAL_START_DATE & pull the related rows data keeping

    Please guide
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    Re: To get desired result based on the conditions

    It would help if you added some sample output to your file.

  3. #3
    Registered User
    Join Date
    04-19-2016
    Location
    Bangalore, India
    MS-Off Ver
    Office 2016
    Posts
    2

    Re: To get desired result based on the conditions

    Hi,
    Much appreciated for your quick response

    I have attached the excel below with results down
    Attached Files Attached Files

+ 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. Look at text file, and produce a new result set based desired format in the excel
    By masond3 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-11-2013, 01:10 PM
  2. Conditional formatting - more than 3 conditions - result based on another cell
    By Mostlygood in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-07-2013, 10:07 AM
  3. how to calculate result based on 4 conditions ?
    By ASP__DEVELOPER in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-20-2013, 12:19 PM
  4. [SOLVED] Need help on VLookup to find result based on desired number
    By tuongtu3 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-16-2013, 08:54 PM
  5. Return desired result based on a condition (to show 0% instead of #div/0)
    By devilchild99 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-17-2012, 03:22 PM
  6. Return desired result based on a condition
    By devilchild99 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-17-2012, 01:00 PM
  7. Get a result based on several different conditions
    By QUIZZLE in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-20-2009, 11:35 AM

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