Simple formula A1 =B1

[kaseyleigh]

Hi

I have 31 columns which I want to check if they contain the same text "period end"
Is there an easy way of doing this?

Much appreciated

[gutkinma]

Hi,

If you just want to count how many columns say 'Period end', use:

=countif(A1:Z1,"period end")

A1:Z1 - change to the range where you are looking for the text.

Hope this helps

[Debraj Roy]

try this...

Please Login or Register  to view this content.

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

[kaseyleigh]

Sweeeeet! Thanks!!!

Out of interest - is there a way to do with an array formula?

[kaseyleigh]

YES!

Just seen your post after I sent mine
Thanks!!

[Debraj Roy]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.