dave @ ptrecs
New member
- Local time
- Today, 17:34
- Joined
- Nov 20, 2006
- Messages
- 2
I'm just getting into the data collection part of a project, and have a lump of 2,600 data values to analyse. It's not difficult, but I need to truncate the numbers, so that they only show the first digit.
i.e. I want the entry '76012' to show '7', '3145' to show '3'. and so on and so forth...
I need to do this so that I can use the COUNTIF formula on the data range to count to number of leading 1s, 2s, 3s, etc. to explore Benford's Law, and it's escaping me so far.
Any help would be excellent!
i.e. I want the entry '76012' to show '7', '3145' to show '3'. and so on and so forth...
I need to do this so that I can use the COUNTIF formula on the data range to count to number of leading 1s, 2s, 3s, etc. to explore Benford's Law, and it's escaping me so far.
Any help would be excellent!