+ Reply to Thread
Results 1 to 4 of 4

Looking for a date for a given 3 conditions in vertical columns

  1. #1
    Forum Contributor
    Join Date
    02-25-2012
    Location
    Coimbatore, India
    MS-Off Ver
    Excel 2010
    Posts
    445

    Looking for a date for a given 3 conditions in vertical columns

    Hello Friends

    Please find the attached 2010 Version Excel file <Looking for a date for a given 3 conditions in vertical columns 250515 sss.xlsx>.

    I want to plot the date as result for the given 3 conditions / inputs in vertical column.

    thanks in advance

    thilag

  2. #2
    Forum Expert
    Join Date
    07-20-2011
    Location
    mysore
    MS-Off Ver
    Excel 2007
    Posts
    4,982

    Re: Looking for a date for a given 3 conditions in vertical columns

    ARRAY formula in I6,then drag down
    Please Login or Register  to view this content.
    ARRAY formula is used

    To enter ARRAY formula
    Paste the formula
    Press F2
    Press Ctrl+Shift+Enter keys together.

  3. #3
    Forum Contributor
    Join Date
    02-25-2012
    Location
    Coimbatore, India
    MS-Off Ver
    Excel 2010
    Posts
    445

    Re: Looking for a date for a given 3 conditions in vertical columns

    Dear friend

    Your Formulas working fine.

    thanks

    thilag

  4. #4
    Forum Expert
    Join Date
    07-20-2011
    Location
    mysore
    MS-Off Ver
    Excel 2007
    Posts
    4,982

    Re: Looking for a date for a given 3 conditions in vertical columns

    Hi,
    welcome
    KVS

+ 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] Lookup with THREE conditions: one vertical, two horizontal
    By splendidus in forum Excel General
    Replies: 7
    Last Post: 08-05-2014, 01:11 PM
  2. Replies: 1
    Last Post: 03-12-2014, 08:45 AM
  3. [SOLVED] Using Index & Match to search 2 vertical columns and return data to a vertical set
    By QuietLife in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-08-2013, 09:59 AM
  4. Vertical to Horizontal Data Special Conditions
    By guypier in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-05-2011, 03:30 PM
  5. Replies: 2
    Last Post: 04-06-2011, 10:08 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