+ Reply to Thread
Results 1 to 3 of 3

How can I change repeating date to one in excel?

  1. #1
    Registered User
    Join Date
    10-07-2015
    Location
    Tehran - Iran
    MS-Off Ver
    2013
    Posts
    91

    How can I change repeating date to one in excel?

    I have below question:
    On column A1: A16, I have some repeated dates.
    On column B1:B16, I have the numbers which are assigned each one only to a date on column A. For instance, B1 to A1, B2 to A2 and etc.
    I copy column A to column C and use from Data Remove Duplicates.
    Now, I want to have total sum of numbers which are assigned to each exact date on column D (front of column C).
    I have attached an example of excel sheet.
    How can I do?
    Untitled.png

  2. #2
    Valued Forum Contributor mangesh.mehendale's Avatar
    Join Date
    06-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    510

    Re: How can I change repeating date to one in excel?

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    If this works for you then mark this thread as Solve.. See at top right "Thread Tools"...

    "Add Reputation" to answer if anyone helps you in this forum...
    Last edited by mangesh.mehendale; 10-10-2015 at 02:56 AM.
    Don`t care, take care...

    Regards,
    Mangesh

  3. #3
    Registered User
    Join Date
    10-07-2015
    Location
    Tehran - Iran
    MS-Off Ver
    2013
    Posts
    91

    Re: How can I change repeating date to one in excel?

    Thank you very much for your answer. It's work.

+ 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] Repeating Worksheet Change Event on Different Ranges
    By Tanooki in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-22-2014, 09:43 PM
  2. Replies: 4
    Last Post: 06-16-2014, 11:33 PM
  3. [SOLVED] Dynamic repeating order that needs to change based on specific criteria
    By rcoope02 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-14-2013, 11:30 AM
  4. need repeating procedure to change row height
    By Dave32 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-03-2008, 08:27 AM
  5. [SOLVED] Make date change in excel to current date when opening daily?
    By jamie in forum Excel General
    Replies: 3
    Last Post: 03-01-2006, 11:40 AM
  6. Replies: 3
    Last Post: 02-09-2006, 10:30 AM
  7. [SOLVED] How do I generate random, non-repeating numbers that don't change?
    By bsquared0 in forum Excel General
    Replies: 1
    Last Post: 07-30-2005, 12:05 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