| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel countif based on size of numbers in one column in Access
I have 230.000 lines in MS Acces file and would like to count numbers in one
column which are in certain range. Number can vary from -999.999 to +999.999 and need to count number of those in range of -999.999 to -10.000 next will be -9.999 to -1000 then -999 to -100 and so on up to +999.999 If anyone can give hints of how to do this, either using Excel on top of Access or brake the file down to several excel sheets in order to count range there I would be most grateful. Regards Kristjan_Thor |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert Excel imported numbers from text to numbers? | Excel Discussion (Misc queries) | |||
| A4 size Excel 2000 files wont fit | Excel Discussion (Misc queries) | |||
| Columns in Excel are numbers instead of letters, how do I change . | Excel Discussion (Misc queries) | |||
| Fonts get size 1 and can't be changed after a procedure - even by excel GUI!! | Charts and Charting in Excel | |||
| Excel should be able to compute the MOD of large numbers. | Excel Worksheet Functions | |||
Threaded Mode
