+ Reply to Thread
Results 1 to 2 of 2

Find right next passed value and sum a number depending on date

Hybrid View

  1. #1
    Registered User
    Join Date
    05-22-2014
    Posts
    6

    Find right next passed value and sum a number depending on date

    Hi,

    I have one worksheet. I am needing to match up column G with value on $E$3 and give consecutive numbers on column F depending if the matched column G with value on $E$3 is on same date of column L; I have plenty blankcells and other values on column G.
    I trying catch up with excel..
    Thanks 4 your helpalues on column G

    I have excel 2007
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Find right next passed value and sum a number depending on date

    The example you have posted is confusing.

    Do you want to count them if EITHER Telcel or Multi is present, or just MULTI (which is the value in E3)? Does the numbering restart at 1 on each date?

    Can you report, showing your DESIRED answer in column G (just type in the expected values for a few example cells so that we can tell EXACTLY what ypu want).
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

+ 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] Find the Max Date in a list depending on a Cell Value
    By turist in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-29-2013, 12:20 PM
  2. [SOLVED] To find Number of weeks passed
    By ashishmac in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-08-2012, 01:40 AM
  3. [SOLVED] Return a number depending on the date in another cell
    By luke.guthrie in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 06-12-2012, 12:34 PM
  4. Replies: 1
    Last Post: 11-29-2010, 12:10 PM
  5. Lookup date in range depending on a number
    By Ducatisto in forum Excel General
    Replies: 2
    Last Post: 05-05-2009, 07:21 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