Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to get a formula to put the values from a list together into one
cell, but the length of the lists are all different lengths and styles. Here are two examples of the lists I'm dealing with and what I'm trying to do: A B C 1 AZ2_MO 5-12 2 -7 3 -8 4 AZ3A 01 5 02 6 03 7 04 8 05 9 06 10 07 11 08 12 09 13 10 14 11 15 97 16 -7 17 -8 In cell C1 I would like to have the value: 5-12,-7,-8 In cell C4 I would like to have the value: 01-11,97,-7,-8 Thanks for any help! This discussion board has taught me more than I ever thought there was to know about excel, and I find I learn something new every day! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SUMPRODUCT or SUMIF if any values in a range equal any values in another range | Excel Worksheet Functions | |||
Variable Range | Excel Discussion (Misc queries) | |||
Sum of values in variable range | Excel Discussion (Misc queries) | |||
from Range variable | Excel Discussion (Misc queries) | |||
Variable range in VB | Excel Discussion (Misc queries) |