Forum Discussion
searching a sheet with a true and false function
- Apr 02, 2018
Hi Felix,
The problem isn't in Excel, it's in the computer BIOS settings.
The function keys are not in function mode, but are in multimedia mode by default!
You can change this so that you don't have to press the combination of Fn+F4 each time you want to lock the cell.
To do that, open the BIOS settings on the computer startup, and then find the responsible option to change the function keys mode!
Check this link.
Hope that helps
Haytham
- Aaron_excelFeb 26, 2020Copper Contributor
Thank you so much! My google searches gave me everything but hard coding text. Saved my bacon!PReagan
- PReaganFeb 26, 2020Bronze Contributor
- Aaron_excelFeb 26, 2020Copper Contributor
=AND(COUNT(SEARCH({"*pencil*"},B2))>0,COUNT(SEARCH({"*case*","*color*","*colored*","*grip*","*eraser*","*mechanical*","*sharpener*"},B2))=0)
The above formula is what I created giving me a true or false in the cell. Is there a way to count how many came back true? Also Can I search just for the cells that came back true? I am trying to navigate with thousands of rows. PReagan