Search : in
By :

Counting cells in excel 2007

ujo, on Sep 23, 2009 11:15:46 am BST 
 Report this message to moderators

Hello,

In excel 2007 i want to count the cells that contains particular cell icons (Conditional formating icons).
Please help. An option to filter and sort cells based on the cell icons is available - however i am unable to count the number of such cells.

Regards
Ujo

Configuration: Windows XP Internet Explorer 8.0

Best answers for « Counting cells in excel 2007 » in :
Set the first letter of a word in capital ShowSet the first letter of a word/phrase in capital Gsed 4.0 and higher sed 's/^./\u&/' Example : $ echo "how are you" | sed 's/^./\u&/' How are you $ echo -e "how are you/ everything alright" | sed 's/^./\u&/' How are...
Capitalize the 1st letter of each word ShowCapitalize the 1st letter of each word Below are two ways to proceed: Method 1 sed-r 's /(^.|.) / \ U & / g' Method 2 sed 's / ^. \ | [a-z] / \ U & / g' Method 3 sed-r 's / \
Avoid duplicates in Excel ShowAvoid duplicates in Excel In order to avoid duplication when encoding in a column from an excel sheet: take the conditional format on the first cell under the headings (eg A2) choose the following formula:...
Spreadsheets - The Excel Interface ShowExcel Introduction Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel...
Ask your question Reply
They need your help