I can't remember how I did this...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

newman - 29 Jul 2007 17:12 GMT

I have a sheet where I need the total no of entries in column C.
I have used

Text in col C =+CODE(C30) =+IF(D30>1,1)

and SUM at bottom of col E [I was not able to use COUNTA].

However when I add another entry in, say C31, D31 and E31 automatically
update although there is no formulas in these cells.

How did I manage to do that?

Regards

Reply to this Message

T. Valko - 29 Jul 2007 19:20 GMT

>Text in col C =+CODE(C30) =+IF(D30>1,1)

Hmmm....

Can't tell what you're trying to do with that!

>D31 and E31 automatically update although
>there is no formulas in these cells

2 possibilities that I can think of:

There are formulas there but you have protection set and have the cells
formatted as hidden so the cells will not display the formulas they contain.

You have an event macro that updates those cells. Right click the sheet tab
and select View Code. See anything there?

Signature

Biff
Microsoft Excel MVP

>I have a sheet where I need the total no of entries in column C.
> I have used
[quoted text clipped - 9 lines]
>
> Regards

Reply to this Message

newman - 30 Jul 2007 09:32 GMT

I am using CODE to check for text in the cell.

I have no hidden cells and no macros. Ctrl ¬ shows the existing formulas
and new ones appearing in col D and E as I enter text in col C.

Regards

> >Text in col C =+CODE(C30) =+IF(D30>1,1)
>
[quoted text clipped - 11 lines]
>
> You have an event macro that updates those cells. Right click the sheet tab

> and select View Code. See anything there?
>
[quoted text clipped - 15 lines]
> >
> > Regards

Reply to this Message

Rate this thread: