Countif statement from Excel to Calc

English
, ,
#1

New to LibreOffice from Excel. I uses the below formula to see if the numbers on one sheet are in the other and then give a true or false statement. This is written in Excel. Can some one help me with converting it to LibreOffice Calc please?

=IF(COUNTIF(Sheet2!$A$1:$AK$99, E1)>0, TRUE,FALSE)

Thanks

#2

Try =IF(COUNTIF(Sheet2.A$1:$AK$99, E1)>0, TRUE,FALSE)

#3

That works, Thanks

#4

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.