Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 30th 06, 07:41 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
Posts: 4
Default two columns range of numbers need to list all numbers in the range

have two columns range of numbers i need to list each number in the range
start end
5 9
15 19
20 29
i need for each row to show the numbers in the range
5
6
7
8
9
15
16
..
..
pls help

Was this post helpful to you?



  #2   Report Post  
Old October 30th 06, 08:53 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default two columns range of numbers need to list all numbers in the range

Check your other post.

arsovat wrote:

have two columns range of numbers i need to list each number in the range
start end
5 9
15 19
20 29
i need for each row to show the numbers in the range
5
6
7
8
9
15
16
.
.
pls help

Was this post helpful to you?


--

Dave Peterson
  #3   Report Post  
Old October 30th 06, 09:21 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,907
Default two columns range of numbers need to list all numbers in the range

You have an answer to the first two times you posted this question.

Dave Peterson's first reply.

http://groups.google.com/group/micro...25450b1936131b


Gord Dibben MS Excel MVP


On Mon, 30 Oct 2006 10:41:01 -0800, arsovat
wrote:

have two columns range of numbers i need to list each number in the range
start end
5 9
15 19
20 29
i need for each row to show the numbers in the range
5
6
7
8
9
15
16
.
.
pls help

Was this post helpful to you?




Reply
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
Condensing a list of numbers into a range Grandpoobah Excel Discussion (Misc queries) 1 August 28th 06 02:50 AM
auto updating list Larry Excel Worksheet Functions 8 July 27th 06 01:59 PM
How to Change List Based on Value Chosen in Another List Edwin Kelly Excel Worksheet Functions 4 March 2nd 06 08:31 PM
move list of numbers from one column to multiple columns coach eo Excel Discussion (Misc queries) 12 February 16th 06 09:12 PM
List of items appeared in range realspido Excel Worksheet Functions 1 February 9th 06 12:30 PM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017