Change Columns to Letters

  • Thread starter Thread starter David494
  • Start date Start date
D

David494

I want to run a CountIf statement E.g

=COUNTIF(A1:A100,"General queries")

However, on the columns there are no letters, only numbers. So both
the rows and the colums have letters.

Does anyone know how i can change the columns from numbers to letters.

Thanks for helping

Dave
 
If anyone still knows how to do this then can you please let me know.

However, i figured out that i can just use "R2C1:R35C1" instead

Cheers

Dave
 
Does anyone know how i can change the columns from numbers to letters.

Not sure, but based on the above line, perhaps try clicking:

Tools > Options > General tab > Uncheck "R1C1 reference style > OK
 
David494 said:
If anyone still knows how to do this then can you please let me know.

However, i figured out that i can just use "R2C1:R35C1" instead
Click to expand...

Tools-Options-General and uncheck "R1C1" style box.
 
Back
Top