Change Columns to Letters
 

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


--
David494
------------------------------------------------------------------------
David494's Profile: http://www.excelforum.com/member.php...o&userid=24482
View this thread: http://www.excelforum.com/showthread...hreadid=391226

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


--
David494
------------------------------------------------------------------------
David494's Profile: http://www.excelforum.com/member.php...o&userid=24482
View this thread: http://www.excelforum.com/showthread...hreadid=391226

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

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"David494" wrote in
message ...

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


--
David494
------------------------------------------------------------------------
David494's Profile:
http://www.excelforum.com/member.php...o&userid=24482
View this thread: http://www.excelforum.com/showthread...hreadid=391226

"David494" wrote in
message ...

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


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

hey that worked fine

Thanks for your help, much appreciated mate

Dave


--
David494
------------------------------------------------------------------------
David494's Profile: http://www.excelforum.com/member.php...o&userid=24482
View this thread: http://www.excelforum.com/showthread...hreadid=391226

You're welcome !
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"David494" wrote in
message ...

hey that worked fine

Thanks for your help, much appreciated mate

Dave