+ Reply to Thread
Results 1 to 3 of 3

Altering date on column D if entries on column A are identical

  1. #1
    Registered User
    Join Date
    01-30-2020
    Location
    Planet Earth
    MS-Off Ver
    2016
    Posts
    96

    Altering date on column D if entries on column A are identical

    Hello,

    I have the following Excel workbook (please see attached Example.xlsx), as it has commented the expected output.

    I calculate the dates on column D as dates of column B [R-1] - 1 (day).

    The problem arises when it reaches the last date within the same car model(as it gets its date from the below car model when it shouldn't).

    So I was thinking of applying the If condition or so on the last date within the same entry (same car model), like within the same region on column A
    Thus the last date on the last entry on the Ending Date column within the same car model should be the Initial Date from that same row + 1 (day).

    Or would this be easier to achieve with a for loop in VBA?

    Any advice/help would be appreciated!
    Thank you!

    Gordon
    Attached Files Attached Files
    Last edited by Gordon85; 08-06-2020 at 04:21 AM.

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: Altering date on column D if entries on column A are identical

    In condition of car model is sorted:

    =IF(A2=A3,B3-1,B2+1)
    Quang PT

  3. #3
    Registered User
    Join Date
    01-30-2020
    Location
    Planet Earth
    MS-Off Ver
    2016
    Posts
    96

    Re: Altering date on column D if entries on column A are identical

    Thank you!
    Rep+
    Solved

+ 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. Replies: 1
    Last Post: 10-19-2016, 07:52 PM
  2. [SOLVED] Matching identical entries
    By lukela85 in forum Excel General
    Replies: 7
    Last Post: 02-21-2013, 09:32 PM
  3. Organizing the differences between identical and new entries.
    By Cyberpawz in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 02-06-2012, 10:23 AM
  4. Replies: 3
    Last Post: 01-11-2012, 03:37 AM
  5. Replies: 9
    Last Post: 02-15-2011, 11:23 AM
  6. Charts and entries with identical fields
    By Doctor Klaproth in forum Excel General
    Replies: 1
    Last Post: 06-03-2010, 03:21 PM
  7. [SOLVED] How to lookup when range contains multiple identical entries?
    By Doug Laidlaw in forum Excel General
    Replies: 1
    Last Post: 01-19-2006, 08:20 AM

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