Forum home » Delegate support and help forum » Microsoft Excel Training and help » Microsoft excel

Microsoft excel

ResolvedVersion Standard

Mon 25 Feb 2008, 08:25 Delegate Jacqueline said...

Jacqueline has attended:
Excel Advanced course

Microsoft excel

How do you use the wildcards to count rows in a worksheet that contain certain letters in a specified cell (the letters will be the same but may occur in different places within the text of the cell)

Fri 29 Feb 2008, 15:56 Trainer Rajeev said...

RE: Microsoft excel

Dear Jacqueline

Thank you for attending Excel Advanced course.

I am not entirely sure of the question that you have asked. I am assuming that you want to count the cells in a row or columns that contain certain text.

Please refer to the file that I have uploaded with this post and let me know if this answers your query.

I have used COUNTIF function on Cell A1. If you click on Cell A1 you

Attached files...

Training information:

Excel tip:

Bracketed negative numbers

Often Excel users wish to display negative numbers in colour red and bracketed

Intstructions
Step1. Select Format > Cells menu options. Within Numbers tabsheet, select Category = Custom.
Step 2. Select a type such as #,##0;[Red]-#,##0;; that specifies a colour in square brackets.
Step 3. Amend as follows; #,##0;[Red](#,##0;;

Notes: Excel formatting featues are of the form
"Positive; Negative;Zero;Text" separated by semicolon.

View all Excel hints and tips