+ Reply to Thread
Results 1 to 10 of 10

Need formula to solve first occurance

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    06-26-2013
    Location
    Makati
    MS-Off Ver
    Excel 2010
    Posts
    138

    Re: Need formula to solve first occurance

    Hi jnj,

    I dont really understand what you want to achieve but try see attached file, if its doesnt solve your problem try to put your expected result and post it to the forum so it will be easier to understand.

    Book2.xlsx

  2. #2
    Registered User
    Join Date
    08-09-2013
    Location
    dallas, tx
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Need formula to solve first occurance

    Guys - appreciate your help but that's not the right formulas I am looking for. And sorry to confuse you. See attached spreadsheet and that might help you understand what I am try to achieve better.

    Thanks!
    Last edited by jnj; 08-09-2013 at 09:45 AM.

  3. #3
    Valued Forum Contributor
    Join Date
    05-20-2013
    Location
    Ohio, USA
    MS-Off Ver
    Excel 2013
    Posts
    941

    Re: Need formula to solve first occurance

    IMO you'll have to elaborate on your needs. To state you need as the sum of first occurence (i.e. singular, not plural as in more than one instance) is essentially a mathematical oxymoron. In mathematics terminology, the sum of first occurance is always the value of first occurence.

+ 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] Formula to count the occurance of values seperated by a comma
    By bouncingbudha in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-02-2013, 10:23 PM
  2. [SOLVED] Formula to find the latest date of a specified occurance
    By happyhorse in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-16-2013, 12:37 PM
  3. Need Formula which sums up value for each occurance.
    By Karthik Sen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-25-2012, 08:12 AM
  4. Finding last occurance as Non-array formula?
    By ratboy505 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-12-2007, 05:45 PM
  5. Need Formula for Last Occurance
    By Reignman in forum Excel Formulas & Functions
    Replies: 26
    Last Post: 09-06-2005, 03:05 PM

Tags for this Thread

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