+ Reply to Thread
Results 1 to 2 of 2

Formula that find same IDs then do the differences in size of the tree

  1. #1
    Registered User
    Join Date
    11-01-2023
    Location
    Quebec, Canada
    MS-Off Ver
    2310
    Posts
    1

    Formula that find same IDs then do the differences in size of the tree

    I need a new column in which I have the growth of the trees in my data. I have put a sample file for better understanding.
    I need a formula that identifies the same trees (ID_Tree) then do the difference of size (ST_Tree) in chronological order. Meaning if a tree (ID_Tree) has been inventoried at a newer date (DATE) it needs to do the ST_Tree of the newest tree minus the ST_Tree of the tree just older than it. A Tree can be inventoried multiple time (up to 6 times). So the formula can't just do the newest minus oldest, because I would not see the evolution between the second and third inventory or the third and fourth.

    Help_Growth_Trees.xlsx

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,671

    Re: Formula that find same IDs then do the differences in size of the tree

    Sort by ID_TREE then Date

    in I2

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as 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. [SOLVED] Want formula
    By Ali2356 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 06-09-2022, 05:26 AM
  2. Replies: 6
    Last Post: 05-20-2017, 05:00 AM
  3. Replies: 0
    Last Post: 04-13-2015, 01:01 PM
  4. [SOLVED] Transforming 1level coded product tree to few level product tree
    By Gukupozu in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-07-2015, 10:31 AM
  5. Replies: 1
    Last Post: 03-09-2015, 07:49 AM
  6. [SOLVED] Need formula or Macro to help find differences between two tables of data
    By geckony in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-08-2014, 05:27 AM
  7. Replies: 14
    Last Post: 10-25-2012, 10:33 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