Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
Like this?
=Count({<colum2=P(colum1)>} colum1)
says 5 and not 2 as it is the correct result, thank you very much, you are very close
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?
Thank you very much, have an excellent day
how would COUNT DISTINCT?