LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 275
Default Variable Range of Values

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
SUMPRODUCT or SUMIF if any values in a range equal any values in another range PCLIVE Excel Worksheet Functions 3 July 15th 09 07:43 PM
Variable Range James C. Excel Discussion (Misc queries) 3 April 2nd 09 12:41 AM
Sum of values in variable range Lawman Excel Discussion (Misc queries) 5 March 30th 08 01:13 PM
from Range variable Marina Limeira Excel Discussion (Misc queries) 0 January 22nd 06 02:35 PM
Variable range in VB famdamly Excel Discussion (Misc queries) 2 January 22nd 06 02:29 PM


All times are GMT +1. The time now is 09:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"