lundi 13 juillet 2020

How can I get a list of cells that exceed a certain length?

I have a massive Google Sheet and I'm trying to get a list of cells that would exceed a certain number of characters.

I've tried various methods, but I can't seem to get what I'm looking for. Since this would be across multiple sheets, I would much rather use a portable formula than setting up a filter with conditional formatting. Any ideas? Thank you.

Aucun commentaire:

Enregistrer un commentaire