Match Value if Date stays the same

I have a table where there are multiple values for a specific date and time. These are always the same values and are written underneath, which outputs a table like:

1.1.01 00:01 20
1.1.01 00:01 10
1.1.01. 02:05 20

I want to write a “!” in every row with the same date if the value in the second column is 20 for at least one time. Is that possible?

Hi Lilly,

are the dates and the times in two separate columns or in the same one? And do you want to write the “!” in a separate column or append it to one of the existing ones?

Cheers,
Simon

Date and Time are in one column and I want to append a column with the “!”

I created an example workflow for you. Perhaps, there is an easier way but this should work:

Best,
Simon

3 Likes

Thank you very much, this works excellently!

3 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.