THERE IS A WAY TO NOT SHOW 00/01/1900?

ON DATABASE IS BLANK, BUT WHEN I FILTER SHOW THAT DATE.

I WISH SHOW BLANK.

HERE IS THE FORMULA:
=SE(B1=””;””;CLASSIFICAR(FILTRO(B2:E40000;ÉNÚM(LOCALIZAR($B$1;B2:B40000))=VERDADEIRO;””);3;1))

EXCEL 365

WINDOWS

SYSTEM 64

​THERE IS A WAY TO NOT SHOW 00/01/1900?ON DATABASE IS BLANK, BUT WHEN I FILTER SHOW THAT DATE.I WISH SHOW BLANK.HERE IS THE FORMULA:=SE(B1=””;””;CLASSIFICAR(FILTRO(B2:E40000;ÉNÚM(LOCALIZAR($B$1;B2:B40000))=VERDADEIRO;””);3;1)) EXCEL 365WINDOWSSYSTEM 64    Read More

​