AV column contains numbers stored as text.
How can I use COUNTIF with that data?
I tried the below, but it does not work.
[=COUNTIF(VALUE(UDE!$AV:$AV),">69")]
Can you convert column AV to numbers, so they are easier to work with?
It is pretty easy to do this in one fellow swoop using Text to Columns on that column.
You can get this code yourself really easily by using the Macro Recorder.
Just turn on the Macro Recorder, select column AV, go to Text to Columns from the Data menu, and click Finish.
Then stop the Macro Recorder and view the code that you just recorded.
The Macro Recorder is a great tool to get snippets of code like this, without ever having to write any VBA code yourself.
Text to Columns sort of "re-imports" the data. So values that look like numbers will come in as numbers.
So it will quickly converts numbers entered as text to numbers (assuming we are talking about hard-coded values and not formulas here).
Try it an see for yourself.
You can also use Text to Columns when you want to split one column into many columns, based on width or delimiters.
It works much like the Import Wizard does.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.