Show single value if repeated in listbox

[qv_bazz_10]

Hi everyone,

i have a list box with repeated values (specifically dates in format "DD/MM/YYYY") and i would like to "aggregate" them and see only one record if the value is the same, is there any way to do it?

Here's what i have now:

Here's what i would like to see:

Giorno pubblicazione flusso

08/02/2016

07/02/2016

06/02/2016

...

Thank in advance,

Andrea

[jonathandienst]

Its is important to use Sunny T's script to remove the time portion. The format you are using hides the time differences, so they appear the same in the listbox.

NOTE Date(.., 'dd/MM/yyyy') does NOT remove the time portion, it merely changes the display format. You must have a Floor() in the expression.

[jyothish8807]

Hi Andrea,

Will it be possible to share the app ? so it will be easy for us to help.

Regards

KC

[sunny_talwar]

Try this as your list box expression:

=Date(Floor([Giorno pubblicazione flusso]))

[qv_bazz_10]

Hi Sunny,

did i insert the code in the right place?

With this configuration the risult is "-" in the listbox for every date but maybe i did something wrong.

@Jyothish Kc

I'm afraid the sharing function is disabled by the admin too because i'm working on custom sheet part of a non-editable common document...

Thank you all for help and patience too.

Andrea

[sunny_talwar · Accepted solution]

Try doing it like this:

[sunny_talwar]

Also what is the name of the field? Doesn't seem to be -> Giorno pubblicazione flusso

You will need to put the field name that originally comes from the script.

[qv_bazz_10]

Got it! Thank you very much Sunny! And thanks to all the other users for your advices too.

Andrea

[sunny_talwar]

You need to thank Rob

I just proposed minor alternations

[sunny_talwar]

Awesome

I am glad we all were able to help you in one way or the other.

Best,

Sunny