Formula Query

[Bradley H Callender]

What formula would i have to use to show the number of "Y" in a single colmun?"

 

[njimack]

=countif(a:a,"y")

 

[Bradley H Callender]

Thank you.

Another question: how do you split on cell in half?

 

[njimack]

I don't understand the question. Please post a sample of your data and expected output.

 

[Bradley H Callender]

say we have "A1" how can i spilt that column in half?

 

[njimack]

say we have "A1" how can i spilt that column in half?

Again, I don't understand. Are you saying you want to split the contents of A1 between A1 and A2?

Please post a sample of your data and expected output

 

[Bradley H Callender]

I need a macro code to enable me to move a value to another celll if the conditional formatting is 60 or over.


Thanks in advance

 

[njimack]

I need a macro code to enable me to move a value to another celll if the conditional formatting is 60 or over.

Conditional formatting changes the format of the cell, not it's value.

 

[Bradley H Callender]

i don't think you understand if the conditional formatting in one cell = 60 or greater then i want the value you in the cell the move to another cell

 

[njimack]