Hello!
I have 2 collumns, one is the naming and the second is the number. Second column has values ranging from 1 to 10000. I want to hide numbers in second column which are more than 1000. How can I do it ?
Old, but should still work.
To hide it a bit better from accidental copying, in the next column enter something like =IF(B2>1000;"";B2) and copy it down. Hide column B and click Tools > Protect Sheet with password if needed.
To hide the formula as well, copy the new column and Paste over it as Unformatted text before protecting sheet.
The password holder can unhide the second column at any time after entering password
1 Like
This is inconsistent, please clarify!
Tell expressly what you eventually want to achieve. See XY-problem.
…
First of all a hint:
Spreadsheets are basically made for the evaluation of formulas.
Cell contents that are hidden using ConditionalFormatting (e.g.) or by hiding (filtering out) the row(s) or by hiding column(s), or by hiding outline-groups they are placed in will still be “visible” to formulas.
This said, you need to unmistakably make clear if you actually want to hide the content only or the rows (filtering) or to exclude the values from specific evaluations - or whatever.
Thanks! This has worked well 