| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Matching a single value, with a value category.
I'm trying to figure out how I can easily match a list of numbers into a set
category. For example. I have the number 11. I have the categories 1-10, 11-19, 20-29, ... and so on. Next to the value of 11, I want it to list the category it's in (11-19). And for the number 86 below it, and the number 25 below that. Can anyone help me figure this out. I tried using VLookUp but to no avail. Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Printing single pages from multiple worksheets in a single print job | Excel Discussion (Misc queries) | |||
| Query on Category & Sub-category | Excel Discussion (Misc queries) | |||
| Combine non-matching dates in single chart | Charts and Charting in Excel | |||
| Find Multiple instances of Single Criterion in Row & Return To a Single Col | Excel Worksheet Functions | |||
| Matching data and linking it to the matching cell | Links and Linking in Excel | |||
Threaded Mode
