Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I need to show the following information split into two different columns
0 55 60 62 65 70 72 55 60 62 65 70 72 75 - column X 60 62 65 70 72 - column X 62 65 70 - column X 65 - column X 70 70 72 72 75 75 - column AA 72 72 75 75 - column AA 75 75 - column AA Example 1 If the insured age is between ages 0 and 54 column X will have 55, 60, 62, 65 and column AA will have 70, 72, 75 Example 2 If the insured age is between ages 60 and 61 column X will have 62, 65, 70 and column AA will have 72, 75 Can Excel condense this information to one column of numbers (rather than the seven shown above) and provide the desires split (between columns X and AA)? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
keep the formatting of the cell found using Hlookup | Excel Discussion (Misc queries) | |||
Vlookup and Hlookup | Excel Worksheet Functions | |||
How do I find a value in an array (VLOOKUP? HLOOKUP?) | New Users to Excel | |||
Hlookup to return a sum of values | Excel Worksheet Functions | |||
SUMIF - HLOOKUP Combination | Excel Worksheet Functions |