Determine identical ID's, then only keep max version history row of data, formula?

Question

Hello all, I'm trying to drop the amount of records based on a column of version history by max number. I need somehow to identify unique "ID's", then look at version column and only keep the highest version row of data. Anyone have any formula tips for this? I'm stuck.

In the case below, all the ID's are identical, so based on version row of 6 being the highest, I only want to keep the row of version 6 ( some rows could be a max number of 4, etc) and continue. Obviously there are many more ID's below but this is the general idea. Any idea or direction is appreciated.

JustinBabbitt · Accepted Answer

Hello @dberroth

You could use a Summarize tool to Group by the ID and retain the "Max" of the version data you are interested in keeping.

Best,

Justin

echuong1 · Accepted Answer

There are two easy ways to do this - you can use a summarize tool with a group by on ID and the max of the version, or you can sort by version descending and use the sample tool to get the first value with a group by on ID.

See examples of both attached. Let me know if that works for you!