Results 1 to 11 of 11

How to enter a value for the first row based on the earliest date

Threaded View

  1. #1
    Registered User
    Join Date
    11-06-2015
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    57

    How to enter a value for the first row based on the earliest date

    How to enter a value for the first row based on the earliest date?

    Here is how the file is structured:
    Column A has multiple duplicate entries because this file shows all the orders we have and some companies order multiple times while some order just once.
    We want to label their first order (based on Column C's Job Accepted) in Column E as "First".
    first value.png


    Here is the end result of I'm looking to achieve
    first value 2.png


    The goal behind this:
    We want to calculate how much a client is worth based on their first order.
    Example, for all clients who first ordered Stickers how much are they worth vs clients who ordered Flags first.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Moving to the date in a row based on earliest date in a column.
    By BDBJ1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-19-2016, 11:34 AM
  2. [SOLVED] Count Unique Values Based on Earliest Date Criteria
    By Aquamore in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-04-2014, 09:12 PM
  3. [SOLVED] Extracting two letters-code based on earliest date
    By Niclal in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-11-2014, 02:38 PM
  4. [SOLVED] Index match multiple criteria based on earliest date
    By dchubbock in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-28-2013, 07:18 PM
  5. LookUp based earliest date (2007)
    By D_N_L in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-15-2012, 08:19 AM
  6. Find earliest date based on certain criteria
    By SeanKosmann in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 01-26-2010, 11:32 AM
  7. Find Earliest Date based on conditions
    By ShredDude in forum Excel General
    Replies: 6
    Last Post: 07-14-2007, 01:56 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