Excel - Showing documents by it's latest version number only

Hello all,

Apologies if this has been asked, but wasn't able to find anything.

I have a basic spreadsheet with two columns. 'Document Identification Number' and 'Version Number'

I want to bring up a list of all documents by it's latest version number only. Is this possible? Some documents have at least 15 versions and want to avoid a huge list with duplicate values.

I've been looking at VLOOKUP but have been getting a bit lost!

Many thanks

What defines the most recent version number?

Is it the biggest number? is the value even a number?
Is it the number furthest down the column?

lookup(2,1/(range of documents=document name),range of version numbers) may be what you want, but following the yellow banner will get you a better answer as we can not see the format of the data


https://trumpexcel.com/find-last-occurrence/

Hi,

Appreciate the speedy reply.

That definitely looks like what I'm after. You are right, the value for the version is just a number, and want to bring up a list of document IDs showing only the largest version value number for a particular document ID.

if your office version is 2019 or 365 you can use maxifs

otherwise if the most recent version is not the furthers down a column max(if(document name= range of document names,range of version numbers,0)) entered with control shift enter as it is an array

the easiest might just to do a pivot table with product name as the rows, and version number as the value , you can change from the default of sum, to max)