![]() See screenshot above:Īnd now cells containing the certain value are selected at once, and simultaneously a dialog box will come out and show how many cells are selected. In the opening Select Specific Cells dialog box, please check the Cell option, select Contains from the first drop down list in the Specific type section, and type the certain value you will find into following box. Select the column you will find in, and click Kutools > Select > Select Specific Cells. Full feature free trial 30-day, no credit card required! Get It Nowġ. ![]() ![]() Kutools for Excel- Includes more than 300 handy tools for Excel. ![]() If you have Kutools for Excel installed, you can apply its Select Specific Cells feature to quickly look for a certain value from a range, and count the occurrences if it exists in Excel.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |