Forum home » Delegate support and help forum » Microsoft Excel Training and help » Counting types

Counting types

ResolvedVersion 2003

Mon 1 Sep 2008, 15:50 Delegate Madeleine said...

Madeleine has attended:
Excel Intermediate course

Counting types

A recap on counting types in a table (ie Region!) would be useful to go with my notes!

Thanks

Fri 12 Sep 2008, 13:23 Trainer Greg said...

RE: Counting types

Madeleine,

Thank you for your question. My name is Greg Eze and I am new to BEST and I just want to be clear.

Does your query involve using the COUNT or not?

I shall be very grateful if you could get back to me in regards to this

Greg

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Conditional formatting for cells that return text , not picked up by Go to command

If you have tried to format all cells containing text even those that display text as a result of a formula you may have had difficulty. As Go to command with constant selected does not pick up formulas that result in text.

Then try this. Select the range the formula cells appear in on your sheet. Format, select Conditional Formatting menu. In the dialog box under Condition 1, select "Formula Is" from drop down. Next to it in the Formula Box, enter the formula =Istext(A1. Click Format button , choose desired formatting settings and click OK. To go ahead and apply the conditional formatting click OK to accept

View all Excel hints and tips

Counting types

Counting types

RE: Counting types

Excel articles

Excel tip:

Conditional formatting for cells that return text , not picked up by Go to command