+ Reply to Thread
Results 1 to 5 of 5

How i get the first value of a column with data depending on the date in a merged cell

  1. #1
    Forum Contributor
    Join Date
    08-24-2012
    Location
    Portugal
    MS-Off Ver
    Excel 2003
    Posts
    119

    How i get the first value of a column with data depending on the date in a merged cell

    Hi guys.

    Need some help with the sample file that i attached. How do i get the first value in G column depending on the date to look for. For example in A1 i have the today´s date and in this case i need do look for the date in F column and the first value in G10:G15 interval, that is associated with F10 (merged cell). In this case the result should be 5.

    Is this possible with a formula?
    Thanks in advance

    Sample 1.xls

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,440

    Re: How i get the first value of a column with data depending on the date in a merged cell

    Long winded I know, but,

    Please Login or Register  to view this content.
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  3. #3
    Forum Contributor
    Join Date
    08-24-2012
    Location
    Portugal
    MS-Off Ver
    Excel 2003
    Posts
    119

    Re: How i get the first value of a column with data depending on the date in a merged cell

    Hi sweep and thanks for tour time.
    Wow thats really really long but......its working :-).
    Thank you so much.

  4. #4
    Forum Contributor
    Join Date
    08-24-2012
    Location
    Portugal
    MS-Off Ver
    Excel 2003
    Posts
    119

    Re: How i get the first value of a column with data depending on the date in a merged cell

    So now i have a problem. Its working great but the data is in another file and when i change the formula you give me with the links for the other file i just have the result when i open that file.

    Is there a way to correct this?

    Thanks once again

  5. #5
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,440

    Re: How i get the first value of a column with data depending on the date in a merged cell

    Unfortunately, you'll need the referenced file open.

+ 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. Limit merged cell data; Place excess into next merged cell down
    By coreytroy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-06-2013, 10:35 PM
  2. Replies: 3
    Last Post: 04-29-2012, 03:16 AM
  3. Replies: 1
    Last Post: 04-18-2011, 06:38 PM
  4. Sum of a column depending on data in another cell
    By Atrox321 in forum Excel General
    Replies: 2
    Last Post: 01-07-2009, 05:35 PM
  5. [SOLVED] Cell data depending on column selected.
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-01-2006, 06:00 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