+ Reply to Thread
Results 1 to 4 of 4

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

  1. 05-25-2015, 10:32 PM #1
    thilag
    thilag is offline
    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
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-25-2015, 11:11 PM #2
    kvsrinivasamurthy
    kvsrinivasamurthy is offline
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,585

    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.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 05-26-2015, 09:45 AM #3
    thilag
    thilag is offline
    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
    Reply With QuoteRegister To Reply
  4. 05-26-2015, 11:31 AM #4
    kvsrinivasamurthy
    kvsrinivasamurthy is offline
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,585

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

    Hi,
    welcome
    KVS
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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. Conditional formatting: various conditions using two date columns incl when cell = blank
    By fhmurray in forum Excel Formulas & Functions
    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. Using SUMPRODUCT for horizontal and vertical conditions TWICE
    By jim_0068 in forum Excel General
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1