Identify duplicates based on multiple criterion

NJ smartsheet

Hi,

The thing is that i want to find all "name" based on criterion "TL" and date "2022.12". If "name" will repeat few times i want that formula show me only single value, name.

markkrebs

do you want to count the number of times that match exists or are you trying to remove the duplicate values?

NJ smartsheet

i want to find all the names based on criteria, but if specific names duplicates i want to see only one time and remove duplicate value.

For example if formula find "jonas+jonas" i want to see only "jonas".

It's difficult to explain me correctly :)

Paul Newcome

Are you able to manually enter data to show what you are wanting to accomplish?

NJ smartsheet

Hi,

Data will be entered manually, yes :)