Forum Discussion
COUNTIF Formula Help - Embed another formula
Hi! I have been trying to figure out a formula within a formula, and cannot get it right. I have two sheets, Sheet1 and Sheet 2. On Sheet 1 I have a column of names. Some of the names are duplicated ...
Olá Junebug!
Basta usar a célula de referencia na planilha 2 em vez do valor.
=CONT.SE(Planilha1!A:A;Planilha2!A1)
Veja o arquivo em anexo.