+ Reply to Thread
Results 1 to 4 of 4

Identify first column with increased value

  1. #1
    Registered User
    Join Date
    10-22-2019
    Location
    Dallas, Texas
    MS-Off Ver
    Office 365
    Posts
    2

    Identify first column with increased value

    I have a customer revenue file that shows revenue by month and projected increases. I'm looking for a formula to identify what month the customer's revenue increases.

    So if Customer "Brown" has no revenue, but in October 2020, starts showing revenue, the formula will indicate that revenue started in October 2020.

    I want to use the first month column as the basis for determining when the amount increases.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: Identify first column with increased value

    Hi

    first attempt:

    In Q3 to be copied down:


    Please Login or Register  to view this content.

    Regards
    Last edited by canapone; 10-23-2019 at 01:26 AM.
    -----------------------------------------------------

    At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.

    Please, mark your thread [SOLVED] if you received your answer.

  3. #3
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: Identify first column with increased value

    Hi again,

    =
    Please Login or Register  to view this content.
    should do the trick too.

    Regards

  4. #4
    Registered User
    Join Date
    10-22-2019
    Location
    Dallas, Texas
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Identify first column with increased value

    Oh this is great. Thank so much!

+ 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] UNSOLVED - Identify highlighted cells in column, copy cell value to column B of active row
    By Armitage2k in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-16-2014, 04:42 AM
  2. Programming a simple macro that gives increased values down a column !
    By Meeraan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-12-2014, 07:45 AM
  3. column comparison, trying to identify identify identical columns.
    By Jowel in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-24-2014, 04:12 AM
  4. Replies: 3
    Last Post: 06-22-2014, 08:55 AM
  5. Replies: 2
    Last Post: 02-28-2014, 06:42 PM
  6. Replies: 4
    Last Post: 08-29-2013, 04:27 PM
  7. Replies: 4
    Last Post: 04-09-2011, 02:51 PM

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