duplicates formula

Hi Experts:

I would like to identify the duplicated in column Model# and than mark the once which have the lowest article#. The one marked in red are the once which should be marked in column model count.

It's getting complicate as the article# is build out of letter and numbers, it's build in alphabetical order.

Do you have an idea for a formula.

I started with this, but not sure how to check the article number.

=IF(AND(COUNTIFS([Model#]:[Model#], [Model#]@row, [article#]:[article#], <>"") > 0, [Article#]:[Article#] > [Article#]@row ?????????????), true, false)

Thanks

image.png


Tags:

Best Answers

«1

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!