| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Grouping
I have a sheet that looks like this
Col A Col B ..2 0-1 2.3 1.01-2.5 1.4 2.51-4.5 4.3 5-99 4.1 ..75 ..5 I want to the sheet to return col c so that I can group the values that are represented in col, b. so that .2,.75, anmd .5 return in col c. 0-1. any ideas? Thanks |
|
#2
|
|||
|
|||
|
What do you mean by ".2,.75, anmd .5 return in col c. 0-1"? If you mean
that column c should contain 3 corresponding to 0-1, then look at Help for COUNTIF() Jerry KenL wrote: I have a sheet that looks like this Col A Col B .2 0-1 2.3 1.01-2.5 1.4 2.51-4.5 4.3 5-99 4.1 .75 .5 I want to the sheet to return col c so that I can group the values that are represented in col, b. so that .2,.75, anmd .5 return in col c. 0-1. any ideas? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| grouping dates by week/month/etc. on cat. axis | Charts and Charting in Excel | |||
| Can I use the grouping and lock and protect cells | Excel Discussion (Misc queries) | |||
| how to format numbers, digit grouping ,as per regional settings | Excel Discussion (Misc queries) | |||
| Grouping data within intervals | Excel Worksheet Functions | |||
| How to enable grouping in a protected sheet | Excel Worksheet Functions | |||
Linear Mode
