How to create a range in excel?

10dulkar

New Member
Joined
Aug 18, 2004
Messages
42
Hi guys

Hopefully a simple question:

I have the following data in excel:

1 12
2 15
3 10
4 9
5 16
6 13
7 11
8 8
9 18
10 20

what is the easiest way to create a range so that the data looks like this:

1 12 11-15
2 15 11-15
3 10 6-10
4 9 6-10
5 16 and so on....
6 13
7 11
8 8
9 18
10 20


thanks a ton in advance!
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Greg Truby

MrExcel MVP
Joined
Jun 19, 2002
Messages
10,014
<ul>[*]=FLOOR(A1-0.001,5)+1 & " - " & CEILING(A1,5)[/list]And copy down.
 

Watch MrExcel Video

Forum statistics

Threads
1,111,599
Messages
5,541,166
Members
410,543
Latest member
ExcelGlenn
Top