Results 1 to 12 of 12

Difference in Readings(Column ), Considering similar IDs in Column A and different dates

Threaded View

  1. 10-17-2020, 07:25 AM #1
    Anko_lee
    Anko_lee is offline
    Registered User
    Join Date
    10-17-2020
    Location
    Nairobi,Kenya
    MS-Off Ver
    office 2010
    Posts
    8

    Question Difference in Readings(Column ), Considering similar IDs in Column A and different dates

    from Column A have Unique IDs but repeated with entries in Column B where we have dates and new readings in column C, I want in Coumn D to get difference in reading between current date and previous of similar ID, how should I do that and retain enteries in cells in Column D in every new entry?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Difference between filtered consecutive readings in a column.
    By skyping in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-19-2020, 11:12 AM
  2. [SOLVED] Find similar account number then calculate the difference in dates
    By snikrs11 in forum Excel General
    Replies: 6
    Last Post: 10-28-2015, 11:45 AM
  3. [SOLVED] Smallest difference between dates in the same column
    By TPDave in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-14-2014, 01:56 PM
  4. difference between dates, look for first column if no date go to another column.
    By clearedtoland in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-06-2013, 11:16 PM
  5. Conditionally Subtracting Dates in One Column and Averaging the Difference
    By amerain in forum Excel General
    Replies: 2
    Last Post: 03-27-2013, 11:18 AM
  6. Difference between time in same column with different dates
    By bodycode in forum Excel Formulas & Functions
    Replies: 22
    Last Post: 03-13-2013, 01:10 AM
  7. Finding a date in a specific column surounded by other columns with similar dates
    By Freakazoid in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-21-2012, 05:28 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1