Vlookup to find Max Instance

Jen K.

Hello,

I used the below formula in a Smartsheet to count the instances of a value and it worked perfectly. I have a second sheet were I am now trying to use a vlookup to pull in the highest instance of that product.

=COUNTIFS(Product:Product, @cell = Product@row, [Auto-Number]:[Auto-Number], @cell >= [Auto-Number]@row)

Example:

Sheet 1

Product A Instance 1

Product A Instance 2

Sheet 2

Product A —> Instance 2

Could someone help?

Thank you!

Jason Tarpinian

You can use the MAX + COLLECT functions to do this. On a single sheet, it would look something like this:

=MAX(COLLECT(Number:Number, Product:Product, [Product Lookup]@row))

Jason Tarpinian

You can use the MAX + COLLECT functions to do this. On a single sheet, it would look something like this:

=MAX(COLLECT(Number:Number, Product:Product, [Product Lookup]@row))

Jen K.

Jason, thank you for your help!