Comparation

[Anonymous]

have

colum1 colum2

1          2

2          3

3          4

4          6

5          8

I need to count what records in column 1 are in column 2

thnxs

[stigchel]

Like this?

=Count({<colum2=P(colum1)>} colum1)

[Anonymous]

says 5 and not 2 as it is the correct result, thank you very much, you are very close

[stigchel · Accepted solution]

For me it says 3 because 2,3,4 of colum1 are also in colum2, see attached

What is the logic for 2 being the correct result?

[Anonymous]

Thank you very much, have an excellent day

[Anonymous]

how would COUNT DISTINCT?