Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to fill in a table that needs to look at two different columns to
see whether to to count the data. For example, here is some data: A B 1 10 3 2 40 2.5 3 71 4 4 124 3.5 Now to create the table, I want to know how many times something occurs between values looking at both conditions with column B data across the top and column A data along the veritcal, as below: 0-1 1.1-1.5 1.6-2 2.1-2.5 2.6-3 3.1-3.5 4 or more 0-40 41-80 81-120 121-160 Any ideas? I've tried erally long arrays but it's getting really comlicated as I add more data. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table - Changing Column Values | Excel Discussion (Misc queries) | |||
Automatically filling date of today (without it changing tomorrow) | Excel Discussion (Misc queries) | |||
Changing the range of a table sort | New Users to Excel | |||
how to pick from a range of table values | Excel Worksheet Functions | |||
changing values in a Word Table | New Users to Excel |