Show dublicates

[Anonymous]

Hi all,

I have a problem and don't get a simple idea. Hope you can help:

Company	Ticket
München	1234
Berlin	32423
Bonn	1234
Hamburg	887878
Nürnberg	766328

My aim is to get the tickets which have two or more companies.

In the case I would like to see 1234 in one list box and both cities in another list box. It works if you know the ticketnumber. But can you also show only these tickets which have two or more companies in a list box?

If you need more information, just ask.

Thank you for helping!

Robert

[kaushiknsolanki · Accepted solution]

Hi,

     What you can do is, create list box for tickets, go to properties -> expression ->

     Here add expression as count(distinct Company)

     Go to sort

     Add expression Count(Distinct Company) Descending order.

     Apply and OK.

     Now you will see the tickets which have more than one company on top and then others.

     By doing this you will know which tickets has the most unique companies.

Regards,

Kaushik Solanki

[alexandros17]

Here it is an example

[tresesco]

Try:

=Aggr(If(Count(Company)>1,Ticket),Ticket)